Install Language Pack in SharePoint

Build CAML Query Dynamically based on Passing Parameters to the Query in SharePoint.

string camlQuery = CreateCAMLQuery(parameters); 

private static string CreateCAMLQuery(string[] parameters)

        {

            StringBuilder sb = new StringBuilder(); 

            if (parameters.Length == 0)

            {

                AppendEQ(sb, "all", "all");

            }

            for (int i = 0; i < parameters.Length; i += 2)

            {

                AppendEQ(sb, parameters[i], parameters[i + 1]);

                if (i > 0)

                {

                    sb.Insert(0, "<And>");

                    sb.Append("</And>");

                }

            }

            sb.Insert(0, "<Where>");

            sb.Append("</Where>"); 

            return sb.ToString();

        }

        private static void AppendEQ(StringBuilder sb, string column, string value)

        {

            sb.Append("<Eq>");

            if (column == "state")

            {

                sb.Append("<FieldRef Name='state'/>");

                sb.AppendFormat("<Value Type='Lookup'>{0}</Value>", value);

            }

            if (column == "City")

            {

                sb.Append("<FieldRef Name='City'/>");

                sb.AppendFormat("<Value Type='Lookup'>{0}</Value>", value);

            }

            if (column == "VehicleMake")

            {

                sb.Append("<FieldRef Name='VehicleMake'/>");

                sb.AppendFormat("<Value Type='Choice'>{0}</Value>", value);

            }

            if (column == "GarageType")

            {

                sb.Append("<FieldRef Name='GarageType'/>");

                sb.AppendFormat("<Value Type='Choice'>{0}</Value>", value);

            }

            sb.Append("</Eq>");

        }

Rating WebPart using AverageRatingFieldControl in SharePoint

1. Add Rating on a Layout Page:-

--------------------------------------------

1.       Open any layout page add below ‘Rate this article” div code

<asp:content contentplaceholderid="PlaceHolderMain" runat="server">

       <div class="welcome blank-wp">

           <div>

              Rate this article:

              <SharePointPortalControls:AverageRatingFieldControl

             ID="PageRatingControl"    

             FieldName="AverageRating"    

             runat="server"/>           

              </div>

2.       Enable rating feature for a pages list form list settings.

3.       Open a page which using page layout having rating field control

4.       Give the rating on page and go to list page and check. Total no.of ratings is increased.

---------------------------------------------------------------------------------------------------------------------------------------------------- 

2. Rating WebPart in SharePoint:-

--------------------------------------------------

RatingVisualWebPart.ascx:-

--------------------------

<%@ Assembly Name="$SharePoint.Project.AssemblyFullName$" %>

<%@ Assembly Name="Microsoft.Web.CommandUI, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register TagPrefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls"Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register TagPrefix="Utilities" Namespace="Microsoft.SharePoint.Utilities"Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register TagPrefix="asp" Namespace="System.Web.UI" Assembly="System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %>

<%@ Import Namespace="Microsoft.SharePoint" %>

<%@ Register TagPrefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages"Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="RatingVisualWebPart.ascx.cs" Inherits="Rating.RatingVisualWebPart.RatingVisualWebPart"%>

<%@ Register TagPrefix="SharePointPortalControls"

    Namespace="Microsoft.SharePoint.Portal.WebControls"

    Assembly="Microsoft.SharePoint.Portal, Version=14.0.0.0,Culture=neutral,PublicKeyToken=71e9bce111e9429c" %>

<%--<span class="content_small_text">

    <SharePointPortalControls:averageratingfieldcontrol id="rating" runat="server" controlmode="Edit"/>

</span>--%>

<span class="content_small_text">

    <asp:Panel ID="pnl1" runat="server">

    </asp:Panel>

</span>

RatingVisualWebPart.ascx.cs:-

----------------------------------------------

using System;

using System.ComponentModel;

using System.Web.UI.WebControls.WebParts;

using Microsoft.SharePoint.Portal;

using Microsoft.SharePoint;

using Microsoft.SharePoint.Portal.WebControls;

using Microsoft.SharePoint.WebControls;

using System.Web;

namespace Rating.RatingVisualWebPart

{

