public CustomerCreditNotes GetCustomerCreditNoteDetails(Guid ID) { CustomerCreditNotes _customerCreditNoteObj = new CustomerCreditNotes(); try { using (SqlConnection con = _databaseFactory.GetDBConnection()) { using (SqlCommand cmd = new SqlCommand()) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Connection = con; cmd.CommandText = "[Accounts].[GetCustCreditNotesDetailsByID]"; cmd.Parameters.Add("@ID", SqlDbType.UniqueIdentifier).Value = ID; cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader sdr = cmd.ExecuteReader()) { if ((sdr != null) && (sdr.HasRows)) { if (sdr.Read()) { _customerCreditNoteObj.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : _customerCreditNoteObj.ID); _customerCreditNoteObj.CustomerName = (sdr["CompanyName"].ToString() != "" ? sdr["CompanyName"].ToString() : _customerCreditNoteObj.CustomerName); _customerCreditNoteObj.CustomerID = (sdr["CustomerID"].ToString() != "" ? Guid.Parse(sdr["CustomerID"].ToString()) : _customerCreditNoteObj.CustomerID); _customerCreditNoteObj.OriginComanyCode = (sdr["OriginComanyCode"].ToString() != "" ? sdr["OriginComanyCode"].ToString() : _customerCreditNoteObj.OriginComanyCode); _customerCreditNoteObj.CreditNoteNo = (sdr["CRNRefNo"].ToString() != "" ? sdr["CRNRefNo"].ToString() : _customerCreditNoteObj.CreditNoteNo); _customerCreditNoteObj.CreditNoteDate = (sdr["CRNDate"].ToString() != "" ? DateTime.Parse(sdr["CRNDate"].ToString()) : _customerCreditNoteObj.CreditNoteDate); _customerCreditNoteObj.Amount = (sdr["Amount"].ToString() != "" ? decimal.Parse(sdr["Amount"].ToString()) : _customerCreditNoteObj.Amount); _customerCreditNoteObj.TaxAmount = (sdr["TaxAmount"].ToString() != "" ? decimal.Parse(sdr["TaxAmount"].ToString()) : _customerCreditNoteObj.TaxAmount); _customerCreditNoteObj.CreditAmount = (sdr["CreditAmount"].ToString() != "" ? decimal.Parse(sdr["CreditAmount"].ToString()) : _customerCreditNoteObj.CreditAmount); _customerCreditNoteObj.Type = (sdr["Type"].ToString() != "" ? sdr["Type"].ToString() : _customerCreditNoteObj.Type); _customerCreditNoteObj.adjustedAmount = (sdr["AdjAmount"].ToString() != "" ? decimal.Parse(sdr["AdjAmount"].ToString()) : _customerCreditNoteObj.adjustedAmount); _customerCreditNoteObj.GeneralNotes = (sdr["GeneralNotes"].ToString() != "" ? sdr["GeneralNotes"].ToString() : _customerCreditNoteObj.GeneralNotes); _customerCreditNoteObj.BillingAddress = (sdr["BillingAddress"].ToString() != "" ? sdr["BillingAddress"].ToString() : _customerCreditNoteObj.BillingAddress); _customerCreditNoteObj.CreditNoteDateFormatted = (sdr["CRNDate"].ToString() != "" ? DateTime.Parse(sdr["CRNDate"].ToString()).ToString(s.dateformat) : _customerCreditNoteObj.CreditNoteDateFormatted); _customerCreditNoteObj.commonObj = new Common(); _customerCreditNoteObj.commonObj.CreatedBy = (sdr["CreatedBy"].ToString() != "" ? sdr["CreatedBy"].ToString() : _customerCreditNoteObj.commonObj.CreatedBy); _customerCreditNoteObj.commonObj.CreatedDateString = (sdr["CreatedDate"].ToString() != "" ? DateTime.Parse(sdr["CreatedDate"].ToString()).ToString(s.dateformat) : _customerCreditNoteObj.commonObj.CreatedDateString); _customerCreditNoteObj.commonObj.CreatedDate = (sdr["CreatedDate"].ToString() != "" ? DateTime.Parse(sdr["CreatedDate"].ToString()) : _customerCreditNoteObj.commonObj.CreatedDate); _customerCreditNoteObj.commonObj.UpdatedBy = (sdr["UpdatedBy"].ToString() != "" ? sdr["UpdatedBy"].ToString() : _customerCreditNoteObj.commonObj.UpdatedBy); _customerCreditNoteObj.commonObj.UpdatedDate = (sdr["UpdatedDate"].ToString() != "" ? DateTime.Parse(sdr["UpdatedDate"].ToString()) : _customerCreditNoteObj.commonObj.UpdatedDate); _customerCreditNoteObj.commonObj.UpdatedDateString = (sdr["UpdatedDate"].ToString() != "" ? DateTime.Parse(sdr["UpdatedDate"].ToString()).ToString(s.dateformat) : _customerCreditNoteObj.commonObj.UpdatedDateString); } } } } } } catch (Exception ex) { throw ex; } return(_customerCreditNoteObj); }
public CustomerCreditNotes GetCreditNoteAmount(Guid CreditID, Guid CustomerID) { CustomerCreditNotes creditnote = new CustomerCreditNotes(); List <CustomerCreditNotes> custcreditlist = new List <CustomerCreditNotes>(); custcreditlist = _customerCreditNotesRepository.GetCreditNoteByCustomer(CustomerID); custcreditlist = custcreditlist.Where(m => m.ID == CreditID).ToList(); creditnote = custcreditlist[0]; return(creditnote); }
public object UpdateCustomerCreditNotes(CustomerCreditNotes _customerCreditNotesObj) { SqlParameter outputStatus = 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].[UpdateCustCreditNotes]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ID", SqlDbType.UniqueIdentifier).Value = _customerCreditNotesObj.ID; cmd.Parameters.Add("@CustomerID", SqlDbType.UniqueIdentifier).Value = _customerCreditNotesObj.CustomerID; cmd.Parameters.Add("@OriginComanyCode", SqlDbType.NVarChar, 10).Value = _customerCreditNotesObj.OriginComanyCode; cmd.Parameters.Add("@CRNRefNo", SqlDbType.NVarChar, 20).Value = _customerCreditNotesObj.CreditNoteNo; cmd.Parameters.Add("@CRNDate", SqlDbType.DateTime).Value = _customerCreditNotesObj.CreditNoteDateFormatted; cmd.Parameters.Add("@Amount", SqlDbType.Decimal).Value = _customerCreditNotesObj.Amount; cmd.Parameters.Add("@TaxAmount", SqlDbType.Decimal).Value = _customerCreditNotesObj.TaxAmount; cmd.Parameters.Add("@CreditAmount", SqlDbType.Decimal).Value = _customerCreditNotesObj.CreditAmount; cmd.Parameters.Add("@Type", SqlDbType.VarChar, 5).Value = _customerCreditNotesObj.Type; cmd.Parameters.Add("@GeneralNotes", SqlDbType.NVarChar, -1).Value = _customerCreditNotesObj.GeneralNotes; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar, 250).Value = _customerCreditNotesObj.commonObj.UpdatedBy; cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = _customerCreditNotesObj.commonObj.UpdatedDate; outputStatus = cmd.Parameters.Add("@Status", SqlDbType.SmallInt); outputStatus.Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); } } switch (outputStatus.Value.ToString()) { case "0": throw new Exception(Cobj.UpdateFailure); default: break; } } catch (Exception ex) { throw ex; } return(new { Status = outputStatus.Value.ToString(), Message = Cobj.UpdateSuccess }); }
public List <CustomerCreditNotes> GetAllCustomerCreditNotes() { List <CustomerCreditNotes> customerCreditNotesList = 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].[GetAllCustCreditNotes]"; cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader sdr = cmd.ExecuteReader()) { if ((sdr != null) && (sdr.HasRows)) { customerCreditNotesList = new List <CustomerCreditNotes>(); while (sdr.Read()) { CustomerCreditNotes _customerCreditNotesObj = new CustomerCreditNotes(); { _customerCreditNotesObj.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : _customerCreditNotesObj.ID); _customerCreditNotesObj.CustomerName = (sdr["CompanyName"].ToString() != "" ? sdr["CompanyName"].ToString() : _customerCreditNotesObj.CustomerName); _customerCreditNotesObj.CustomerID = (sdr["CustomerID"].ToString() != "" ?Guid.Parse(sdr["CustomerID"].ToString()) : _customerCreditNotesObj.CustomerID); _customerCreditNotesObj.OriginComanyCode = (sdr["OriginComanyCode"].ToString() != "" ? sdr["OriginComanyCode"].ToString() : _customerCreditNotesObj.OriginComanyCode); _customerCreditNotesObj.CreditNoteNo = (sdr["CRNRefNo"].ToString() != "" ? sdr["CRNRefNo"].ToString() : _customerCreditNotesObj.CreditNoteNo); _customerCreditNotesObj.CreditNoteDate = (sdr["CRNDate"].ToString() != "" ? DateTime.Parse(sdr["CRNDate"].ToString()) : _customerCreditNotesObj.CreditNoteDate); _customerCreditNotesObj.CreditAmount = (sdr["Amount"].ToString() != "" ? decimal.Parse(sdr["Amount"].ToString()) : _customerCreditNotesObj.CreditAmount); _customerCreditNotesObj.AvailableCredit = (sdr["AvailableCredit"].ToString() != "" ? decimal.Parse(sdr["AvailableCredit"].ToString()) : _customerCreditNotesObj.AvailableCredit); // _customerCreditNotesObj.Type = (sdr["Type"].ToString() != "" ? sdr["Type"].ToString() : _customerCreditNotesObj.Type); // _customerCreditNotesObj.GeneralNotes = (sdr["GeneralNotes"].ToString() != "" ? sdr["GeneralNotes"].ToString() : _customerCreditNotesObj.GeneralNotes); _customerCreditNotesObj.CreditNoteDateFormatted = (sdr["CRNDate"].ToString() != "" ? DateTime.Parse(sdr["CRNDate"].ToString()).ToString(s.dateformat) : _customerCreditNotesObj.CreditNoteDateFormatted); } customerCreditNotesList.Add(_customerCreditNotesObj); } } } } } } catch (Exception ex) { throw ex; } return(customerCreditNotesList); }
public CustomerCreditNotes GetCustomerCreditNoteDetails(Guid ID) { CustomerCreditNotes custCreditNotesObj = new CustomerCreditNotes(); custCreditNotesObj = _customerCreditNotesRepository.GetCustomerCreditNoteDetails(ID); if (custCreditNotesObj != null) { custCreditNotesObj.creditAmountFormatted = _commonBusiness.ConvertCurrency(custCreditNotesObj.Amount, 2); custCreditNotesObj.adjustedAmountFormatted = _commonBusiness.ConvertCurrency(custCreditNotesObj.adjustedAmount, 2); } return(custCreditNotesObj); }
public List <CustomerCreditNotes> GetCreditNoteByPaymentID(Guid ID, Guid PaymentID) { List <CustomerCreditNotes> customerCreditNotesList = 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].[GetCreditNotesByPaymentID]"; cmd.Parameters.Add("@CustomerID", SqlDbType.UniqueIdentifier).Value = ID; cmd.Parameters.Add("@PaymentID", SqlDbType.UniqueIdentifier).Value = PaymentID; cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader sdr = cmd.ExecuteReader()) { if ((sdr != null) && (sdr.HasRows)) { customerCreditNotesList = new List <CustomerCreditNotes>(); while (sdr.Read()) { CustomerCreditNotes _customerCreditNotesObj = new CustomerCreditNotes(); { _customerCreditNotesObj.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : _customerCreditNotesObj.ID); _customerCreditNotesObj.CreditNoteNo = (sdr["CRNRefNo"].ToString() != "" ? sdr["CRNRefNo"].ToString() : _customerCreditNotesObj.CreditNoteNo); _customerCreditNotesObj.CreditNoteDate = (sdr["CRNDate"].ToString() != "" ? DateTime.Parse(sdr["CRNDate"].ToString()) : _customerCreditNotesObj.CreditNoteDate); _customerCreditNotesObj.CreditAmount = (sdr["CreditAmount"].ToString() != "" ? decimal.Parse(sdr["CreditAmount"].ToString()) : _customerCreditNotesObj.CreditAmount); _customerCreditNotesObj.AvailableCredit = (sdr["AvailableCredit"].ToString() != "" ? decimal.Parse(sdr["AvailableCredit"].ToString()) : _customerCreditNotesObj.AvailableCredit); _customerCreditNotesObj.CreditNoteDateFormatted = (sdr["CRNDate"].ToString() != "" ? DateTime.Parse(sdr["CRNDate"].ToString()).ToString(s.dateformat) : _customerCreditNotesObj.CreditNoteDateFormatted); } customerCreditNotesList.Add(_customerCreditNotesObj); } } } } } } catch (Exception ex) { throw ex; } return(customerCreditNotesList); }
public object InsertUpdateCustomerCreditNote(CustomerCreditNotes _customerCreditNoteObj) { object result = null; try { if (_customerCreditNoteObj.ID == null) { result = _customerCreditNotesRepository.InsertCustomerCreditNotes(_customerCreditNoteObj); } else { result = _customerCreditNotesRepository.UpdateCustomerCreditNotes(_customerCreditNoteObj); } } catch (Exception ex) { throw ex; } return(result); }