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);
}
