public static List <PurchaseApprovers> PurchaseApproversData(PurchaseOrder purchaseDataFinal, string RootsiteUrl, string siteUrl, string listName, string EmaillistName) { List <PurchaseApprovers> _returnList = new List <PurchaseApprovers>(); try { using (MSC.ClientContext context = CustomSharePointUtility.GetEmpContext(RootsiteUrl)) { 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> <Eq> <FieldRef Name='Division' LookupId='True'/> <Value Type='Lookup'>" + purchaseDataFinal.DivisionID + "</Value></Eq>"; camlQuery.ViewXml += @"<Eq> <FieldRef Name ='Location' LookupId='True'/> <Value Type='Lookup'>" + purchaseDataFinal.LocationID + "</Value></Eq>"; camlQuery.ViewXml += @"</And></Where> </Query> <RowLimit>5000</RowLimit> <ViewFields> <FieldRef Name='ID'/> <FieldRef Name='ApproverName'/> <FieldRef Name='ApproverType'/> </ViewFields></View>"; MSC.ListItemCollection Items = list.GetItems(camlQuery); context.Load(Items); context.ExecuteQuery(); itemPosition = Items.ListItemCollectionPosition; foreach (MSC.ListItem item in Items) { _returnList.Add(new PurchaseApprovers { ApproverName = item["ApproverName"] == null ? "" : Convert.ToString((item["ApproverName"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), ApproverType = Convert.ToString(item["ApproverType"]).Trim(), }); } if (itemPosition == null) { break; // TODO: might not be correct. Was : Exit While } } } } } catch (Exception ex) { CustomSharePointUtility.WriteLog("Error in PurchaseApproversData()" + " Error:" + ex.Message); } for (var i = 0; i < _returnList.Count; i++) { if (_returnList[i].ApproverType == "MD" || _returnList[i].ApproverType == "JMD") { String MDorJMD = _returnList[i].ApproverName; var success = CustomSharePointUtility.EmailData(purchaseDataFinal, "", "", "", MDorJMD, siteUrl, EmaillistName); if (success) { } } else if (_returnList[i].ApproverType == "PURCHASE HEAD") { String PurchaseHead = _returnList[i].ApproverName; var success = CustomSharePointUtility.EmailData(purchaseDataFinal, "", PurchaseHead, "", "", siteUrl, EmaillistName); if (success) { } } else if (_returnList[i].ApproverType == "PLANT HEAD") { String PlantHead = _returnList[i].ApproverName; var success = CustomSharePointUtility.EmailData(purchaseDataFinal, "", "", PlantHead, "", siteUrl, EmaillistName); if (success) { } } } return(_returnList); }
public static List <EmployeeMaster> EmployeeMasterData(PurchaseOrder purchaseDataFinal, string RootsiteUrl, string siteUrl, string listName, string EmaillistName) { List <EmployeeMaster> _returnList = new List <EmployeeMaster>(); try { using (MSC.ClientContext context = CustomSharePointUtility.GetEmpContext(RootsiteUrl)) { 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> <Eq> <FieldRef Name='Employee_x0020_Code'/> <Value Type='text'>" + purchaseDataFinal.FHCode + "</Value></Eq>"; camlQuery.ViewXml += @"</Where> </Query> <RowLimit>5000</RowLimit> <ViewFields> <FieldRef Name='ID'/> <FieldRef Name='Employee_x0020_Code'/> <FieldRef Name='Employee_x0020_Email'/> </ViewFields></View>"; MSC.ListItemCollection Items = list.GetItems(camlQuery); context.Load(Items); context.ExecuteQuery(); itemPosition = Items.ListItemCollectionPosition; foreach (MSC.ListItem item in Items) { _returnList.Add(new EmployeeMaster { Employee_x0020_Code = Convert.ToString(item["Employee_x0020_Code"]).Trim(), Employee_x0020_Email = Convert.ToString(item["Employee_x0020_Email"]).Trim(), }); } if (itemPosition == null) { break; // TODO: might not be correct. Was : Exit While } } } } } catch (Exception ex) { CustomSharePointUtility.WriteLog("Error in EmployeeMasterData()" + " Error:" + ex.Message); } var success = CustomSharePointUtility.EmailData(purchaseDataFinal, _returnList[0].Employee_x0020_Email, "", "", "", siteUrl, EmaillistName); if (success) { } return(_returnList); }