public string GetAllSpecialInvPayments(string SpecialPaymentsSearchObject) { try { SpecialPaymentsSearch SpecialPaymentsAdvancedSearchObj = SpecialPaymentsSearchObject != null?JsonConvert.DeserializeObject <SpecialPaymentsSearch>(SpecialPaymentsSearchObject) : new SpecialPaymentsSearch(); List <SpecialInvPaymentsViewModel> SpecialList = Mapper.Map <List <SpecialInvPayments>, List <SpecialInvPaymentsViewModel> >(_SpecialInvPaymentsBusiness.GetAllSpecialInvPayments(SpecialPaymentsAdvancedSearchObj)); return(JsonConvert.SerializeObject(new { Result = "OK", Records = SpecialList })); } catch (Exception ex) { AppConstMessage cm = c.GetMessage(ex.Message); return(JsonConvert.SerializeObject(new { Result = "ERROR", Message = cm.Message })); } }
public List <SpecialInvPayments> GetAllSpecialInvPayments(SpecialPaymentsSearch SpecialPaymentsSearch) { return(_SpecialInvPaymentsRepository.GetAllSpecialInvPayments(SpecialPaymentsSearch)); }
public List <SpecialInvPayments> GetAllSpecialInvPayments(SpecialPaymentsSearch specialPaymentsSearch) { List <SpecialInvPayments> SpecialObjList = 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].[GetAllSpecialInvPayments]"; cmd.Parameters.Add("@FromDate", SqlDbType.DateTime).Value = specialPaymentsSearch.FromDate; cmd.Parameters.Add("@ToDate", SqlDbType.DateTime).Value = specialPaymentsSearch.ToDate; cmd.Parameters.Add("@CustomerCode", SqlDbType.NVarChar, 50).Value = specialPaymentsSearch.Customer; cmd.Parameters.Add("@PaymentMode", SqlDbType.NVarChar, 50).Value = specialPaymentsSearch.PaymentMode; cmd.Parameters.Add("@CompanyCode", SqlDbType.NVarChar, 50).Value = specialPaymentsSearch.Company; cmd.Parameters.Add("@search", SqlDbType.NVarChar, 250).Value = specialPaymentsSearch.Search; cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader sdr = cmd.ExecuteReader()) { if ((sdr != null) && (sdr.HasRows)) { SpecialObjList = new List <SpecialInvPayments>(); while (sdr.Read()) { SpecialInvPayments SpecialObj = new SpecialInvPayments(); { //SpecialObj.ID = (sdr["PaymentID"].ToString() != "" ? Guid.Parse(sdr["PaymentID"].ToString()) : SpecialObj.ID); // SpecialObj.specialDetailObj = new SpecialInvPaymentsDetail(); //SpecialObj.specialDetailObj.InvoiceID = (sdr["InvoiceID"].ToString() != "" ? Guid.Parse(sdr["InvoiceID"].ToString()) : SpecialObj.specialDetailObj.InvoiceID); // SpecialObj.InvoiceNo = (sdr["InvoiceNo"].ToString() != "" ? sdr["InvoiceNo"].ToString() : SpecialObj.InvoiceNo); // SpecialObj.InvoiceDate = (sdr["InvoiceDate"].ToString() != "" ? DateTime.Parse(sdr["InvoiceDate"].ToString()).ToString("dd-MMM-yyyy").ToString() : SpecialObj.InvoiceDate); // SpecialObj.companiesObj = new Companies(); // SpecialObj.companiesObj.Name = (sdr["Name"].ToString() != "" ? sdr["Name"].ToString() : SpecialObj.companiesObj.Name); SpecialObj.GroupID = (sdr["GroupID"].ToString() != "" ? Guid.Parse(sdr["GroupID"].ToString()) : SpecialObj.GroupID); SpecialObj.paymentDateFormatted = (sdr["PayDate"].ToString() != "" ? DateTime.Parse(sdr["PayDate"].ToString()).ToString("dd-MMM-yyyy").ToString() : SpecialObj.paymentDateFormatted); SpecialObj.PaymentRef = (sdr["PaymentRef"].ToString() != "" ? (sdr["PaymentRef"].ToString()) : SpecialObj.PaymentRef); SpecialObj.specialDetailObj = new SpecialInvPaymentsDetail(); SpecialObj.specialDetailObj.PaidAmount = (sdr["SumAmount"].ToString() != "" ? Decimal.Parse(sdr["SumAmount"].ToString()) : SpecialObj.specialDetailObj.PaidAmount); SpecialObj.customerObj = new Customer(); SpecialObj.customerObj.CompanyName = (sdr["Customer"].ToString() != "" ? sdr["Customer"].ToString() : SpecialObj.customerObj.CompanyName); SpecialObj.Remarks = (sdr["Remarks"].ToString() != "" ? sdr["Remarks"].ToString() : SpecialObj.Remarks); } SpecialObjList.Add(SpecialObj); } } } } } } catch (Exception ex) { throw ex; } return(SpecialObjList); }