    [ToolboxItemAttribute(false)]

    public partial class RatingVisualWebPart : WebPart

    {

        public RatingVisualWebPart()

        { }

        protected override void OnInit(EventArgs e)

        {

            base.OnInit(e);

            InitializeControl();

        }

        protected void Page_Load(object sender, EventArgs e)

        {

            HttpContext context = HttpContext.Current;

            SPList testList = SPContext.Current.Web.Lists.TryGetList("Pages");

            SPListItem testItem = testList.GetItemById(249);

            AverageRatingFieldControl ratingCntrl = new AverageRatingFieldControl();

            ratingCntrl.ID = "RatingCntrl";

            ratingCntrl.ListId = testList.ID;

            ratingCntrl.ControlMode = SPControlMode.Edit;

            ratingCntrl.FieldName = "AverageRating";

            ratingCntrl.ItemContext = SPContext.GetContext(context, testItem.ID, testList.ID, SPContext.Current.Web);

            pnl1.Controls.Add(ratingCntrl);

            AverageRatingFieldControl arfcRating = new AverageRatingFieldControl();

            arfcRating.ID = "rating";

            arfcRating.ListId = testList.ID;

            arfcRating.FieldName = "Rating (0-5)";

            arfcRating.ControlMode = SPControlMode.Edit;

            arfcRating.ItemContext = SPContext.GetContext(context, testItem.ID,testItem.ParentList.ID, testItem.ListItems.List.ParentWeb);

            pnl1.Controls.Add(arfcRating);

        }

    }

}

Send E-Mail from C# Code

try

            {

                StringBuilder strMailContent = new StringBuilder();

                MailMessage mail = new MailMessage();

                String toName = "tomail@company.net";

                String fromName = "frommail@company.net";

                String strMessage = "Test Message from C# Code";

                String strSMTPAddress = "xxx.xxx.xxx.xxx";

                String strUserName = "domain_forest_name";

                String strPassword = "domain_pwd";

                String strDomain = "domain_name";

                mail.To.Add(toName);

                mail.From = new MailAddress(fromName);

                mail.Subject = "test mail from C# code. " +DateTime.Now.ToString("F"); //("MMM ddd d HH:mm yyyy");

                strMailContent.Append("<html><body><table>");

                strMailContent.Append("<tr><td>Dear " + toName + "</td></tr>");

                strMailContent.Append("</table>");

                strMailContent.Append("</body></html></table>");

                mail.Body = strMailContent.ToString();

                SmtpClient smtp = new SmtpClient(strSMTPAddress);

                smtp.Credentials = new System.Net.NetworkCredential(strUserName, strPassword, strDomain);

                smtp.Send(mail);

            }

            catch (Exception ex) {

                SPDiagnosticsService diagnosticsService = SPDiagnosticsService.Local;

                string errorMsg = ex.Message;

                diagnosticsService.WriteTrace(0, new SPDiagnosticsCategory("AleartSettingTimerJob", TraceSeverity.Monitorable, EventSeverity.Error),TraceSeverity.Monitorable, "Writing to the ULS log: {0}", new object[] { errorMsg });

                diagnosticsService.WriteEvent(0, new SPDiagnosticsCategory("AleartSettingTimerJob", TraceSeverity.Monitorable, EventSeverity.Error),EventSeverity.Error, "Writing to the Event Viewer log: {0}", new object[] { errorMsg });

            }

Send SMS to mobile form C# Code

Send SMS to mobile form C# Code:-

---------------------------------

String uName = "uname";

String pwd = "password";

String strSender = "";

string PhNo = "";

string Msg = "Text Message 160 plain characters";

String strErrMsg = "";

string url = "http://www.unicel.in/SendSMS/sendmsg.php?uname=" + uName + "&pass=" + pwd + "&send=" + strSender + "&dest=91" + PhNo.ToString() + "&msg=" + Msg.ToString();

HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);

HttpWebResponse response = (HttpWebResponse)request.GetResponse();

String ver = response.ProtocolVersion.ToString();

StreamReader reader = new StreamReader(response.GetResponseStream());

strErrMsg = reader.ReadLine();

reader.Close();

--------------------------------------------------------------------------------------------