private static List <DOC10_Responses> getResponseList(DataSet resultSet)
{
List <DOC10_Responses> listResponse = new List <DOC10_Responses>();
foreach (DataRow item in resultSet.Tables[2].Rows)
{
var response = new DOC10_Responses();
response.ResponseId = Convert.ToInt32(item["ResponseId"]);
response.Response = Convert.ToString(item["Response"]);
listResponse.Add(response);
}
return(listResponse);
}
public static JobActivationChecklist JobActivationLookup(JobActivationChecklist objActivation)
{
try
{
var resultSet = SqlHelper.ExecuteDataset(_myConnection, CommandType.StoredProcedure,
"spATL_PRJ_JobActChkLst_LkUp",
new SqlParameter("@PRJID", objActivation.PRJID));
objActivation.ListCustomersTypes = new List <DOC08_CustomerType>();
foreach (DataRow item in resultSet.Tables[0].Rows)
{
var customer = new DOC08_CustomerType();
customer.CustomerTypeID = Convert.ToInt32(item["CustomerTypeId"]);
customer.Description = Convert.ToString(item["Description"]);
objActivation.ListCustomersTypes.Add(customer);
}
objActivation.ListJobTypes = new List <DOC09_JobTypes>();
foreach (DataRow item in resultSet.Tables[1].Rows)
{
var jobType = new DOC09_JobTypes();
jobType.JobTypeId = Convert.ToInt32(item["JobTypeId"]);
jobType.JobTypeDesc = Convert.ToString(item["JobTypeDesc"]);
objActivation.ListJobTypes.Add(jobType);
}
objActivation.ListResponses = new List <DOC10_Responses>();
foreach (DataRow item in resultSet.Tables[2].Rows)
{
var response = new DOC10_Responses();
response.ResponseId = Convert.ToInt32(item["ResponseId"]);
response.Response = Convert.ToString(item["Response"]);
objActivation.ListResponses.Add(response);
}
objActivation.ListLabourTypes = new List <SYS10_MhRates>();
foreach (DataRow item in resultSet.Tables[3].Rows)
{
var labourType = new SYS10_MhRates();
labourType.MhRateId = Convert.ToString(item["MhRateId"]);
labourType.MhRateName = Convert.ToString(item["MhRateName"]);
objActivation.ListLabourTypes.Add(labourType);
}
objActivation.ListUsers = new List <Sys_UsersData>();
foreach (DataRow item in resultSet.Tables[4].Rows)
{
var usersData = new Sys_UsersData();
usersData.UserId = Convert.ToInt32(item["UserId"]);
usersData.Name = Convert.ToString(item["Name"]);
objActivation.ListUsers.Add(usersData);
}
foreach (DataRow item in resultSet.Tables[5].Rows)
{
objActivation.PRJID = Convert.ToInt32(item["ProjectHeaderId"]);
objActivation.projectInformation.JobNumber = Convert.ToString(item["Atlas_Job_Number"]);
objActivation.projectInformation.CompanyName = Convert.ToString(item["Atlas_Company_Name"]);
objActivation.projectInformation.CustomerProfile = new Profile();
objActivation.projectInformation.CustomerProfile.Name = Convert.ToString(item["Contractor_Name"]);
objActivation.projectInformation.CustomerProfile.Address = Convert.ToString(item["Contractor_Address"]);
objActivation.projectInformation.CustomerProfile.City = Convert.ToString(item["Contractor_City"]);
objActivation.projectInformation.CustomerProfile.State = Convert.ToString(item["Contractor_State"]);
objActivation.projectInformation.CustomerProfile.Zip = Convert.ToString(item["Contractor_Zip"]);
objActivation.projectInformation.CustomerProfile.PhoneNumber = Convert.ToString(item["Contractor_Phone"]);
//TODO: Check Ext, Contact
//objActivation.projectInformation.CustomerProfile.Extension = Convert.ToString(item["Contractor_PhoneExt"]);
//objActivation.projectInformation.CustomerProfile.ContactName = Convert.ToString(item["Contractor_Contact"]);
objActivation.projectInformation.ProjectProfile = new Profile();
objActivation.projectInformation.ProjectProfile.Name = Convert.ToString(item["JobName"]);
objActivation.projectInformation.ProjectProfile.Address = Convert.ToString(item["JobAddress"]);
objActivation.projectInformation.ProjectProfile.City = Convert.ToString(item["JobCity"]);
objActivation.projectInformation.ProjectProfile.State = Convert.ToString(item["JobState"]);
objActivation.projectInformation.ProjectProfile.Zip = Convert.ToString(item["JobZip"]);
objActivation.projectInformation.ProjectProfile.PhoneNumber = Convert.ToString(item["JobPhone"]);
//TODO:
//objActivation.projectInformation.ProjectProfile.Extension = Convert.ToString(item["Job_PhoneExt"]);
objActivation.projectInformation.ProjectProfile.ContactName = Convert.ToString(item["JobContact"]);
objActivation.projectInformation.Estimator = Convert.ToString(item["EstimatorsName"]);
}
if (resultSet.Tables[5].Rows.Count == 0)
{
objActivation.PRJID = 0;
}
}
catch (Exception ex)
{
Logger.SaveErr(ex);
throw ex;
}
return(objActivation);
}