public List <CustomerPayments> GetAllCustomerPayments(CustomerPaymentsSearch CustomerPaymentsSearch) { List <CustomerPayments> custPayObj = null; custPayObj = _customerPaymentsRepository.GetAllCustomerPayments(CustomerPaymentsSearch); return(custPayObj); }
public string GetAllCustomerPayments(string customerPaymentsSearchObject) { CustomerPaymentsSearch CustomerPaymentsAdvancedSearchObj = customerPaymentsSearchObject != null?JsonConvert.DeserializeObject <CustomerPaymentsSearch>(customerPaymentsSearchObject) : new CustomerPaymentsSearch(); List <CustomerPaymentsViewModel> CustPayList = Mapper.Map <List <CustomerPayments>, List <CustomerPaymentsViewModel> >(_CustPaymentBusiness.GetAllCustomerPayments(CustomerPaymentsAdvancedSearchObj)); return(JsonConvert.SerializeObject(new { Result = "OK", Records = CustPayList })); }
public List <CustomerPayments> GetAllCustomerPayments(CustomerPaymentsSearch customerPaymentsSearch) { List <CustomerPayments> ExpenseTypelist = null; try { using (SqlConnection con = _databaseFactory.GetDBConnection()) { using (SqlCommand cmd = new SqlCommand()) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Connection = con; cmd.CommandText = "[Accounts].[GetAllCustomerPayments]"; //DateTime? FromDate = string.IsNullOrEmpty(customerPaymentsSearch.FromDate) ? (DateTime?)null : DateTime.Parse(); //DateTime? ToDate = string.IsNullOrEmpty(customerPaymentsSearch.ToDate) ? (DateTime?)null : DateTime.Parse(); cmd.Parameters.Add("@FromDate", SqlDbType.DateTime).Value = customerPaymentsSearch.FromDate; cmd.Parameters.Add("@ToDate", SqlDbType.DateTime).Value = customerPaymentsSearch.ToDate; cmd.Parameters.Add("@CustomerCode", SqlDbType.NVarChar, 50).Value = customerPaymentsSearch.Customer; cmd.Parameters.Add("@PaymentMode", SqlDbType.NVarChar, 50).Value = customerPaymentsSearch.PaymentMode; cmd.Parameters.Add("@CompanyCode", SqlDbType.NVarChar, 50).Value = customerPaymentsSearch.Company; cmd.Parameters.Add("@search", SqlDbType.NVarChar, 250).Value = customerPaymentsSearch.Search; cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader sdr = cmd.ExecuteReader()) { if ((sdr != null) && (sdr.HasRows)) { ExpenseTypelist = new List <CustomerPayments>(); while (sdr.Read()) { CustomerPayments CustPaymentsObj = new CustomerPayments(); { CustPaymentsObj.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : CustPaymentsObj.ID); CustPaymentsObj.PaymentDateFormatted = (sdr["PaymentDate"].ToString() != "" ? DateTime.Parse(sdr["PaymentDate"].ToString()).ToString("dd-MMM-yyyy").ToString() : CustPaymentsObj.PaymentDateFormatted); CustPaymentsObj.ChequeDate = (sdr["ChequeDate"].ToString() != "" ? DateTime.Parse(sdr["ChequeDate"].ToString()).ToString("dd-MMM-yyyy").ToString() : CustPaymentsObj.ChequeDate); CustPaymentsObj.PaymentRef = (sdr["PaymentRef"].ToString() != "" ? sdr["PaymentRef"].ToString() : CustPaymentsObj.PaymentRef); CustPaymentsObj.EntryNo = (sdr["EntryNo"].ToString() != "" ? sdr["EntryNo"].ToString() : CustPaymentsObj.EntryNo); CustPaymentsObj.PaymentMode = (sdr["PaymentMode"].ToString() != "" ? sdr["PaymentMode"].ToString() : CustPaymentsObj.PaymentMode); CustPaymentsObj.TotalRecdAmt = (sdr["AmountReceived"].ToString() != "" ? Decimal.Parse(sdr["AmountReceived"].ToString()): CustPaymentsObj.TotalRecdAmt); CustPaymentsObj.AdvanceAmount = (sdr["AdvanceAmount"].ToString() != "" ? Decimal.Parse(sdr["AdvanceAmount"].ToString()) : CustPaymentsObj.AdvanceAmount); CustPaymentsObj.CompanyObj = new Companies(); CustPaymentsObj.CompanyObj.Name = sdr["ReceivedTo"].ToString(); CustPaymentsObj.Type = (sdr["Type"].ToString() != "" ? sdr["Type"].ToString() : CustPaymentsObj.Type); CustPaymentsObj.CreditNo = (sdr["CRNRefNo"].ToString() != "" ? sdr["CRNRefNo"].ToString() : CustPaymentsObj.CreditNo); CustPaymentsObj.customerObj = new Customer(); CustPaymentsObj.customerObj.CompanyName = (sdr["Customer"].ToString() != "" ? sdr["Customer"].ToString() : CustPaymentsObj.customerObj.CompanyName); CustPaymentsObj.customerObj.ID = (sdr["CustomerID"].ToString() != "" ? Guid.Parse(sdr["CustomerID"].ToString()) : CustPaymentsObj.customerObj.ID); CustPaymentsObj.customerObj.ContactPerson = (sdr["ContactPerson"].ToString() != "" ? sdr["ContactPerson"].ToString() : CustPaymentsObj.customerObj.ContactPerson); }; ExpenseTypelist.Add(CustPaymentsObj); } } } } } } catch (Exception ex) { throw ex; } return(ExpenseTypelist); }