public EmployeeModel CheckNewEntry(string EMPCode, string siteUrl) { int returnVal = 0; EmployeeModel employeeModels = new EmployeeModel(); using (MSC.ClientContext context = GetContext(siteUrl)) { var dataDateValue = DateTime.Today; MSC.List list = context.Web.Lists.GetByTitle("TIM_DailyAttendance"); MSC.ListItemCollectionPosition itemPosition = null; var q = new CamlQuery() { ViewXml = "<View><Query><Where><And><Eq><FieldRef Name='EmpNo' /><Value Type='Text'>" + EMPCode + "</Value></Eq><Eq><FieldRef Name='AttendanceDate' /><Value Type='Text'>" + dataDateValue.ToString("dd-MM-yyyy") + "</Value></Eq></And></Where></Query></View>" }; MSC.ListItemCollection Items = list.GetItems(q); context.Load(Items); context.ExecuteQuery(); itemPosition = Items.ListItemCollectionPosition; returnVal = Items.Count; if (returnVal > 0) { employeeModels.ID = Items[0]["ID"].ToString(); employeeModels.count = Items.Count; } else { employeeModels.count = Items.Count; } } return(employeeModels); }
public static List <Employee> GetEnterEstimate(string month, string year, string listname, string siteUrl) { List <Employee> _returnEmployee = new List <Employee>(); try { using (MSC.ClientContext context = CustomSharePointUtility.GetContext(siteUrl)) { if (context != null) { MSC.List SalesEstimateEmployee = context.Web.Lists.GetByTitle(listname); MSC.ListItemCollectionPosition itemPosition = null; string fromday = year + "-" + month + "-" + "1"; string Today = year + "-" + month + "31"; while (true) { MSC.CamlQuery camlQuery = new MSC.CamlQuery(); camlQuery.ListItemCollectionPosition = itemPosition; camlQuery.ViewXml = @"<View><Query><Where> <Eq><FieldRef Name='Date' /> <Value IncludeTimeValue='FLASE' Type='DateTime'>" + fromday + "</Value></Eq>"; camlQuery.ViewXml += @" </Where></Query> <RowLimit>5000</RowLimit> <FieldRef Name='ID'/> <FieldRef Name='EmployeeName'/> <FieldRef Name='Author'/> <FieldRef Name='Created'/> </View>"; MSC.ListItemCollection Items = SalesEstimateEmployee.GetItems(camlQuery); context.Load(Items); context.ExecuteQuery(); itemPosition = Items.ListItemCollectionPosition; foreach (MSC.ListItem item in Items) { _returnEmployee.Add(new Employee { EmployeeName = Convert.ToString((item["EmployeeName"] as Microsoft.SharePoint.Client.FieldUserValue).LookupValue), EmployeeID = Convert.ToString((item["EmployeeName"] as Microsoft.SharePoint.Client.FieldUserValue).LookupId) }); } if (itemPosition == null) { break; // TODO: might not be correct. Was : Exit While } } } } } catch (Exception ex) { } return(_returnEmployee); }
//public static List<PurchaseOrder> GetAll_PurchaseOrderFromSharePoint(string siteUrl, string listName, string DaysDifference) //{ // List<PurchaseOrder> _retList = new List<PurchaseOrder>(); // 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> // <Eq> // <FieldRef Name='ApprovalStatus'/> // <Value Type='text'>Submitted</Value> // </Eq> // <Eq> // <FieldRef Name='ApprovalStatus'/> // <Value Type='text'>Approved By Functional Head</Value> // </Eq> // </Or> // <Or> // <Eq> // <FieldRef Name='ApprovalStatus'/> // <Value Type='text'>Approved By Purchase Head</Value> // </Eq> // <Eq> // <FieldRef Name='ApprovalStatus'/> // <Value Type='text'>Approved By Plant Head</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='POReferenceNumber'/> // <FieldRef Name='Author'/> // <FieldRef Name='Created'/> // <FieldRef Name='DepartmentName'/> // <FieldRef Name='DepartmentID'/> // <FieldRef Name='LocationName'/> // <FieldRef Name='LocationID'/> // <FieldRef Name='LocationType'/> // <FieldRef Name='DivisionName'/> // <FieldRef Name='DivisionID'/> // <FieldRef Name='PONumber'/> // <FieldRef Name='POCost'/> // <FieldRef Name='MaterialDetails'/> // <FieldRef Name='ApprovalStatus'/> // <FieldRef Name='FHCode'/> // <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 PurchaseOrder // { // Id = Convert.ToInt32(item["ID"]), // POReferenceNumber = Convert.ToString(item["POReferenceNumber"]).Trim(), // Author = Convert.ToString((item["Author"] as Microsoft.SharePoint.Client.FieldUserValue).LookupValue), // Created = Convert.ToString(item["Created"]).Trim(), // DepartmentName = Convert.ToString(item["DepartmentName"]).Trim(), // DepartmentID = Convert.ToString(item["DepartmentID"]).Trim(), // LocationName = Convert.ToString(item["LocationName"]).Trim(), // LocationID = Convert.ToString(item["LocationID"]).Trim(), // LocationType = Convert.ToString(item["LocationType"]).Trim(), // ////Author = Convert.ToString((item["Author"] as Microsoft.SharePoint.Client.FieldUserValue).LookupId), // //Author = Convert.ToString((item["Author"] as Microsoft.SharePoint.Client.FieldUserValue).LookupValue), // //FunctionalHead = Convert.ToString((item["FunctionalHead"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), // //HRHead = Convert.ToString((item["HRHead"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), // //HRHeadOnly = Convert.ToString((item["HRHeadOnly"] as Microsoft.SharePoint.Client.FieldUserValue).LookupId), // //MDorJMD = item["MDorJMD"] == null ? "" : Convert.ToString((item["MDorJMD"] as Microsoft.SharePoint.Client.FieldUserValue).LookupId), // //Recruiter = Convert.ToString((item["Recruiter"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), // DivisionName = Convert.ToString(item["DivisionName"]).Trim(), // DivisionID = Convert.ToString(item["DivisionID"]).Trim(), // PONumber = Convert.ToString(item["PONumber"]).Trim(), // POCost = Convert.ToString(item["POCost"]).Trim(), // MaterialDetails = Convert.ToString(item["MaterialDetails"]).Trim(), // ApprovalStatus = Convert.ToString(item["ApprovalStatus"]).Trim(), // FHCode = Convert.ToString(item["FHCode"]).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_ManpowerRequisitionFromSharePoint()" + " Error:" + ex.Message); // } // return _retList; //} #endregion /// New Code to Get Employee /// public static List <Employee> GetEmployees(string siteUrl, string listName) { List <Employee> _returnEmployee = new List <Employee>(); try { using (MSC.ClientContext context = CustomSharePointUtility.GetContext(siteUrl)) { if (context != null) { MSC.List HODList = context.Web.Lists.GetByTitle(listName); MSC.ListItemCollectionPosition itemPosition = null; while (true) { MSC.CamlQuery camlQuery = new MSC.CamlQuery(); camlQuery.ListItemCollectionPosition = itemPosition; camlQuery.ViewXml = @"<View><Query><Where> <Eq><FieldRef Name='Reminder' /><Value Type='Choice'>Yes</Value></Eq> </Where></Query> <RowLimit>5000</RowLimit> <FieldRef Name='ID'/> <FieldRef Name='EmployeeName'/> <FieldRef Name='Author'/> <FieldRef Name='Created'/> </View>"; MSC.ListItemCollection Items = HODList.GetItems(camlQuery); context.Load(Items); context.ExecuteQuery(); itemPosition = Items.ListItemCollectionPosition; foreach (MSC.ListItem item in Items) { _returnEmployee.Add(new Employee { EmployeeName = Convert.ToString((item["EmployeeName"] as Microsoft.SharePoint.Client.FieldUserValue).LookupValue), EmployeeID = Convert.ToString((item["EmployeeName"] as Microsoft.SharePoint.Client.FieldUserValue).LookupId) }); } if (itemPosition == null) { break; // TODO: might not be correct. Was : Exit While } } } } } catch (Exception ex) { } return(_returnEmployee); }
public static List <ErrorModel> GetActiveErrorList(string siteUrl, string listName) { List <ErrorModel> errorModels = new List <ErrorModel>(); 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) { MSC.CamlQuery camlQuery = new MSC.CamlQuery(); camlQuery.ListItemCollectionPosition = itemPosition; camlQuery.ViewXml = @"<View><Query><Where><Eq><FieldRef Name='SystemUpdated' /><Value Type='Choice'>No</Value></Eq></Where></Query><ViewFields><FieldRef Name='UserDisplayName' /><FieldRef Name='DisplayNo' /><FieldRef Name='URL' /><FieldRef Name='SystemUpdated' /><FieldRef Name='ID' /></ViewFields><QueryOptions /></View>"; MSC.ListItemCollection Items = list.GetItems(camlQuery); context.Load(Items); context.ExecuteQuery(); itemPosition = Items.ListItemCollectionPosition; foreach (MSC.ListItem item in Items) { errorModels.Add(new ErrorModel { ID = Convert.ToInt32(item["ID"]), URL = Convert.ToString(item["URL"]).Trim(), SystemUpdate = Convert.ToString(item["SystemUpdated"]).Trim(), }); } if (itemPosition == null) { break; // TODO: might not be correct. Was : Exit While } } } } } catch (Exception ex) { } return(errorModels); }
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); }
public static List <PurchaseOrder> GetAll_PurchaseOrderFromSharePoint(string siteUrl, string listName, string DaysDifference) { List <PurchaseOrder> _retList = new List <PurchaseOrder>(); 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> <Eq> <FieldRef Name='ApprovalStatus'/> <Value Type='text'>Submitted</Value> </Eq> <Eq> <FieldRef Name='ApprovalStatus'/> <Value Type='text'>Approved By Functional Head</Value> </Eq> </Or> <Or> <Eq> <FieldRef Name='ApprovalStatus'/> <Value Type='text'>Approved By Purchase Head</Value> </Eq> <Eq> <FieldRef Name='ApprovalStatus'/> <Value Type='text'>Approved By Plant Head</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='POReferenceNumber'/> <FieldRef Name='Author'/> <FieldRef Name='Created'/> <FieldRef Name='DepartmentName'/> <FieldRef Name='DepartmentID'/> <FieldRef Name='LocationName'/> <FieldRef Name='LocationID'/> <FieldRef Name='LocationType'/> <FieldRef Name='DivisionName'/> <FieldRef Name='DivisionID'/> <FieldRef Name='PONumber'/> <FieldRef Name='POCost'/> <FieldRef Name='MaterialDetails'/> <FieldRef Name='ApprovalStatus'/> <FieldRef Name='FHCode'/> <FieldRef Name='Modified'/> <FieldRef Name='CurrentApprover'/> <FieldRef Name='NewStatus'/> <FieldRef Name='NewFlow'/> </ViewFields></View>"; // camlQuery.ViewXml = "<View><Query><Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>769</Value></Eq></Where></Query></View>"; MSC.ListItemCollection Items = list.GetItems(camlQuery); context.Load(Items); context.ExecuteQuery(); itemPosition = Items.ListItemCollectionPosition; foreach (MSC.ListItem item in Items) { _retList.Add(new PurchaseOrder { Id = Convert.ToInt32(item["ID"]), POReferenceNumber = Convert.ToString(item["POReferenceNumber"]).Trim(), Author = Convert.ToString((item["Author"] as Microsoft.SharePoint.Client.FieldUserValue).LookupValue), Created = Convert.ToString(item["Created"]).Trim(), DepartmentName = Convert.ToString(item["DepartmentName"]).Trim(), DepartmentID = Convert.ToString(item["DepartmentID"]).Trim(), LocationName = Convert.ToString(item["LocationName"]).Trim(), LocationID = Convert.ToString(item["LocationID"]).Trim(), LocationType = Convert.ToString(item["LocationType"]).Trim(), ////Author = Convert.ToString((item["Author"] as Microsoft.SharePoint.Client.FieldUserValue).LookupId), //Author = Convert.ToString((item["Author"] as Microsoft.SharePoint.Client.FieldUserValue).LookupValue), //FunctionalHead = Convert.ToString((item["FunctionalHead"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), //HRHead = Convert.ToString((item["HRHead"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), //HRHeadOnly = Convert.ToString((item["HRHeadOnly"] as Microsoft.SharePoint.Client.FieldUserValue).LookupId), //MDorJMD = item["MDorJMD"] == null ? "" : Convert.ToString((item["MDorJMD"] as Microsoft.SharePoint.Client.FieldUserValue).LookupId), //Recruiter = Convert.ToString((item["Recruiter"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), DivisionName = Convert.ToString(item["DivisionName"]).Trim(), DivisionID = Convert.ToString(item["DivisionID"]).Trim(), PONumber = Convert.ToString(item["PONumber"]).Trim(), POCost = Convert.ToString(item["POCost"]).Trim(), MaterialDetails = Convert.ToString(item["MaterialDetails"]).Trim(), ApprovalStatus = Convert.ToString(item["ApprovalStatus"]).Trim(), FHCode = Convert.ToString(item["FHCode"]).Trim(), Modified = Convert.ToString(item["Modified"]).Trim(), CurrentApprover = Convert.ToString(item["CurrentApprover"]).Trim(), NewStatus = Convert.ToString(item["NewStatus"]).Trim(), NewFlow = Convert.ToString(item["NewFlow"]).Trim(), }); } if (itemPosition == null) { break; // TODO: might not be correct. Was : Exit While } } } } } catch (Exception ex) { CustomSharePointUtility.WriteLog("Error in GetAll_ManpowerRequisitionFromSharePoint()" + " Error:" + ex.Message); } return(_retList); }
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 List <ExpenseVoucher> GetAll_TravelVoucherFromSharePoint(string siteUrl, string listName, string DaysDifference) { List <ExpenseVoucher> _retList = new List <ExpenseVoucher>(); 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; // Temp //////camlQuery.ViewXml = @"<View> ////// <Query> ////// <Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>6118</Value></Eq></Where> ////// </Query> ////// <RowLimit>4000</RowLimit> ////// <ViewFields> ////// <FieldRef Name='ID'/> ////// <FieldRef Name='ExpVoucherNo'/> ////// <FieldRef Name='CreatorName'/> ////// <FieldRef Name='CreatorDepartment'/> ////// <FieldRef Name='CreatorLocation'/> ////// <FieldRef Name='Destination'/> ////// <FieldRef Name='VisitDate'/> ////// <FieldRef Name='StatusCode'/> ////// <FieldRef Name='StatusName'/> ////// <FieldRef Name='AssignUser'/> ////// <FieldRef Name='FunctionalHead'/> ////// <FieldRef Name='SequenceNo'/> ////// <FieldRef Name='CreationDate'/> ////// <FieldRef Name='AssignDate'/> ////// <FieldRef Name='TotalCost'/> ////// <FieldRef Name='EmployeeName'/> ////// <FieldRef Name='EmployeeNumber'/> ////// <FieldRef Name='Designation'/> ////// <FieldRef Name='ActionTaken'/> ////// <FieldRef Name='CompanyCode'/> ////// <FieldRef Name='DivisionName'/> ////// <FieldRef Name='Modified'/> ////// <FieldRef Name='CurrentApprove'/> ////// <FieldRef Name='AccountApprover'/> ////// <FieldRef Name='AccountUserApproved'/> ////// </ViewFields></View>"; camlQuery.ViewXml = @"<View> <Query> <Where> <And> <Eq> <FieldRef Name='StatusCode'/> <Value Type='Text'>P</Value> </Eq> <Leq><FieldRef Name='Modified'/><Value Type='DateTime'>" + dataDateValue.ToString("o") + "</Value></Leq>"; camlQuery.ViewXml += @"</And> </Where> </Query> <RowLimit>4000</RowLimit> <ViewFields> <FieldRef Name='ID'/> <FieldRef Name='ExpVoucherNo'/> <FieldRef Name='CreatorName'/> <FieldRef Name='CreatorDepartment'/> <FieldRef Name='CreatorLocation'/> <FieldRef Name='Destination'/> <FieldRef Name='VisitDate'/> <FieldRef Name='StatusCode'/> <FieldRef Name='StatusName'/> <FieldRef Name='AssignUser'/> <FieldRef Name='FunctionalHead'/> <FieldRef Name='SequenceNo'/> <FieldRef Name='CreationDate'/> <FieldRef Name='AssignDate'/> <FieldRef Name='TotalCost'/> <FieldRef Name='EmployeeName'/> <FieldRef Name='EmployeeNumber'/> <FieldRef Name='Designation'/> <FieldRef Name='ActionTaken'/> <FieldRef Name='CompanyCode'/> <FieldRef Name='DivisionName'/> <FieldRef Name='Modified'/> <FieldRef Name='CurrentApprove'/> <FieldRef Name='AccountApprover'/> <FieldRef Name='AccountUserApproved' /> </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 ExpenseVoucher { Id = Convert.ToInt32(item["ID"]), ExpVoucherNo = Convert.ToString(item["ExpVoucherNo"]).Trim(), CreatorName = Convert.ToString((item["CreatorName"] as Microsoft.SharePoint.Client.FieldUserValue).LookupValue), CreatorDepartment = Convert.ToString(item["CreatorDepartment"]).Trim(), CreatorLocation = Convert.ToString(item["CreatorLocation"]).Trim(), Destination = Convert.ToString(item["Destination"]).Trim(), VisitDate = Convert.ToString(item["VisitDate"]).Trim(), StatusCode = Convert.ToString(item["StatusCode"]).Trim(), StatusName = Convert.ToString(item["StatusName"]), AssignUser = item["AssignUser"] == null ? "" : Convert.ToString((item["AssignUser"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), FunctionalHead = item["FunctionalHead"] == null ? "" : Convert.ToString(item["FunctionalHead"]).Trim(), CreationDate = Convert.ToString(item["CreationDate"]).Trim(), AssignDate = Convert.ToString(item["AssignDate"]).Trim(), SequenceNo = Convert.ToString(item["SequenceNo"]).Trim(), EmployeeName = Convert.ToString(item["EmployeeName"]).Trim(), EmployeeNumber = Convert.ToString(item["EmployeeNumber"]).Trim(), Designation = Convert.ToString(item["Designation"]).Trim(), ActionTaken = Convert.ToString(item["ActionTaken"]).Trim(), CompanyCode = Convert.ToString(item["CompanyCode"]), DivisionName = Convert.ToString(item["DivisionName"]), Modified = Convert.ToString(item["Modified"]), CurrentApprove = item["CurrentApprove"] == null ? "" : Convert.ToString((item["CurrentApprove"] as Microsoft.SharePoint.Client.FieldUserValue).LookupId), AccountApprover = item["AccountApprover"] == null ? "" : Convert.ToString((item["AccountApprover"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), AccountUserApproved = item["AccountUserApproved"] == null ? "" : Convert.ToString(item["AccountUserApproved"]) // AccountUserApproved = Convert.ToString(item["AccountUserApproved"]) }); } if (itemPosition == null) { break; // TODO: might not be correct. Was : Exit While } } } } } catch (Exception ex) { CustomSharePointUtility.WriteLog("Error in GetAll_EmployeeDetailsFromSharePoint()" + " Error:" + ex.Message); } return(_retList); }
public static List <ManpowerRequisition> GetAll_ManpowerRequisitionFromSharePoint(string siteUrl, string listName, string DaysDifference) { List <ManpowerRequisition> _retList = new List <ManpowerRequisition>(); 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='Status' LookupId='True'/> <Value Type='Lookup'>2</Value> </Eq> <Eq> <FieldRef Name='Status' LookupId='True'/> <Value Type='Lookup'>4</Value> </Eq> </Or> <Or> <Eq> <FieldRef Name='Status' LookupId='True'/> <Value Type='Lookup'>6</Value> </Eq> <Eq> <FieldRef Name='Status' LookupId='True'/> <Value Type='Lookup'>8</Value> </Eq> </Or> </Or> <Eq> <FieldRef Name='Status' LookupId='True'/> <Value Type='Lookup'>9</Value> </Eq> </Or> <And> <Eq> <FieldRef Name='IsRejected'/> <Value Type='Boolean'>No</Value> </Eq> <Leq><FieldRef Name='Modified'/><Value Type='DateTime'>" + dataDateValue.ToString("o") + "</Value></Leq>"; camlQuery.ViewXml += @"</And></And></Where></Query> <RowLimit>4000</RowLimit> <ViewFields> <FieldRef Name='ID'/> <FieldRef Name='RequisitionNumber'/> <FieldRef Name='Department'/> <FieldRef Name='CreatorLocation'/> <FieldRef Name='RequisitionDate'/> <FieldRef Name='Designation'/> <FieldRef Name='Division'/> <FieldRef Name='Author'/> <FieldRef Name='FunctionalHead'/> <FieldRef Name='HRHead'/> <FieldRef Name='HRHeadOnly'/> <FieldRef Name='MDorJMD'/> <FieldRef Name='Recruiter'/> <FieldRef Name='Status'/> <FieldRef Name='IsRejected'/> <FieldRef Name='CreatedTime'/> <FieldRef Name='ReplacementEmployeeName'/> <FieldRef Name='AdditionalBudgets'/> <FieldRef Name='Modified'/> <FieldRef Name='CurrentApprover'/> </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 ManpowerRequisition { Id = Convert.ToInt32(item["ID"]), RequisitionNumber = Convert.ToString(item["RequisitionNumber"]).Trim(), Department = Convert.ToString(item["Department"]).Trim(), CreatorLocation = Convert.ToString(item["CreatorLocation"]).Trim(), RequisitionDate = Convert.ToString(item["RequisitionDate"]).Trim(), Designation = Convert.ToString(item["Designation"]).Trim(), Division = Convert.ToString(item["Division"]).Trim(), //Author = Convert.ToString((item["Author"] as Microsoft.SharePoint.Client.FieldUserValue).LookupId), // AuthorName = Convert.ToString((item["Author"] as Microsoft.SharePoint.Client.FieldUserValue).LookupValue), FunctionalHeadName = item["FunctionalHead"] == null?"" : Convert.ToString((item["FunctionalHead"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupValue), HRHeadName = item["HRHead"] == null ? "" : Convert.ToString((item["HRHead"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupValue), HRHeadOnlyName = item["HRHeadOnly"] == null ? "" : Convert.ToString((item["HRHeadOnly"] as Microsoft.SharePoint.Client.FieldUserValue).LookupValue), MDorJMDName = item["MDorJMD"] == null ? "" : Convert.ToString((item["MDorJMD"] as Microsoft.SharePoint.Client.FieldUserValue).LookupValue), RecruiterName = item["Recruiter"] == null ? "" : Convert.ToString((item["Recruiter"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupValue), CurrentApproverName = item["CurrentApprover"] == null ? "" : Convert.ToString((item["CurrentApprover"] as Microsoft.SharePoint.Client.FieldUserValue).LookupValue), FunctionalHead = item["FunctionalHead"] == null ? "" : Convert.ToString((item["FunctionalHead"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), HRHead = item["HRHead"] == null ? "" : Convert.ToString((item["HRHead"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), HRHeadOnly = item["HRHeadOnly"] == null ? "" : Convert.ToString((item["HRHeadOnly"] as Microsoft.SharePoint.Client.FieldUserValue).LookupId), MDorJMD = item["MDorJMD"] == null ? "" : Convert.ToString((item["MDorJMD"] as Microsoft.SharePoint.Client.FieldUserValue).LookupId), Recruiter = item["Recruiter"] == null ? "" : Convert.ToString((item["Recruiter"] as Microsoft.SharePoint.Client.FieldUserValue[])[0].LookupId), CurrentApprover = item["CurrentApprover"] == null ? "" : Convert.ToString((item["CurrentApprover"] as Microsoft.SharePoint.Client.FieldUserValue).LookupId), Status = Convert.ToString((item["Status"] as Microsoft.SharePoint.Client.FieldLookupValue).LookupValue), IsRejected = Convert.ToString(item["IsRejected"]).Trim(), CreatedTime = Convert.ToString(item["CreatedTime"]).Trim(), ReplacementEmployeeName = Convert.ToString(item["ReplacementEmployeeName"]).Trim(), AdditionalBudgets = Convert.ToString(item["AdditionalBudgets"]).Trim(), Modified = Convert.ToString(item["Modified"]), }); } if (itemPosition == null) { break; // TODO: might not be correct. Was : Exit While } } } } } catch (Exception ex) { CustomSharePointUtility.WriteLog("Error in GetAll_ManpowerRequisitionFromSharePoint()" + " Error:" + ex.Message); } return(_retList); }