public SupplierCreditNote InsertSupplierCreditNotes(SupplierCreditNote _supplierCreditNoteObj)
{
try
{
SqlParameter outputStatus, outputID = null;
using (SqlConnection con = _databaseFactory.GetDBConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandText = "[Accounts].[InsertSupplierCreditNote]";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CreditToComanyCode", SqlDbType.VarChar, 10).Value = _supplierCreditNoteObj.CreditToComanyCode;
cmd.Parameters.Add("@CRNRefNo", SqlDbType.VarChar, 20).Value = _supplierCreditNoteObj.CRNRefNo;
cmd.Parameters.Add("@CRNDate", SqlDbType.DateTime).Value = _supplierCreditNoteObj.CRNDateFormatted;
cmd.Parameters.Add("@Amount", SqlDbType.Decimal).Value = _supplierCreditNoteObj.Amount;
cmd.Parameters.Add("@TaxAmount", SqlDbType.Decimal).Value = _supplierCreditNoteObj.TaxAmount;
cmd.Parameters.Add("@CreditAmount", SqlDbType.Decimal).Value = _supplierCreditNoteObj.CreditAmount;
cmd.Parameters.Add("@Type", SqlDbType.VarChar, 5).Value = _supplierCreditNoteObj.Type;
cmd.Parameters.Add("@GeneralNotes", SqlDbType.NVarChar, -1).Value = _supplierCreditNoteObj.GeneralNotes;
cmd.Parameters.Add("@SupplierID", SqlDbType.UniqueIdentifier).Value = _supplierCreditNoteObj.SupplierID;
cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar, 250).Value = _supplierCreditNoteObj.commonObj.CreatedBy;
cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = _supplierCreditNoteObj.commonObj.CreatedDate;
outputStatus = cmd.Parameters.Add("@Status", SqlDbType.SmallInt);
outputStatus.Direction = ParameterDirection.Output;
outputID = cmd.Parameters.Add("@ID", SqlDbType.UniqueIdentifier);
outputID.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
}
}
switch (outputStatus.Value.ToString())
{
case "0":
AppConst Cobj = new AppConst();
throw new Exception(Cobj.InsertFailure);
case "1":
_supplierCreditNoteObj.ID = Guid.Parse(outputID.Value.ToString());
break;
default:
break;
}
}
catch (Exception ex)
{
throw ex;
}
return(_supplierCreditNoteObj);
}
public List <SupplierCreditNote> GetAllSupplierCreditNotes()
{
List <SupplierCreditNote> supplierCreditNotelist = 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].[GetAllSupplierCreditNotes]";
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if ((sdr != null) && (sdr.HasRows))
{
supplierCreditNotelist = new List <SupplierCreditNote>();
while (sdr.Read())
{
SupplierCreditNote _supplierCreditNote = new SupplierCreditNote();
{
_supplierCreditNote.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : _supplierCreditNote.ID);
_supplierCreditNote.supplier = new Supplier();
_supplierCreditNote.supplier.ID = (sdr["SupplierID"].ToString() != "" ? Guid.Parse(sdr["SupplierID"].ToString()) : _supplierCreditNote.supplier.ID);
_supplierCreditNote.supplier.CompanyName = (sdr["CompanyName"].ToString() != "" ? (sdr["CompanyName"].ToString()) : _supplierCreditNote.supplier.CompanyName);
_supplierCreditNote.Company = new Companies();
_supplierCreditNote.Company.Code = (sdr["CreditToComanyCode"].ToString() != "" ? (sdr["CreditToComanyCode"].ToString()) : _supplierCreditNote.Company.Code);
_supplierCreditNote.Company.Name = (sdr["CreditToCompanyName"].ToString() != "" ? sdr["CreditToCompanyName"].ToString() : _supplierCreditNote.Company.Name);
_supplierCreditNote.CRNRefNo = (sdr["CRNRefNo"].ToString() != "" ? sdr["CRNRefNo"].ToString() : _supplierCreditNote.CRNRefNo);
_supplierCreditNote.CRNDate = (sdr["CRNDate"].ToString() != "" ? DateTime.Parse(sdr["CRNDate"].ToString()).ToString(settings.dateformat) : _supplierCreditNote.CRNDate);
_supplierCreditNote.Amount = (sdr["Amount"].ToString() != "" ? decimal.Parse(sdr["Amount"].ToString()) : _supplierCreditNote.Amount);
_supplierCreditNote.AvailableCredit = (sdr["AvailableCredit"].ToString() != "" ? decimal.Parse(sdr["AvailableCredit"].ToString()) : _supplierCreditNote.AvailableCredit);
// _supplierCreditNote.Type = (sdr["Type"].ToString() != "" ? sdr["Type"].ToString() : _supplierCreditNote.Type);
// _supplierCreditNote.GeneralNotes = (sdr["GeneralNotes"].ToString() != "" ? sdr["GeneralNotes"].ToString() : _supplierCreditNote.GeneralNotes);
}
supplierCreditNotelist.Add(_supplierCreditNote);
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(supplierCreditNotelist);
}
public List <SupplierCreditNote> GetCreditNoteBySupplier(Guid SupplierID)
{
List <SupplierCreditNote> CreditNotesList = 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].[GetCreditNoteBySupplier]";
cmd.Parameters.Add("@ID", SqlDbType.UniqueIdentifier).Value = SupplierID;
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if ((sdr != null) && (sdr.HasRows))
{
CreditNotesList = new List <SupplierCreditNote>();
while (sdr.Read())
{
SupplierCreditNote _CreditNotesObj = new SupplierCreditNote();
{
_CreditNotesObj.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : _CreditNotesObj.ID);
_CreditNotesObj.CRNRefNo = (sdr["CRNRefNo"].ToString() != "" ? sdr["CRNRefNo"].ToString() : _CreditNotesObj.CRNRefNo);
_CreditNotesObj.CRNDate = (sdr["CRNDate"].ToString() != "" ? (sdr["CRNDate"].ToString()) : _CreditNotesObj.CRNDate);
_CreditNotesObj.Amount = (sdr["Amount"].ToString() != "" ? decimal.Parse(sdr["Amount"].ToString()) : _CreditNotesObj.Amount);
_CreditNotesObj.AvailableCredit = (sdr["AvailableCredit"].ToString() != "" ? decimal.Parse(sdr["AvailableCredit"].ToString()) : _CreditNotesObj.AvailableCredit);
_CreditNotesObj.CreditNoteDateFormatted = (sdr["CRNDate"].ToString() != "" ? DateTime.Parse(sdr["CRNDate"].ToString()).ToString(settings.dateformat) : _CreditNotesObj.CreditNoteDateFormatted);
}
CreditNotesList.Add(_CreditNotesObj);
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(CreditNotesList);
}
public SupplierCreditNote GetSupplierCreditNoteDetails(Guid ID)
{
SupplierCreditNote _supplierCreditNote = new SupplierCreditNote();
try
{
using (SqlConnection con = _databaseFactory.GetDBConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandText = "[Accounts].[GetSupplierCreditNoteDetails]";
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())
{
_supplierCreditNote.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : _supplierCreditNote.ID);
_supplierCreditNote.supplier = new Supplier();
_supplierCreditNote.supplier.ID = (sdr["SupplierID"].ToString() != "" ? Guid.Parse(sdr["SupplierID"].ToString()) : _supplierCreditNote.supplier.ID);
_supplierCreditNote.supplier.CompanyName = (sdr["CompanyName"].ToString() != "" ? (sdr["CompanyName"].ToString()) : _supplierCreditNote.supplier.CompanyName);
_supplierCreditNote.Company = new Companies();
_supplierCreditNote.Company.Code = (sdr["CreditToComanyCode"].ToString() != "" ? (sdr["CreditToComanyCode"].ToString()) : _supplierCreditNote.Company.Code);
_supplierCreditNote.Company.Name = (sdr["CreditToCompanyName"].ToString() != "" ? sdr["CreditToCompanyName"].ToString() : _supplierCreditNote.Company.Name);
_supplierCreditNote.CRNRefNo = (sdr["CRNRefNo"].ToString() != "" ? sdr["CRNRefNo"].ToString() : _supplierCreditNote.CRNRefNo);
_supplierCreditNote.CRNDate = (sdr["CRNDate"].ToString() != "" ? DateTime.Parse(sdr["CRNDate"].ToString()).ToString(settings.dateformat) : _supplierCreditNote.CRNDate);
_supplierCreditNote.Amount = (sdr["Amount"].ToString() != "" ? decimal.Parse(sdr["Amount"].ToString()) : _supplierCreditNote.Amount);
_supplierCreditNote.TaxAmount = (sdr["TaxAmount"].ToString() != "" ? decimal.Parse(sdr["TaxAmount"].ToString()) : _supplierCreditNote.TaxAmount);
_supplierCreditNote.CreditAmount = (sdr["CreditAmount"].ToString() != "" ? decimal.Parse(sdr["CreditAmount"].ToString()) : _supplierCreditNote.CreditAmount);
_supplierCreditNote.Type = (sdr["Type"].ToString() != "" ? sdr["Type"].ToString() : _supplierCreditNote.Type);
_supplierCreditNote.adjustedAmount = (sdr["AdjAmount"].ToString() != "" ? decimal.Parse(sdr["AdjAmount"].ToString()) : _supplierCreditNote.adjustedAmount);
_supplierCreditNote.GeneralNotes = (sdr["GeneralNotes"].ToString() != "" ? sdr["GeneralNotes"].ToString() : _supplierCreditNote.GeneralNotes);
_supplierCreditNote.SupplierAddress = (sdr["BillingAddress"].ToString() != "" ? sdr["BillingAddress"].ToString() : _supplierCreditNote.SupplierAddress);
_supplierCreditNote.commonObj = new Common();
_supplierCreditNote.commonObj.CreatedBy = (sdr["CreatedBy"].ToString() != "" ? sdr["CreatedBy"].ToString() : _supplierCreditNote.commonObj.CreatedBy);
_supplierCreditNote.commonObj.CreatedDateString = (sdr["CreatedDate"].ToString() != "" ? DateTime.Parse(sdr["CreatedDate"].ToString()).ToString(settings.dateformat) : _supplierCreditNote.commonObj.CreatedDateString);
_supplierCreditNote.commonObj.CreatedDate = (sdr["CreatedDate"].ToString() != "" ? DateTime.Parse(sdr["CreatedDate"].ToString()) : _supplierCreditNote.commonObj.CreatedDate);
_supplierCreditNote.commonObj.UpdatedBy = (sdr["UpdatedBy"].ToString() != "" ? sdr["UpdatedBy"].ToString() : _supplierCreditNote.commonObj.UpdatedBy);
_supplierCreditNote.commonObj.UpdatedDate = (sdr["UpdatedDate"].ToString() != "" ? DateTime.Parse(sdr["UpdatedDate"].ToString()) : _supplierCreditNote.commonObj.UpdatedDate);
_supplierCreditNote.commonObj.UpdatedDateString = (sdr["UpdatedDate"].ToString() != "" ? DateTime.Parse(sdr["UpdatedDate"].ToString()).ToString(settings.dateformat) : _supplierCreditNote.commonObj.UpdatedDateString);
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(_supplierCreditNote);
}
