public List <DeliveryChallan> GetAllDeliveryChallan(DeliveryChallanAdvanceSearch deliveryChallanAdvanceSearch)
{
List <DeliveryChallan> deliveryChallanList = 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].[GetAllDeliveryChallan]";
if (string.IsNullOrEmpty(deliveryChallanAdvanceSearch.SearchTerm))
{
cmd.Parameters.AddWithValue("@SearchTerm", DBNull.Value);
}
else
{
cmd.Parameters.Add("@SearchTerm", SqlDbType.NVarChar, -1).Value = deliveryChallanAdvanceSearch.SearchTerm;
}
cmd.Parameters.Add("@RowStart", SqlDbType.Int).Value = deliveryChallanAdvanceSearch.DataTablePaging.Start;
if (deliveryChallanAdvanceSearch.DataTablePaging.Length == -1)
{
cmd.Parameters.AddWithValue("@Length", DBNull.Value);
}
else
{
cmd.Parameters.Add("@Length", SqlDbType.Int).Value = deliveryChallanAdvanceSearch.DataTablePaging.Length;
}
cmd.Parameters.Add("@FromDate", SqlDbType.DateTime).Value = deliveryChallanAdvanceSearch.AdvFromDate;
cmd.Parameters.Add("@Todate", SqlDbType.DateTime).Value = deliveryChallanAdvanceSearch.AdvToDate;
cmd.Parameters.Add("@AreaCode", SqlDbType.Int).Value = deliveryChallanAdvanceSearch.AdvAreaCode;
cmd.Parameters.Add("@BranchCode", SqlDbType.Int).Value = deliveryChallanAdvanceSearch.AdvBranchCode;
if (deliveryChallanAdvanceSearch.AdvCustomerID == Guid.Empty)
{
cmd.Parameters.AddWithValue("@CustomerID", DBNull.Value);
}
else
{
cmd.Parameters.Add("@CustomerID", SqlDbType.UniqueIdentifier).Value = deliveryChallanAdvanceSearch.AdvCustomerID;
}
if (deliveryChallanAdvanceSearch.AdvDocumentOwnerID == Guid.Empty)
{
cmd.Parameters.AddWithValue("@DocumentOwnerID", DBNull.Value);
}
else
{
cmd.Parameters.Add("@DocumentOwnerID", SqlDbType.UniqueIdentifier).Value = deliveryChallanAdvanceSearch.AdvDocumentOwnerID;
}
cmd.Parameters.Add("@ApprovalStatusCode", SqlDbType.Int).Value = deliveryChallanAdvanceSearch.AdvApprovalStatusCode;
cmd.Parameters.Add("@EmailSentYN", SqlDbType.NVarChar).Value = deliveryChallanAdvanceSearch.AdvEmailSentStatus;
cmd.Parameters.Add("@PlantCode", SqlDbType.Int).Value = deliveryChallanAdvanceSearch.AdvPlantCode;
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if ((sdr != null) && (sdr.HasRows))
{
deliveryChallanList = new List <DeliveryChallan>();
while (sdr.Read())
{
DeliveryChallan deliveryChallan = new DeliveryChallan();
{
deliveryChallan.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : deliveryChallan.ID);
deliveryChallan.DelvChallanNo = (sdr["DelvChallanNo"].ToString() != "" ? sdr["DelvChallanNo"].ToString() : deliveryChallan.DelvChallanNo);
deliveryChallan.DelvChallanRefNo = (sdr["DelvChallanRefNo"].ToString() != "" ? sdr["DelvChallanRefNo"].ToString() : deliveryChallan.DelvChallanRefNo);
deliveryChallan.DelvChallanDate = (sdr["DelvChallanDate"].ToString() != "" ? DateTime.Parse(sdr["DelvChallanDate"].ToString()) : deliveryChallan.DelvChallanDate);
deliveryChallan.DelvChallanDateFormatted = (sdr["DelvChallanDate"].ToString() != "" ? DateTime.Parse(sdr["DelvChallanDate"].ToString()).ToString(_settings.DateFormat) : deliveryChallan.DelvChallanDateFormatted);
deliveryChallan.SaleOrder = new SaleOrder();
deliveryChallan.SaleOrderID = (sdr["SaleOrderID"].ToString() != "" ? Guid.Parse(sdr["SaleOrderID"].ToString()) : deliveryChallan.SaleOrderID);
deliveryChallan.SaleOrder.SaleOrderNo = (sdr["SaleOrderNo"].ToString() != "" ? sdr["SaleOrderNo"].ToString() : deliveryChallan.SaleOrder.SaleOrderNo);
deliveryChallan.ProductionOrder = new ProductionOrder();
deliveryChallan.ProdOrderID = (sdr["ProdOrderID"].ToString() != "" ? Guid.Parse(sdr["ProdOrderID"].ToString()) : deliveryChallan.ProdOrderID);
deliveryChallan.ProductionOrder.ProdOrderNo = (sdr["ProdOrderNo"].ToString() != "" ? sdr["ProdOrderNo"].ToString() : deliveryChallan.ProductionOrder.ProdOrderNo);
deliveryChallan.Customer = new Customer();
deliveryChallan.Customer.CompanyName = (sdr["CompanyName"].ToString() != "" ? sdr["CompanyName"].ToString() : deliveryChallan.Customer.CompanyName);
deliveryChallan.Customer.ContactPerson = (sdr["ContactPerson"].ToString() != "" ? sdr["ContactPerson"].ToString() : deliveryChallan.Customer.ContactPerson);
deliveryChallan.Plant = new Plant();
deliveryChallan.Plant.Description = (sdr["Plant"].ToString() != "" ? sdr["Plant"].ToString() : deliveryChallan.Plant.Description);
deliveryChallan.Employee = new Employee();
deliveryChallan.Employee.Name = (sdr["PreparedBy"].ToString() != "" ? sdr["PreparedBy"].ToString() : deliveryChallan.Employee.Name);
deliveryChallan.Branch = new Branch();
deliveryChallan.Branch.Description = (sdr["Branch"].ToString() != "" ? sdr["Branch"].ToString() : deliveryChallan.Branch.Description);
deliveryChallan.FilteredCount = (sdr["FilteredCount"].ToString() != "" ? int.Parse(sdr["FilteredCount"].ToString()) : deliveryChallan.FilteredCount);
deliveryChallan.TotalCount = (sdr["TotalCount"].ToString() != "" ? int.Parse(sdr["TotalCount"].ToString()) : deliveryChallan.FilteredCount);
deliveryChallan.ApprovalStatus = new ApprovalStatus();
deliveryChallan.ApprovalStatus.Description = (sdr["ApprovalStatus"].ToString() != "" ? sdr["ApprovalStatus"].ToString() : deliveryChallan.ApprovalStatus.Description);
deliveryChallan.PSAUser = new PSAUser();
deliveryChallan.PSAUser.LoginName = (sdr["DocumentOwner"].ToString() != "" ? (sdr["DocumentOwner"].ToString()) : deliveryChallan.PSAUser.LoginName);
deliveryChallan.EmailSentYN = (sdr["EmailSentYN"].ToString() != "" ? bool.Parse(sdr["EmailSentYN"].ToString()) : deliveryChallan.EmailSentYN);
deliveryChallan.Area = new Area();
deliveryChallan.Area.Description = (sdr["Area"].ToString() != "" ? sdr["Area"].ToString() : deliveryChallan.Area.Description);
}
deliveryChallanList.Add(deliveryChallan);
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(deliveryChallanList);
}
public List <DeliveryChallan> GetAllDeliveryChallan(DeliveryChallanAdvanceSearch deliveryChallanAdvanceSearch)
{
return(_deliveryChallanRepository.GetAllDeliveryChallan(deliveryChallanAdvanceSearch));
}
