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);
}
