/// <summary>
/// GetForPage
/// Calls [usp_select_Credit_for_Page]
/// </summary>
public override CreditDetails GetForPage(System.Int32?creditId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_Credit_for_Page", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@CreditId", SqlDbType.Int).Value = creditId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
//return GetCreditFromReader(reader);
CreditDetails obj = new CreditDetails();
obj.CreditId = GetReaderValue_Int32(reader, "CreditId", 0);
obj.CreditNumber = GetReaderValue_Int32(reader, "CreditNumber", 0);
obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0);
obj.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0);
obj.CompanyName = GetReaderValue_String(reader, "CompanyName", "");
obj.TeamNo = GetReaderValue_NullableInt32(reader, "TeamNo", 0);
obj.DivisionNo = GetReaderValue_Int32(reader, "DivisionNo", 0);
obj.Salesman = GetReaderValue_Int32(reader, "Salesman", 0);
obj.isClientInvoice = GetReaderValue_Boolean(reader, "IsClientInvoice", false);
obj.RefClientName = GetReaderValue_String(reader, "ClientName", "");
obj.RefClientNo = GetReaderValue_NullableInt32(reader, "RefClientNo", 0);
obj.ClientCreditNo = GetReaderValue_NullableInt32(reader, "ClientCreditNo", 0);
return(obj);
}
else
{
return(null);
}
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to get Credit", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// GetNextNumber
/// Calls [usp_select_Credit_NextNumber]
/// </summary>
public override CreditDetails GetNextNumber(System.Int32?clientNo, System.Int32?updatedBy)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_Credit_NextNumber", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@ClientNo", SqlDbType.Int).Value = clientNo;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = updatedBy;
cmd.Parameters.Add("@NewNumber", SqlDbType.Int).Direction = ParameterDirection.Output;
cn.Open();
DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
//return GetCreditFromReader(reader);
CreditDetails obj = new CreditDetails();
obj.CreditNumber = GetReaderValue_Int32(reader, "CreditNumber", 0);
return(obj);
}
else
{
return(null);
}
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to get Credit", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
private static Credit PopulateFromDBDetailsObject(CreditDetails obj)
{
Credit objNew = new Credit();
objNew.CreditId = obj.CreditId;
objNew.CreditNumber = obj.CreditNumber;
objNew.ClientNo = obj.ClientNo;
objNew.CompanyNo = obj.CompanyNo;
objNew.ContactNo = obj.ContactNo;
objNew.CreditDate = obj.CreditDate;
objNew.CurrencyNo = obj.CurrencyNo;
objNew.RaisedBy = obj.RaisedBy;
objNew.Salesman = obj.Salesman;
objNew.Notes = obj.Notes;
objNew.Instructions = obj.Instructions;
objNew.ShipViaNo = obj.ShipViaNo;
objNew.Account = obj.Account;
objNew.ShippingCost = obj.ShippingCost;
objNew.Freight = obj.Freight;
objNew.DivisionNo = obj.DivisionNo;
objNew.TaxNo = obj.TaxNo;
objNew.InvoiceNo = obj.InvoiceNo;
objNew.CustomerRMANo = obj.CustomerRMANo;
objNew.ReferenceDate = obj.ReferenceDate;
objNew.CustomerPO = obj.CustomerPO;
objNew.CustomerRMA = obj.CustomerRMA;
objNew.CustomerDebit = obj.CustomerDebit;
objNew.UpdatedBy = obj.UpdatedBy;
objNew.DLUP = obj.DLUP;
objNew.Salesman2 = obj.Salesman2;
objNew.Salesman2Percent = obj.Salesman2Percent;
objNew.IncotermNo = obj.IncotermNo;
objNew.DivisionNo2 = obj.DivisionNo2;
objNew.CompanyName = obj.CompanyName;
objNew.CustomerCode = obj.CustomerCode;
objNew.ContactName = obj.ContactName;
objNew.CurrencyCode = obj.CurrencyCode;
objNew.CurrencyDescription = obj.CurrencyDescription;
objNew.RaiserName = obj.RaiserName;
objNew.SalesmanName = obj.SalesmanName;
objNew.TeamNo = obj.TeamNo;
objNew.DivisionName = obj.DivisionName;
objNew.Salesman2Name = obj.Salesman2Name;
objNew.TaxName = obj.TaxName;
objNew.InvoiceNumber = obj.InvoiceNumber;
objNew.InvoiceDate = obj.InvoiceDate;
objNew.SalesOrderNo = obj.SalesOrderNo;
objNew.SalesOrderNumber = obj.SalesOrderNumber;
objNew.CustomerRMANumber = obj.CustomerRMANumber;
objNew.CustomerRMADate = obj.CustomerRMADate;
objNew.ShipViaName = obj.ShipViaName;
objNew.CreditValue = obj.CreditValue;
objNew.CreditCost = obj.CreditCost;
objNew.TaxRate = obj.TaxRate;
objNew.IncotermName = obj.IncotermName;
//[001] start code
objNew.CreditNoteBankFee = obj.CreditNoteBankFee;
//[001] end code
objNew.CompanyTelephone = obj.CompanyTelephone;
objNew.CompanyFax = obj.CompanyFax;
objNew.ContactEmail = obj.ContactEmail;
return(objNew);
}
/// <summary>
/// GetListForCompany
/// Calls [usp_selectAll_Credit_for_Company]
/// </summary>
public override List <CreditDetails> GetListForCompany(System.Int32?companyId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_selectAll_Credit_for_Company", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = companyId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <CreditDetails> lst = new List <CreditDetails>();
while (reader.Read())
{
CreditDetails obj = new CreditDetails();
obj.CreditId = GetReaderValue_Int32(reader, "CreditId", 0);
obj.CreditNumber = GetReaderValue_Int32(reader, "CreditNumber", 0);
obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0);
obj.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0);
obj.ContactNo = GetReaderValue_Int32(reader, "ContactNo", 0);
obj.CreditDate = GetReaderValue_DateTime(reader, "CreditDate", DateTime.MinValue);
obj.CurrencyNo = GetReaderValue_Int32(reader, "CurrencyNo", 0);
obj.RaisedBy = GetReaderValue_NullableInt32(reader, "RaisedBy", null);
obj.Salesman = GetReaderValue_Int32(reader, "Salesman", 0);
obj.Notes = GetReaderValue_String(reader, "Notes", "");
obj.Instructions = GetReaderValue_String(reader, "Instructions", "");
obj.ShipViaNo = GetReaderValue_NullableInt32(reader, "ShipViaNo", null);
obj.Account = GetReaderValue_String(reader, "Account", "");
obj.ShippingCost = GetReaderValue_NullableDouble(reader, "ShippingCost", null);
obj.Freight = GetReaderValue_NullableDouble(reader, "Freight", null);
obj.DivisionNo = GetReaderValue_Int32(reader, "DivisionNo", 0);
obj.TaxNo = GetReaderValue_NullableInt32(reader, "TaxNo", null);
obj.InvoiceNo = GetReaderValue_NullableInt32(reader, "InvoiceNo", null);
obj.CustomerRMANo = GetReaderValue_NullableInt32(reader, "CustomerRMANo", null);
obj.ReferenceDate = GetReaderValue_DateTime(reader, "ReferenceDate", DateTime.MinValue);
obj.CustomerPO = GetReaderValue_String(reader, "CustomerPO", "");
obj.CustomerRMA = GetReaderValue_String(reader, "CustomerRMA", "");
obj.CustomerDebit = GetReaderValue_String(reader, "CustomerDebit", "");
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue);
obj.Salesman2 = GetReaderValue_NullableInt32(reader, "Salesman2", null);
obj.Salesman2Percent = GetReaderValue_Double(reader, "Salesman2Percent", 0);
obj.IncotermNo = GetReaderValue_NullableInt32(reader, "IncotermNo", null);
obj.CompanyName = GetReaderValue_String(reader, "CompanyName", "");
obj.CustomerCode = GetReaderValue_String(reader, "CustomerCode", "");
obj.ContactName = GetReaderValue_String(reader, "ContactName", "");
obj.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", "");
obj.CurrencyDescription = GetReaderValue_String(reader, "CurrencyDescription", "");
obj.RaiserName = GetReaderValue_String(reader, "RaiserName", "");
obj.SalesmanName = GetReaderValue_String(reader, "SalesmanName", "");
obj.TeamNo = GetReaderValue_NullableInt32(reader, "TeamNo", null);
obj.DivisionName = GetReaderValue_String(reader, "DivisionName", "");
obj.Salesman2Name = GetReaderValue_String(reader, "Salesman2Name", "");
obj.TaxName = GetReaderValue_String(reader, "TaxName", "");
obj.InvoiceNumber = GetReaderValue_NullableInt32(reader, "InvoiceNumber", null);
obj.InvoiceDate = GetReaderValue_NullableDateTime(reader, "InvoiceDate", null);
obj.SalesOrderNo = GetReaderValue_NullableInt32(reader, "SalesOrderNo", null);
obj.SalesOrderNumber = GetReaderValue_NullableInt32(reader, "SalesOrderNumber", null);
obj.CustomerRMANumber = GetReaderValue_NullableInt32(reader, "CustomerRMANumber", null);
obj.CustomerRMADate = GetReaderValue_NullableDateTime(reader, "CustomerRMADate", null);
obj.ShipViaName = GetReaderValue_String(reader, "ShipViaName", "");
obj.CreditValue = GetReaderValue_NullableDouble(reader, "CreditValue", null);
obj.CreditCost = GetReaderValue_NullableDouble(reader, "CreditCost", null);
obj.TaxRate = GetReaderValue_NullableDouble(reader, "TaxRate", null);
obj.IncotermName = GetReaderValue_String(reader, "IncotermName", "");
lst.Add(obj);
obj = null;
}
return(lst);
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to get Credits", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// GetForPrint
/// Calls [usp_select_Credit_for_Print]
/// </summary>
public override CreditDetails GetForPrint(System.Int32?creditId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_Credit_for_Print", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@CreditId", SqlDbType.Int).Value = creditId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
//return GetCreditFromReader(reader);
CreditDetails obj = new CreditDetails();
obj.CreditId = GetReaderValue_Int32(reader, "CreditId", 0);
obj.CreditNumber = GetReaderValue_Int32(reader, "CreditNumber", 0);
obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0);
obj.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0);
obj.ContactNo = GetReaderValue_Int32(reader, "ContactNo", 0);
obj.CreditDate = GetReaderValue_DateTime(reader, "CreditDate", DateTime.MinValue);
obj.CurrencyNo = GetReaderValue_Int32(reader, "CurrencyNo", 0);
obj.RaisedBy = GetReaderValue_NullableInt32(reader, "RaisedBy", null);
obj.Salesman = GetReaderValue_Int32(reader, "Salesman", 0);
obj.Notes = GetReaderValue_String(reader, "Notes", "");
obj.Instructions = GetReaderValue_String(reader, "Instructions", "");
obj.ShipViaNo = GetReaderValue_NullableInt32(reader, "ShipViaNo", null);
obj.Account = GetReaderValue_String(reader, "Account", "");
obj.ShippingCost = GetReaderValue_NullableDouble(reader, "ShippingCost", null);
obj.Freight = GetReaderValue_NullableDouble(reader, "Freight", null);
obj.DivisionNo = GetReaderValue_Int32(reader, "DivisionNo", 0);
obj.TaxNo = GetReaderValue_NullableInt32(reader, "TaxNo", null);
obj.InvoiceNo = GetReaderValue_NullableInt32(reader, "InvoiceNo", null);
obj.CustomerRMANo = GetReaderValue_NullableInt32(reader, "CustomerRMANo", null);
obj.ReferenceDate = GetReaderValue_DateTime(reader, "ReferenceDate", DateTime.MinValue);
obj.CustomerPO = GetReaderValue_String(reader, "CustomerPO", "");
obj.CustomerRMA = GetReaderValue_String(reader, "CustomerRMA", "");
obj.CustomerDebit = GetReaderValue_String(reader, "CustomerDebit", "");
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue);
obj.Salesman2 = GetReaderValue_NullableInt32(reader, "Salesman2", null);
obj.Salesman2Percent = GetReaderValue_Double(reader, "Salesman2Percent", 0);
obj.IncotermNo = GetReaderValue_NullableInt32(reader, "IncotermNo", null);
obj.CompanyName = GetReaderValue_String(reader, "CompanyName", "");
obj.CustomerCode = GetReaderValue_String(reader, "CustomerCode", "");
obj.ContactName = GetReaderValue_String(reader, "ContactName", "");
obj.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", "");
obj.CurrencyDescription = GetReaderValue_String(reader, "CurrencyDescription", "");
obj.RaiserName = GetReaderValue_String(reader, "RaiserName", "");
obj.SalesmanName = GetReaderValue_String(reader, "SalesmanName", "");
obj.TeamNo = GetReaderValue_NullableInt32(reader, "TeamNo", null);
obj.DivisionName = GetReaderValue_String(reader, "DivisionName", "");
obj.Salesman2Name = GetReaderValue_String(reader, "Salesman2Name", "");
obj.TaxName = GetReaderValue_String(reader, "TaxName", "");
obj.InvoiceNumber = GetReaderValue_NullableInt32(reader, "InvoiceNumber", null);
obj.InvoiceDate = GetReaderValue_NullableDateTime(reader, "InvoiceDate", null);
obj.SalesOrderNo = GetReaderValue_NullableInt32(reader, "SalesOrderNo", null);
obj.SalesOrderNumber = GetReaderValue_NullableInt32(reader, "SalesOrderNumber", null);
obj.CustomerRMANumber = GetReaderValue_NullableInt32(reader, "CustomerRMANumber", null);
obj.CustomerRMADate = GetReaderValue_NullableDateTime(reader, "CustomerRMADate", null);
obj.ShipViaName = GetReaderValue_String(reader, "ShipViaName", "");
obj.CreditValue = GetReaderValue_NullableDouble(reader, "CreditValue", null);
obj.CreditCost = GetReaderValue_NullableDouble(reader, "CreditCost", null);
obj.TaxRate = GetReaderValue_NullableDouble(reader, "TaxRate", null);
obj.IncotermName = GetReaderValue_String(reader, "IncotermName", "");
obj.CompanyTelephone = GetReaderValue_String(reader, "CompanyTelephone", "");
obj.CompanyFax = GetReaderValue_String(reader, "CompanyFax", "");
obj.ContactEmail = GetReaderValue_String(reader, "ContactEmail", "");
obj.CreditNoteBankFee = GetReaderValue_NullableDouble(reader, "CreditNoteBankFee", null);
obj.VATNO = GetReaderValue_String(reader, "VATNo", "");
obj.ClientCreditNo = GetReaderValue_Int32(reader, "ClientCreditNo", 0);
obj.RefNumber = GetReaderValue_NullableInt32(reader, "RefNumber", null);
obj.isClientInvoice = GetReaderValue_Boolean(reader, "IsClientInvoice", false);
obj.RefClientName = GetReaderValue_String(reader, "ClientName", "");
obj.RefClientNo = GetReaderValue_NullableInt32(reader, "RefClientNo", null);
obj.ClientInvoiceNo = GetReaderValue_NullableInt32(reader, "ClientInvoiceNo", null);
obj.ClientInvoiceNumber = GetReaderValue_NullableInt32(reader, "ClientInvoiceNumber", null);
obj.ClientShipTo = GetReaderValue_String(reader, "ClientShipTo", "");
obj.Telephone = GetReaderValue_String(reader, "Telephone", "");
obj.Fax = GetReaderValue_String(reader, "Fax", "");
obj.ClientCustomerCode = GetReaderValue_String(reader, "ClientCustomerCode", "");
obj.Email = GetReaderValue_String(reader, "Email", "");
obj.VAT = GetReaderValue_String(reader, "VAT", "");
obj.Tax = GetReaderValue_String(reader, "Tax", "");
obj.ClientBillToAdr = GetReaderValue_String(reader, "ClientBillToAdr", "");
obj.ExchangeRate = GetReaderValue_NullableDouble(reader, "ExchangeRate", null);
obj.LocalCurrencyNo = GetReaderValue_NullableInt32(reader, "LocalCurrencyNo", 0);
obj.ApplyLocalCurrency = GetReaderValue_NullableBoolean(reader, "ApplyLocalCurrency", false);
obj.LocalCurrencyCode = GetReaderValue_String(reader, "LocalCurrencyCode", "");
return(obj);
}
else
{
return(null);
}
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to get Credit", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}