public static List <ITAssets> GetAll_AssetsDetailsFromSharePoint(string siteUrl, string listName, string DaysDifference) { List <ITAssets> _retList = new List <ITAssets>(); try { using (MSC.ClientContext context = CustomSharePointUtility.GetContext(siteUrl)) { if (context != null) { MSC.List list = context.Web.Lists.GetByTitle(listName); MSC.ListItemCollectionPosition itemPosition = null; while (true) { var dataDateValue = DateTime.Now.AddDays(-Convert.ToInt32(DaysDifference)); MSC.CamlQuery camlQuery = new MSC.CamlQuery(); camlQuery.ListItemCollectionPosition = itemPosition; camlQuery.ViewXml = @"<View> <Query> <Where> <And> <Or> <Or> <Or> <Eq> <FieldRef Name='StatusId'/> <Value Type='Number'>0</Value> </Eq> <Eq> <FieldRef Name='StatusId'/> <Value Type='Number'>1</Value> </Eq> </Or> <Or> <Eq> <FieldRef Name='StatusId'/> <Value Type='Number'>4</Value> </Eq> <Eq> <FieldRef Name='StatusId'/> <Value Type='Number'>5</Value> </Eq> </Or> </Or> <Or> <Eq> <FieldRef Name='StatusId'/> <Value Type='Number'>6</Value> </Eq> <Eq> <FieldRef Name='StatusId'/> <Value Type='Number'>7</Value> </Eq> </Or> </Or> <Leq><FieldRef Name='Modified'/><Value Type='DateTime'>" + dataDateValue.ToString("o") + "</Value></Leq>"; camlQuery.ViewXml += @"</And> </Where> </Query> <RowLimit>5000</RowLimit> <ViewFields> <FieldRef Name='ID'/> <FieldRef Name='RequisitionNo'/> <FieldRef Name='EmployeeName'/> <FieldRef Name='Department'/> <FieldRef Name='Location'/> <FieldRef Name='Designation'/> <FieldRef Name='Status'/> <FieldRef Name='AssignedApprover'/> <FieldRef Name='Business'/> <FieldRef Name='StartOn'/> <FieldRef Name='FunctionalHead'/> <FieldRef Name='ReportingTo'/> <FieldRef Name='NewJoineeEmpName'/> <FieldRef Name='WorkLevel'/> <FieldRef Name='ConnectivityDevice'/> <FieldRef Name='ReplacementEmployeeName'/> <FieldRef Name='Asset'/> <FieldRef Name='NewEmployeeDesignation'/> <FieldRef Name='StatusId'/> <FieldRef Name='Modified'/> </ViewFields></View>"; MSC.ListItemCollection Items = list.GetItems(camlQuery); context.Load(Items); context.ExecuteQuery(); itemPosition = Items.ListItemCollectionPosition; foreach (MSC.ListItem item in Items) { _retList.Add(new ITAssets { Id = Convert.ToInt32(item["ID"]), RequisitionNo = Convert.ToString(item["RequisitionNo"]).Trim(), EmployeeName = Convert.ToString(item["EmployeeName"]).Trim(), Department = Convert.ToString(item["Department"]).Trim(), Location = Convert.ToString(item["Location"]).Trim(), Designation = Convert.ToString(item["Designation"]).Trim(), Status = Convert.ToString(item["Status"]).Trim(), StatusId = Convert.ToString(item["StatusId"]).Trim(), AssignedApprover = item["AssignedApprover"] == null ? "" : Convert.ToString((item["AssignedApprover"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), //Business = item["AssignedApprover"] == null ? "" : Convert.ToString((item["AssignedApprover"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), Business = Convert.ToString(item["Business"]).Trim(), StartOn = Convert.ToString(item["StartOn"]).Trim(), FunctionalHead = item["FunctionalHead"] == null ? "" : Convert.ToString((item["FunctionalHead"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), ReportingTo = item["ReportingTo"] == null ? "" : Convert.ToString((item["ReportingTo"] as Microsoft.SharePoint.Client.FieldUserValue).LookupValue), NewJoineeEmpName = Convert.ToString(item["NewJoineeEmpName"]).Trim(), ReplacementEmployeeName = Convert.ToString(item["ReplacementEmployeeName"]).Trim(), NewEmployeeDesignation = Convert.ToString(item["NewEmployeeDesignation"]).Trim(), Asset = Convert.ToString(item["Asset"]).Trim(), Modified = Convert.ToString(item["Modified"]).Trim(), }); } if (itemPosition == null) { break; // TODO: might not be correct. Was : Exit While } } } } } catch (Exception ex) { CustomSharePointUtility.WriteLog("Error in GetAll_AssetsDetailsFromSharePoint()" + " Error:" + ex.Message); } return(_retList); }
public static bool EmailData(List <ITAssets> updationList, string siteUrl, string listName) { bool retValue = false; try { using (MSC.ClientContext context = CustomSharePointUtility.GetContext(siteUrl)) { //List<Mailing> varx = new List<Mailing>(); MSC.List list = context.Web.Lists.GetByTitle(listName); for (var i = 0; i < updationList.Count; i++) { var updateList = updationList.Skip(i).Take(1).ToList(); if (updateList != null && updateList.Count > 0) { foreach (var updateItem in updateList) { MSC.ListItem listItem = null; MSC.ListItemCreationInformation itemCreateInfo = new MSC.ListItemCreationInformation(); listItem = list.AddItem(itemCreateInfo); var obj = new Object(); //Mailing data = new Mailing(); //var _From = ""; var _To = ""; //var _Cc = ""; var _Body = ""; var _Subject = ""; if (updateItem.StatusId == "0") { _To = updateItem.FunctionalHead; } else { _To = updateItem.AssignedApprover; } _Subject = "Gentle Reminder"; // + updateItem.ExpVoucherNo + " Travel Voucher Approval is Pending _Body += "Dear User, <br><br>This is to inform you that below request is pending for your Approval."; _Body += "<br><b>Workflow Name :</b> IT Asset Requisition "; _Body += "<br><b>Request No :</b> " + updateItem.RequisitionNo; _Body += "<br><b>Date of Requisition :</b> " + updateItem.StartOn; _Body += "<br><b>Requested By : </b> " + updateItem.EmployeeName; _Body += "<br><b>Location :</b> " + updateItem.Location; _Body += "<br><b>Department :</b> " + updateItem.Department; _Body += "<br><b>Designation :</b> " + updateItem.Designation; _Body += "<br><b>Buisness :</b> " + updateItem.Business; _Body += "<br><b>Reporting to :</b> " + updateItem.ReportingTo; if (updateItem.Asset == "Desktop") { _Body += "<br><b>IT Asset Request for :</b> " + updateItem.Asset; } else { _Body += "<br><b>Based on Work Level :</b> " + updateItem.Asset; } _Body += "<br><b>New Joinee Employee :</b> " + updateItem.NewJoineeEmpName; _Body += "<br><b>New Employee designation :</b> " + updateItem.NewEmployeeDesignation; _Body += "<br><b>Replacement Of :</b> " + updateItem.ReplacementEmployeeName; if (updateItem.StatusId == "0") { _Body += "<br><b>Status :</b> " + updateItem.Status; } else if (updateItem.StatusId == "1") { _Body += "<br><b>Status :</b> " + updateItem.Status; } else if (updateItem.StatusId == "4") { _Body += "<br><b>Status :</b> " + updateItem.Status; } else if (updateItem.StatusId == "5") { _Body += "<br><b>Status :</b> " + updateItem.Status; } else if (updateItem.StatusId == "6") { _Body += "<br><b>Status :</b> " + updateItem.Status; } else if (updateItem.StatusId == "7") { _Body += "<br><b>Status :</b> " + updateItem.Status; } _Body += "<br><h3>Kindly provide your approval</h3>"; _Body += "<br><h3>For Approval Please Click in the below link</h3>"; if (updateItem.StatusId == "0") { _Body += "<br><a href=\"https://aparindltd.sharepoint.com/ITAssetRequisition/SitePages/PendingForMe.aspx?StatusId=" + updateItem.StatusId + "&RequisitionNo=\">View Link</a>"; } else if (updateItem.StatusId == "1") { _Body += "<br><a href=\"https://aparindltd.sharepoint.com/ITAssetRequisition/SitePages/PendingForMe.aspx?StatusId=" + updateItem.StatusId + "&RequisitionNo=\">View Link</a>"; } else if (updateItem.StatusId == "4") { _Body += "<br><a href=\"https://aparindltd.sharepoint.com/ITAssetRequisition/SitePages/PendingForMe.aspx?StatusId=" + updateItem.StatusId + "&RequisitionNo=\">View Link</a>"; } else if (updateItem.StatusId == "5") { _Body += "<br><a href=\"https://aparindltd.sharepoint.com/ITAssetRequisition/SitePages/PendingForMe.aspx?StatusId=" + updateItem.StatusId + "&RequisitionNo=\">View Link</a>"; } else if (updateItem.StatusId == "6") { _Body += "<br><a href=\"https://aparindltd.sharepoint.com/ITAssetRequisition/SitePages/PendingForMe.aspx?StatusId=" + updateItem.StatusId + "&RequisitionNo=\">View Link</a>"; } else if (updateItem.StatusId == "7") { _Body += "<br><a href=\"https://aparindltd.sharepoint.com/ITAssetRequisition/SitePages/PendingForMe.aspx?StatusId=" + updateItem.StatusId + "&RequisitionNo=\">View Link</a>"; } //data.MailTo = _From; //data.MailTo = _To; //data.MailCC = _Cc; //data.MailSubject = _Subject; //data.MailBody = _Body; //varx.Add(data); listItem["ToUser"] = _To; listItem["MailSubject"] = _Subject; listItem["MailBody"] = _Body; listItem.Update(); } try { context.ExecuteQuery(); retValue = true; } catch (Exception ex) { CustomSharePointUtility.WriteLog(string.Format("Error in InsertUpdate_EmployeeMaster ( context.ExecuteQuery();): Error ({0}) ", ex.Message)); return(false); //continue; } } } } } catch (Exception ex) { CustomSharePointUtility.WriteLog(string.Format("Error in InsertUpdate_EmployeeMaster: Error ({0}) ", ex.Message)); } return(retValue); }