// [003] end
/// <summary>
/// GetNextNumber
/// Calls [usp_select_Debit_NextNumber]
/// </summary>
public override DebitDetails GetNextNumber(System.Int32?clientNo, System.Int32?updatedBy)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_Debit_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 GetDebitFromReader(reader);
DebitDetails obj = new DebitDetails();
obj.DebitNumber = GetReaderValue_Int32(reader, "DebitNumber", 0);
return(obj);
}
else
{
return(null);
}
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Debit", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// GetIdByNumber
/// Calls [usp_select_Debit_Id_by_Number]
/// </summary>
//[003] start
public override List <DebitDetails> GetIdByNumber(System.Int32?debitNumber, System.Int32?clientNo, System.Int32?isGlobalUser)
{
SqlConnection cn = null;
SqlCommand cmd = null;
List <DebitDetails> lstDebitDetail = new List <DebitDetails>();
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_Debit_Id_by_Number", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@DebitNumber", SqlDbType.Int).Value = debitNumber;
cmd.Parameters.Add("@ClientNo", SqlDbType.Int).Value = clientNo;
cmd.Parameters.Add("@IsGlobalUser", SqlDbType.Int).Value = isGlobalUser;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
while (reader.Read())
{
//return GetDebitFromReader(reader);
DebitDetails obj = new DebitDetails();
obj.DebitId = GetReaderValue_Int32(reader, "DebitId", 0);
obj.DebitDetailNumber = GetReaderValue_String(reader, "DebitDetailNumber", "true");
lstDebitDetail.Add(obj);
}
return(lstDebitDetail);
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Debit", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
//[001] code end
/// <summary>
/// ItemSearch
/// Calls [usp_itemsearch_Debit]
/// </summary>
public override List <DebitDetails> ItemSearch(System.Int32?clientId, System.Int32?orderBy, System.Int32?sortDir, System.Int32?pageIndex, System.Int32?pageSize, System.String contactSearch, System.String cmSearch, System.Int32?salesmanSearch, System.Int32?debitNoLo, System.Int32?debitNoHi, System.Int32?supplierRmaNoLo, System.Int32?supplierRmaNoHi, System.Int32?purchaseOrderNoLo, System.Int32?purchaseOrderNoHi, System.DateTime?debitDateFrom, System.DateTime?debitDateTo)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_itemsearch_Debit", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 60;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cmd.Parameters.Add("@OrderBy", SqlDbType.Int).Value = orderBy;
cmd.Parameters.Add("@SortDir", SqlDbType.Int).Value = sortDir;
cmd.Parameters.Add("@PageIndex", SqlDbType.Int).Value = pageIndex;
cmd.Parameters.Add("@PageSize", SqlDbType.Int).Value = pageSize;
cmd.Parameters.Add("@ContactSearch", SqlDbType.NVarChar).Value = contactSearch;
cmd.Parameters.Add("@CMSearch", SqlDbType.NVarChar).Value = cmSearch;
cmd.Parameters.Add("@SalesmanSearch", SqlDbType.Int).Value = salesmanSearch;
cmd.Parameters.Add("@DebitNoLo", SqlDbType.Int).Value = debitNoLo;
cmd.Parameters.Add("@DebitNoHi", SqlDbType.Int).Value = debitNoHi;
cmd.Parameters.Add("@SupplierRMANoLo", SqlDbType.Int).Value = supplierRmaNoLo;
cmd.Parameters.Add("@SupplierRMANoHi", SqlDbType.Int).Value = supplierRmaNoHi;
cmd.Parameters.Add("@PurchaseOrderNoLo", SqlDbType.Int).Value = purchaseOrderNoLo;
cmd.Parameters.Add("@PurchaseOrderNoHi", SqlDbType.Int).Value = purchaseOrderNoHi;
cmd.Parameters.Add("@DebitDateFrom", SqlDbType.DateTime).Value = debitDateFrom;
cmd.Parameters.Add("@DebitDateTo", SqlDbType.DateTime).Value = debitDateTo;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <DebitDetails> lst = new List <DebitDetails>();
while (reader.Read())
{
DebitDetails obj = new DebitDetails();
obj.DebitId = GetReaderValue_Int32(reader, "DebitId", 0);
obj.DebitNumber = GetReaderValue_Int32(reader, "DebitNumber", 0);
obj.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0);
obj.ContactNo = GetReaderValue_Int32(reader, "ContactNo", 0);
obj.DebitDate = GetReaderValue_DateTime(reader, "DebitDate", DateTime.MinValue);
obj.CompanyName = GetReaderValue_String(reader, "CompanyName", "");
obj.ContactName = GetReaderValue_String(reader, "ContactName", "");
obj.RaiserName = GetReaderValue_String(reader, "RaiserName", "");
obj.PurchaseOrderNumber = GetReaderValue_Int32(reader, "PurchaseOrderNumber", 0);
obj.SupplierRMANumber = GetReaderValue_NullableInt32(reader, "SupplierRMANumber", null);
obj.RowCnt = GetReaderValue_NullableInt32(reader, "RowCnt", null);
lst.Add(obj);
obj = null;
}
return(lst);
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Debits", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
public ActionResult AddExpenseDetails(int Id = 0)
{
try
{
var Model = IService.GetStoryAccountsDetails(Id);
if (Model.Debits.Count == 0)
{
DebitDetails m = new DebitDetails();
m.Expense = 0.0;
m.ExpenseDescription = "";
Model.Debits.Add(m);
}
return(View(Model));
}
catch (Exception ex) { throw ex; }
}
//[001] code end
private static Debit PopulateFromDBDetailsObject(DebitDetails obj)
{
Debit objNew = new Debit();
objNew.DebitId = obj.DebitId;
objNew.DebitNumber = obj.DebitNumber;
objNew.ClientNo = obj.ClientNo;
objNew.CompanyNo = obj.CompanyNo;
objNew.ContactNo = obj.ContactNo;
objNew.DebitDate = obj.DebitDate;
objNew.CurrencyNo = obj.CurrencyNo;
objNew.RaisedBy = obj.RaisedBy;
objNew.Buyer = obj.Buyer;
objNew.Notes = obj.Notes;
objNew.Instructions = obj.Instructions;
objNew.Freight = obj.Freight;
objNew.DivisionNo = obj.DivisionNo;
objNew.TaxNo = obj.TaxNo;
objNew.PurchaseOrderNo = obj.PurchaseOrderNo;
objNew.SupplierRMANo = obj.SupplierRMANo;
objNew.ReferenceDate = obj.ReferenceDate;
objNew.SupplierInvoice = obj.SupplierInvoice;
objNew.SupplierRMA = obj.SupplierRMA;
objNew.SupplierCredit = obj.SupplierCredit;
objNew.UpdatedBy = obj.UpdatedBy;
objNew.DLUP = obj.DLUP;
objNew.CompanyName = obj.CompanyName;
objNew.ContactName = obj.ContactName;
objNew.RaiserName = obj.RaiserName;
objNew.PurchaseOrderNumber = obj.PurchaseOrderNumber;
objNew.SupplierRMANumber = obj.SupplierRMANumber;
objNew.RowNum = obj.RowNum;
objNew.RowCnt = obj.RowCnt;
objNew.CurrencyCode = obj.CurrencyCode;
objNew.CurrencyDescription = obj.CurrencyDescription;
objNew.BuyerName = obj.BuyerName;
objNew.TeamNo = obj.TeamNo;
objNew.DivisionName = obj.DivisionName;
objNew.TaxName = obj.TaxName;
objNew.PurchaseOrderDate = obj.PurchaseOrderDate;
objNew.DebitValue = obj.DebitValue;
objNew.TaxRate = obj.TaxRate;
objNew.CompanyTelephone = obj.CompanyTelephone;
objNew.CompanyFax = obj.CompanyFax;
objNew.ContactEmail = obj.ContactEmail;
return(objNew);
}
/// <summary>
/// GetForPage
/// Calls [usp_select_Debit_for_Page]
/// </summary>
public override DebitDetails GetForPage(System.Int32?debitId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_Debit_for_Page", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@DebitId", SqlDbType.Int).Value = debitId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
//return GetDebitFromReader(reader);
DebitDetails obj = new DebitDetails();
obj.DebitId = GetReaderValue_Int32(reader, "DebitId", 0);
obj.DebitNumber = GetReaderValue_Int32(reader, "DebitNumber", 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.Buyer = GetReaderValue_Int32(reader, "Buyer", 0);
obj.POHubCompanyNo = GetReaderValue_NullableInt32(reader, "IPOCompanyNo", 0);
obj.POHubCompanyName = GetReaderValue_String(reader, "IPOCompanyName", "");
obj.InternalPurchaseOrderNo = GetReaderValue_NullableInt32(reader, "InternalPurchaseOrderId", null);
obj.ClientName = GetReaderValue_String(reader, "ClientName", "");
return(obj);
}
else
{
return(null);
}
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Debit", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// GetListForCompany
/// Calls [usp_selectAll_Debit_for_Company]
/// </summary>
public override List <DebitDetails> GetListForCompany(System.Int32?companyId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_selectAll_Debit_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 <DebitDetails> lst = new List <DebitDetails>();
while (reader.Read())
{
DebitDetails obj = new DebitDetails();
obj.DebitId = GetReaderValue_Int32(reader, "DebitId", 0);
obj.DebitNumber = GetReaderValue_Int32(reader, "DebitNumber", 0);
obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0);
obj.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0);
obj.ContactNo = GetReaderValue_Int32(reader, "ContactNo", 0);
obj.DebitDate = GetReaderValue_DateTime(reader, "DebitDate", DateTime.MinValue);
obj.CurrencyNo = GetReaderValue_Int32(reader, "CurrencyNo", 0);
obj.RaisedBy = GetReaderValue_NullableInt32(reader, "RaisedBy", null);
obj.Buyer = GetReaderValue_Int32(reader, "Buyer", 0);
obj.Notes = GetReaderValue_String(reader, "Notes", "");
obj.Instructions = GetReaderValue_String(reader, "Instructions", "");
obj.Freight = GetReaderValue_NullableDouble(reader, "Freight", null);
obj.DivisionNo = GetReaderValue_Int32(reader, "DivisionNo", 0);
obj.TaxNo = GetReaderValue_NullableInt32(reader, "TaxNo", null);
obj.PurchaseOrderNo = GetReaderValue_NullableInt32(reader, "PurchaseOrderNo", null);
obj.SupplierRMANo = GetReaderValue_NullableInt32(reader, "SupplierRMANo", null);
obj.ReferenceDate = GetReaderValue_DateTime(reader, "ReferenceDate", DateTime.MinValue);
obj.SupplierInvoice = GetReaderValue_String(reader, "SupplierInvoice", "");
obj.SupplierRMA = GetReaderValue_String(reader, "SupplierRMA", "");
obj.SupplierCredit = GetReaderValue_String(reader, "SupplierCredit", "");
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue);
obj.CompanyName = GetReaderValue_String(reader, "CompanyName", "");
obj.ContactName = GetReaderValue_String(reader, "ContactName", "");
obj.RaiserName = GetReaderValue_String(reader, "RaiserName", "");
obj.PurchaseOrderNumber = GetReaderValue_Int32(reader, "PurchaseOrderNumber", 0);
obj.SupplierRMANumber = GetReaderValue_NullableInt32(reader, "SupplierRMANumber", null);
obj.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", "");
obj.CurrencyDescription = GetReaderValue_String(reader, "CurrencyDescription", "");
obj.BuyerName = GetReaderValue_String(reader, "BuyerName", "");
obj.TeamNo = GetReaderValue_NullableInt32(reader, "TeamNo", null);
obj.DivisionName = GetReaderValue_String(reader, "DivisionName", "");
obj.TaxName = GetReaderValue_String(reader, "TaxName", "");
obj.PurchaseOrderDate = GetReaderValue_DateTime(reader, "PurchaseOrderDate", DateTime.MinValue);
obj.DebitValue = GetReaderValue_NullableDouble(reader, "DebitValue", null);
obj.TaxRate = GetReaderValue_NullableDouble(reader, "TaxRate", null);
lst.Add(obj);
obj = null;
}
return(lst);
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Debits", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// GetForPrint
/// Calls [usp_select_Debit_for_Print]
/// </summary>
public override DebitDetails GetForPrint(System.Int32?debitNo, bool IsHUBdebitNo)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_Debit_for_Print", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@DebitNo", SqlDbType.Int).Value = debitNo;
//[002] Start Here
cmd.Parameters.Add("@IsHUBdebitNo", SqlDbType.Bit).Value = IsHUBdebitNo;
//[002] End Here
cn.Open();
DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
//return GetDebitFromReader(reader);
DebitDetails obj = new DebitDetails();
obj.DebitId = GetReaderValue_Int32(reader, "DebitId", 0);
obj.DebitNumber = GetReaderValue_Int32(reader, "DebitNumber", 0);
obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0);
obj.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0);
obj.ContactNo = GetReaderValue_Int32(reader, "ContactNo", 0);
obj.DebitDate = GetReaderValue_DateTime(reader, "DebitDate", DateTime.MinValue);
obj.CurrencyNo = GetReaderValue_Int32(reader, "CurrencyNo", 0);
obj.RaisedBy = GetReaderValue_NullableInt32(reader, "RaisedBy", null);
obj.Buyer = GetReaderValue_Int32(reader, "Buyer", 0);
obj.Notes = GetReaderValue_String(reader, "Notes", "");
obj.Instructions = GetReaderValue_String(reader, "Instructions", "");
obj.Freight = GetReaderValue_NullableDouble(reader, "Freight", null);
obj.DivisionNo = GetReaderValue_Int32(reader, "DivisionNo", 0);
obj.TaxNo = GetReaderValue_NullableInt32(reader, "TaxNo", null);
obj.PurchaseOrderNo = GetReaderValue_NullableInt32(reader, "PurchaseOrderNo", null);
obj.SupplierRMANo = GetReaderValue_NullableInt32(reader, "SupplierRMANo", null);
obj.ReferenceDate = GetReaderValue_DateTime(reader, "ReferenceDate", DateTime.MinValue);
obj.SupplierInvoice = GetReaderValue_String(reader, "SupplierInvoice", "");
obj.SupplierRMA = GetReaderValue_String(reader, "SupplierRMA", "");
obj.SupplierCredit = GetReaderValue_String(reader, "SupplierCredit", "");
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue);
obj.CompanyName = GetReaderValue_String(reader, "CompanyName", "");
obj.ContactName = GetReaderValue_String(reader, "ContactName", "");
obj.RaiserName = GetReaderValue_String(reader, "RaiserName", "");
obj.PurchaseOrderNumber = GetReaderValue_Int32(reader, "PurchaseOrderNumber", 0);
obj.SupplierRMANumber = GetReaderValue_NullableInt32(reader, "SupplierRMANumber", null);
obj.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", "");
obj.CurrencyDescription = GetReaderValue_String(reader, "CurrencyDescription", "");
obj.BuyerName = GetReaderValue_String(reader, "BuyerName", "");
obj.TeamNo = GetReaderValue_NullableInt32(reader, "TeamNo", null);
obj.DivisionName = GetReaderValue_String(reader, "DivisionName", "");
obj.TaxName = GetReaderValue_String(reader, "TaxName", "");
obj.PurchaseOrderDate = GetReaderValue_DateTime(reader, "PurchaseOrderDate", DateTime.MinValue);
obj.DebitValue = GetReaderValue_NullableDouble(reader, "DebitValue", null);
obj.TaxRate = GetReaderValue_NullableDouble(reader, "TaxRate", null);
obj.CompanyTelephone = GetReaderValue_String(reader, "CompanyTelephone", "");
obj.CompanyFax = GetReaderValue_String(reader, "CompanyFax", "");
obj.ContactEmail = GetReaderValue_String(reader, "ContactEmail", "");
obj.VATNO = GetReaderValue_String(reader, "VATNo", "");
obj.SupplierCode = GetReaderValue_String(reader, "SupplierCode", "");
obj.POHubCompanyNo = GetReaderValue_NullableInt32(reader, "POHubCompanyNo", null);
obj.POHubCompanyName = GetReaderValue_String(reader, "POHubCompanyName", "");
obj.ClientRefNo = GetReaderValue_String(reader, "ClientRefNo", "");
return(obj);
}
else
{
return(null);
}
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Debit", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
