public List <ServiceCall> GetAllServiceCall(ServiceCallAdvanceSearch serviceCallAdvanceSearch)
{
List <ServiceCall> serviceCallList = null;
try
{
using (SqlConnection con = _databaseFactory.GetDBConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandText = "[PSA].[GetAllServiceCall]";
if (string.IsNullOrEmpty(serviceCallAdvanceSearch.SearchTerm))
{
cmd.Parameters.AddWithValue("@SearchValue", DBNull.Value);
}
else
{
cmd.Parameters.Add("@SearchValue", SqlDbType.NVarChar, -1).Value = serviceCallAdvanceSearch.SearchTerm;
}
cmd.Parameters.Add("@RowStart", SqlDbType.Int).Value = serviceCallAdvanceSearch.DataTablePaging.Start;
if (serviceCallAdvanceSearch.DataTablePaging.Length == -1)
{
cmd.Parameters.AddWithValue("@Length", DBNull.Value);
}
else
{
cmd.Parameters.Add("@Length", SqlDbType.Int).Value = serviceCallAdvanceSearch.DataTablePaging.Length;
}
cmd.Parameters.Add("@FromDate", SqlDbType.DateTime).Value = serviceCallAdvanceSearch.AdvFromDate;
cmd.Parameters.Add("@Todate", SqlDbType.DateTime).Value = serviceCallAdvanceSearch.AdvToDate;
if (serviceCallAdvanceSearch.AdvCustomerID == Guid.Empty)
{
cmd.Parameters.AddWithValue("@CustomerID", DBNull.Value);
}
else
{
cmd.Parameters.Add("@CustomerID", SqlDbType.UniqueIdentifier).Value = serviceCallAdvanceSearch.AdvCustomerID;
}
if (serviceCallAdvanceSearch.AdvBranchCode == null)
{
cmd.Parameters.AddWithValue("@BranchCode", DBNull.Value);
}
else
{
cmd.Parameters.Add("@BranchCode", SqlDbType.Int).Value = serviceCallAdvanceSearch.AdvBranchCode;
}
if (serviceCallAdvanceSearch.AdvAreaCode == null)
{
cmd.Parameters.AddWithValue("@AreaCode", DBNull.Value);
}
else
{
cmd.Parameters.Add("@AreaCode", SqlDbType.Int).Value = serviceCallAdvanceSearch.AdvAreaCode;
}
if (serviceCallAdvanceSearch.AdvAttendedBy == Guid.Empty)
{
cmd.Parameters.AddWithValue("@AttendedBy", DBNull.Value);
}
else
{
cmd.Parameters.Add("@AttendedBy", SqlDbType.UniqueIdentifier).Value = serviceCallAdvanceSearch.AdvAttendedBy;
}
if (serviceCallAdvanceSearch.AdvServiceTypeCode == null)
{
cmd.Parameters.AddWithValue("@ServiceTypeCode", DBNull.Value);
}
else
{
cmd.Parameters.Add("@ServiceTypeCode", SqlDbType.Int).Value = serviceCallAdvanceSearch.AdvServiceTypeCode;
}
if (serviceCallAdvanceSearch.AdvServicedBy == Guid.Empty)
{
cmd.Parameters.AddWithValue("@ServicedBy", DBNull.Value);
}
else
{
cmd.Parameters.Add("@ServicedBy", SqlDbType.UniqueIdentifier).Value = serviceCallAdvanceSearch.AdvServicedBy;
}
cmd.Parameters.Add("@DocumentStatusCode", SqlDbType.Int).Value = serviceCallAdvanceSearch.AdvDocumentStatusCode;
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if ((sdr != null) && (sdr.HasRows))
{
serviceCallList = new List <ServiceCall>();
while (sdr.Read())
{
ServiceCall serviceCall = new ServiceCall();
{
serviceCall.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : serviceCall.ID);
serviceCall.ServiceCallNo = (sdr["ServiceCallNo"].ToString() != "" ? sdr["ServiceCallNo"].ToString() : serviceCall.ServiceCallNo);
serviceCall.ServiceCallDate = (sdr["ServiceCallDate"].ToString() != "" ? DateTime.Parse(sdr["ServiceCallDate"].ToString()) : serviceCall.ServiceCallDate);
serviceCall.ServiceCallDateFormatted = (sdr["ServiceCallDate"].ToString() != "" ? DateTime.Parse(sdr["ServiceCallDate"].ToString()).ToString(_settings.DateFormat) : serviceCall.ServiceCallDateFormatted);
serviceCall.ServiceCallTime = (sdr["ServiceCallTime"].ToString() != "" ? DateTime.Parse(sdr["ServiceCallTime"].ToString()) : serviceCall.ServiceCallTime);
serviceCall.ServiceCallTimeFormatted = (sdr["ServiceCallTime"].ToString() != "" ? DateTime.Parse(sdr["ServiceCallTime"].ToString()).ToString("h:mm tt") : serviceCall.ServiceCallTimeFormatted);
serviceCall.CustomerID = (sdr["CustomerID"].ToString() != "" ? Guid.Parse(sdr["CustomerID"].ToString()) : serviceCall.CustomerID);
serviceCall.Customer = new Customer();
serviceCall.CustomerID = (sdr["CustomerID"].ToString() != "" ? Guid.Parse(sdr["CustomerID"].ToString()) : serviceCall.Customer.ID);
serviceCall.Customer.CompanyName = (sdr["CompanyName"].ToString() != "" ? sdr["CompanyName"].ToString() : serviceCall.Customer.CompanyName);
serviceCall.Customer.ContactPerson = (sdr["ContactPerson"].ToString() != "" ? sdr["ContactPerson"].ToString() : serviceCall.Customer.ContactPerson);
serviceCall.Customer.Mobile = (sdr["CustomerMobile"].ToString() != "" ? sdr["CustomerMobile"].ToString() : serviceCall.Customer.Mobile);
serviceCall.DocumentStatusCode = (sdr["DocumentStatusCode"].ToString() != "" ? int.Parse(sdr["DocumentStatusCode"].ToString()) : serviceCall.DocumentStatusCode);
serviceCall.DocumentStatus = new DocumentStatus();
serviceCall.DocumentStatus.Code = (sdr["DocumentStatusCode"].ToString() != "" ? int.Parse(sdr["DocumentStatusCode"].ToString()) : serviceCall.DocumentStatus.Code);
serviceCall.DocumentStatus.Description = (sdr["DocumentStatusDescription"].ToString() != "" ? (sdr["DocumentStatusDescription"].ToString()) : serviceCall.DocumentStatus.Description);
serviceCall.AttendedBy = (sdr["AttendedBy"].ToString() != "" ? Guid.Parse(sdr["AttendedBy"].ToString()) : serviceCall.AttendedBy);
serviceCall.Employee = new Employee();
{
serviceCall.Employee.ID = (sdr["AttendedBy"].ToString() != "" ? Guid.Parse(sdr["AttendedBy"].ToString()) : serviceCall.Employee.ID);
serviceCall.Employee.Name = (sdr["AttendedByName"].ToString() != "" ? sdr["AttendedByName"].ToString() : serviceCall.Employee.Name);
}
serviceCall.ServicedBy = (sdr["ServicedBy"].ToString() != "" ? Guid.Parse(sdr["ServicedBy"].ToString()) : serviceCall.ServicedBy);
serviceCall.ServicedByName = (sdr["ServicedByName"].ToString() != "" ? sdr["ServicedByName"].ToString() : serviceCall.ServicedByName);
serviceCall.ServiceDate = (sdr["ServiceDate"].ToString() != "" ? DateTime.Parse(sdr["ServiceDate"].ToString()) : serviceCall.ServiceDate);
serviceCall.ServiceDateFormatted = (sdr["ServiceDate"].ToString() != "" ? DateTime.Parse(sdr["ServiceDate"].ToString()).ToString(_settings.DateFormat) : serviceCall.ServiceDateFormatted);
serviceCall.ServiceComments = (sdr["ServiceComments"].ToString() != "" ? sdr["ServiceComments"].ToString() : serviceCall.ServiceComments);
serviceCall.BranchCode = (sdr["BranchCode"].ToString() != "" ? int.Parse(sdr["BranchCode"].ToString()) : serviceCall.BranchCode);
serviceCall.Branch = new Branch();
{
serviceCall.Branch.Code = (sdr["BranchCode"].ToString() != "" ? int.Parse(sdr["BranchCode"].ToString()) : serviceCall.Branch.Code);
serviceCall.Branch.Description = (sdr["Branch"].ToString() != "" ? sdr["Branch"].ToString() : serviceCall.Branch.Description);
};
serviceCall.CalledPersonName = (sdr["CalledPersonName"].ToString() != "" ? (sdr["CalledPersonName"].ToString()) : serviceCall.CalledPersonName);
serviceCall.GeneralNotes = (sdr["GeneralNotes"].ToString() != "" ? sdr["GeneralNotes"].ToString() : serviceCall.GeneralNotes);
serviceCall.Area = new Area();
{
serviceCall.Area.Code = (sdr["AreaCode"].ToString() != "" ? int.Parse(sdr["AreaCode"].ToString()) : serviceCall.Area.Code);
serviceCall.Area.Description = (sdr["Area"].ToString() != "" ? sdr["Area"].ToString() : serviceCall.Area.Description);
}
serviceCall.ServiceTypeCode = (sdr["ServiceTypeCode"].ToString() != "" ? int.Parse(sdr["ServiceTypeCode"].ToString()) : serviceCall.ServiceTypeCode);
serviceCall.ServiceType = new ServiceType();
serviceCall.ServiceType.Name = (sdr["ServiceType"].ToString() != "" ? sdr["ServiceType"].ToString() : serviceCall.ServiceType.Name);
serviceCall.FilteredCount = (sdr["FilteredCount"].ToString() != "" ? int.Parse(sdr["FilteredCount"].ToString()) : serviceCall.FilteredCount);
serviceCall.TotalCount = (sdr["TotalCount"].ToString() != "" ? int.Parse(sdr["TotalCount"].ToString()) : serviceCall.FilteredCount);
}
serviceCallList.Add(serviceCall);
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(serviceCallList);
}
public List <ServiceCall> GetAllServiceCall(ServiceCallAdvanceSearch serviceCallAdvanceSearch)
{
return(_ServiceCallRepository.GetAllServiceCall(serviceCallAdvanceSearch));
}
