public DataTable GetReportGeneralLedger(string AccountCodeFrom, string AccountCodeTo, Nullable <DateTime> DateFrom, Nullable <DateTime> DateTo)
{
DataTable dtReport = new DataTable();
Smartworks.ColumnField[] rLedger = new Smartworks.ColumnField[4];
rLedger[0] = new Smartworks.ColumnField("@AccountCodeFrom", AccountCodeFrom);
rLedger[1] = new Smartworks.ColumnField("@AccountCodeTo", AccountCodeTo);
if (DateFrom == null)
{
rLedger[2] = new Smartworks.ColumnField("@DateFrom", DBNull.Value);
}
else
{
rLedger[2] = new Smartworks.ColumnField("@DateFrom", DateFrom);
}
if (DateTo == null)
{
rLedger[3] = new Smartworks.ColumnField("@DateTo", DBNull.Value);
}
else
{
rLedger[3] = new Smartworks.ColumnField("@DateTo", DateTo);
}
dtReport = dataAccess.getDataTableByStoredProcedure("ReportGeneralLedger", rLedger);
return(dtReport);
}
private void btnVoucherToCodeSearch_Click(object sender, EventArgs e)
{
try
{
frmSearch search = new frmSearch();
Smartworks.ColumnField[] sVoucher = new Smartworks.ColumnField[1];
sVoucher[0] = new Smartworks.ColumnField("@Type", "CR");
search.getattributes("sp_GetVoucherSearch", sVoucher, "VoucherMaster");
search.ShowDialog();
if (!string.IsNullOrEmpty(MainForm.Searched_Id))
{
txtVoucherToCode.Text = MainForm.Searched_Id;
MainForm.Searched_Id = string.Empty;
}
else
{
txtVoucherToCode.Text = string.Empty;
txtVoucherToCode.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public int InsertUpdateProductionDetail(int PDId, int PMId, int ProductId, int ActualProductId, int WarehouseId, int UnitId,
int ColorId, decimal AssumeQty, decimal AvailableQty, decimal ConsumeQty, decimal BalanceQty, decimal Rate, decimal Amount, string Remarks, Smartworks.DAL customedataAcess = null)
{
int Id = -1;
Smartworks.ColumnField[] iProductionDetail = new Smartworks.ColumnField[14];
iProductionDetail[0] = new Smartworks.ColumnField("@PDId", PDId);
iProductionDetail[1] = new Smartworks.ColumnField("@PMId", PMId);
iProductionDetail[2] = new Smartworks.ColumnField("@ProductId", ProductId);
iProductionDetail[3] = new Smartworks.ColumnField("@ActualProductId", ActualProductId);
iProductionDetail[4] = new Smartworks.ColumnField("@WarehouseId", WarehouseId);
iProductionDetail[5] = new Smartworks.ColumnField("@UnitId", UnitId);
iProductionDetail[6] = new Smartworks.ColumnField("@ColorId", ColorId);
iProductionDetail[7] = new Smartworks.ColumnField("@AssumeQty", AssumeQty);
iProductionDetail[8] = new Smartworks.ColumnField("@AvailableQty", AvailableQty);
iProductionDetail[9] = new Smartworks.ColumnField("@ConsumeQty", ConsumeQty);
iProductionDetail[10] = new Smartworks.ColumnField("@BalanceQty", BalanceQty);
iProductionDetail[11] = new Smartworks.ColumnField("@Rate", Rate);
iProductionDetail[12] = new Smartworks.ColumnField("@Amount", Amount);
iProductionDetail[13] = new Smartworks.ColumnField("@Remarks", Remarks);
if (customedataAcess != null)
{
Id = Convert.ToInt32(customedataAcess.ExecuteStoredProcedure("InsertUpdateProductionDetail", iProductionDetail));
}
else
{
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("InsertUpdateProductionDetail", iProductionDetail));
dataAccess.TransCommit();
}
return(Id);
}
public int InsertUpdateCampony(string Name, string Address, string Phone, string Fax,
String Email, string ContactPerson, string GSTNumber, string NTN, string Description, string Logo,
int AddedBy, DateTime AddedOn, string AddedIpAddr)
{
int id = 0;
Smartworks.ColumnField[] iCompany = new Smartworks.ColumnField[13];
iCompany[0] = new Smartworks.ColumnField("@Name", Name);
iCompany[1] = new Smartworks.ColumnField("@Address", Address);
iCompany[2] = new Smartworks.ColumnField("@Phone", Phone);
iCompany[3] = new Smartworks.ColumnField("@Fax", Fax);
iCompany[4] = new Smartworks.ColumnField("@Email", Email);
iCompany[5] = new Smartworks.ColumnField("@ContactPerson", ContactPerson);
iCompany[6] = new Smartworks.ColumnField("@GSTNumber", GSTNumber);
iCompany[7] = new Smartworks.ColumnField("@NTN", NTN);
iCompany[8] = new Smartworks.ColumnField("@Description", Description);
iCompany[9] = new Smartworks.ColumnField("@Logo", Logo);
iCompany[10] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iCompany[11] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iCompany[12] = new Smartworks.ColumnField("@AddedIpAddr", Address);
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertCompany", iCompany));
dataAccess.TransCommit();
return(id);
}
public DataTable GetPurchaseInvoiceReport(Nullable <DateTime> FromDate, Nullable <DateTime> ToDate, string FromInvoice, string ToInvoice, string FromVendor, string ToVendor, string PurchaseInvoiceNo = "")
{
DataTable dt = new DataTable();
Smartworks.ColumnField[] report = new Smartworks.ColumnField[7];
if (FromDate == null)
{
report[0] = new Smartworks.ColumnField("@FromDate", DBNull.Value);
}
else
{
report[0] = new Smartworks.ColumnField("@FromDate", FromDate);
}
if (ToDate == null)
{
report[1] = new Smartworks.ColumnField("@ToDate", DBNull.Value);
}
else
{
report[1] = new Smartworks.ColumnField("@ToDate", ToDate);
}
report[2] = new Smartworks.ColumnField("@FromInvoice", FromInvoice);
report[3] = new Smartworks.ColumnField("@ToInvoice", ToInvoice);
report[4] = new Smartworks.ColumnField("@FromVendor", FromVendor);
report[5] = new Smartworks.ColumnField("@ToVendor", ToVendor);
report[6] = new Smartworks.ColumnField("@PurchaseInvoiceNo", PurchaseInvoiceNo);
dt = dataAccess.getDataTableByStoredProcedure("sp_ReportPurhcaseInvoiceNoByInvoiceNo", report);
return(dt);
}
public int UpdatePromotionMaster(int PromotionId, DateTime Date, string SOrderNo, int ProductId, string Remarks, int GradeId, int WarehouseFrom, int WarehouseTo, int AddedBy,
DateTime AddedOn, string AddedIPAddr, Smartworks.DAL customdataAcess = null)
{
int Id = -1;
Smartworks.ColumnField[] uPromotion = new Smartworks.ColumnField[11];
uPromotion[0] = new Smartworks.ColumnField("@PromotionId", PromotionId);
uPromotion[1] = new Smartworks.ColumnField("@Date", Date);
uPromotion[2] = new Smartworks.ColumnField("@SOrderNo", SOrderNo);
uPromotion[3] = new Smartworks.ColumnField("@ProductId", ProductId);
uPromotion[4] = new Smartworks.ColumnField("@Remarks", Remarks);
uPromotion[5] = new Smartworks.ColumnField("@GradeId", GradeId);
uPromotion[6] = new Smartworks.ColumnField("@WarehouseFrom", WarehouseFrom);
uPromotion[7] = new Smartworks.ColumnField("@WarehouseTo", WarehouseTo);
uPromotion[8] = new Smartworks.ColumnField("@AddedBy", AddedBy);
uPromotion[9] = new Smartworks.ColumnField("@AddedOn", AddedOn);
uPromotion[10] = new Smartworks.ColumnField("@AddedIPAddr", AddedIPAddr);
if (customdataAcess != null)
{
Id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("dbo.UpdatePromotionMaster", uPromotion));
}
else
{
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.UpdatePromotionMaster", uPromotion));
dataAccess.TransCommit();
}
return(Id);
}
public void UpdateVendorLedger(int LedgerId, int VendorId, DateTime Date,
string PurchaseInvoiceNo, int PurchaseInvoiceId, decimal PurchaseAmount, string VoucherNo,
int VoucherId, decimal VoucherAmount, Smartworks.DAL customdataAcess = null)
{
Smartworks.ColumnField[] uVendorLedger = new Smartworks.ColumnField[9];
uVendorLedger[0] = new Smartworks.ColumnField("@LedgerId", LedgerId);
uVendorLedger[1] = new Smartworks.ColumnField("@VendorId", VendorId);
uVendorLedger[2] = new Smartworks.ColumnField("@Date", Date);
uVendorLedger[3] = new Smartworks.ColumnField("@PurchaseInvoiceNo", PurchaseInvoiceNo);
uVendorLedger[4] = new Smartworks.ColumnField("@PurchaseInvoiceId", PurchaseInvoiceId);
uVendorLedger[5] = new Smartworks.ColumnField("@PurchaseAmount", PurchaseAmount);
uVendorLedger[6] = new Smartworks.ColumnField("@VoucherNo", VoucherNo);
uVendorLedger[7] = new Smartworks.ColumnField("@VoucherId", VoucherId);
uVendorLedger[8] = new Smartworks.ColumnField("@VoucherAmount", VoucherAmount);
if (customdataAcess != null)
{
customdataAcess.ExecuteStoredProcedure("dbo.UpdateVendorLedger", uVendorLedger);
}
else
{
dataAccess.BeginTransaction();
dataAccess.ExecuteStoredProcedure("dbo.UpdateVendorLedger", uVendorLedger);
dataAccess.TransCommit();
}
}
public DataTable GetSalesInvoiceSummaryReport(Nullable <DateTime> FromDate, Nullable <DateTime> ToDate, string FromInvoice, string ToInvoice, string FromCustomer, string ToCustomer, bool IsDetailWise)
{
DataTable dt = new DataTable();
Smartworks.ColumnField[] report = new Smartworks.ColumnField[7];
if (FromDate == null)
{
report[0] = new Smartworks.ColumnField("@FromDate", DBNull.Value);
}
else
{
report[0] = new Smartworks.ColumnField("@FromDate", FromDate);
}
if (ToDate == null)
{
report[1] = new Smartworks.ColumnField("@ToDate", DBNull.Value);
}
else
{
report[1] = new Smartworks.ColumnField("@ToDate", ToDate);
}
report[2] = new Smartworks.ColumnField("@FromInvoice", FromInvoice);
report[3] = new Smartworks.ColumnField("@ToInvoice", ToInvoice);
report[4] = new Smartworks.ColumnField("@FromCustomer", FromCustomer);
report[5] = new Smartworks.ColumnField("@ToCustomer", ToCustomer);
report[6] = new Smartworks.ColumnField("@IsDetailWise", IsDetailWise);
dt = dataAccess.getDataTableByStoredProcedure("sp_ReportSalesInvoiceSummary", report);
return(dt);
}
public DataTable GetSalesDetailTypeReport(Nullable <DateTime> FromDate, Nullable <DateTime> ToDate, string FromCustomer, string ToCustomer, int ProductTypeId)
{
DataTable dt = new DataTable();
Smartworks.ColumnField[] report = new Smartworks.ColumnField[5];
if (FromDate == null)
{
report[0] = new Smartworks.ColumnField("@FromDate", DBNull.Value);
}
else
{
report[0] = new Smartworks.ColumnField("@FromDate", FromDate);
}
if (ToDate == null)
{
report[1] = new Smartworks.ColumnField("@ToDate", DBNull.Value);
}
else
{
report[1] = new Smartworks.ColumnField("@ToDate", ToDate);
}
report[2] = new Smartworks.ColumnField("@FromCustomer", FromCustomer);
report[3] = new Smartworks.ColumnField("@ToCustomer", ToCustomer);
report[4] = new Smartworks.ColumnField("@ProductTypeId", ProductTypeId);
dt = dataAccess.getDataTableByStoredProcedure("sp_ReportSalesDetailByProductType", report);
return(dt);
}
public void UpdateStockRequisition(int StockReqMasterId, DateTime Date, string OrderedBy, string DeliveredBy, int FromWarehouseId, int ToWarehouseId,
string Remarks, string BranchCode, bool Closed, bool IsApproved, Smartworks.DAL customdataAccess = null)
{
Smartworks.ColumnField[] uREQ = new Smartworks.ColumnField[10];
uREQ[0] = new Smartworks.ColumnField("@StockReqMasterId", StockReqMasterId);
uREQ[1] = new Smartworks.ColumnField("@Date", Date);
uREQ[2] = new Smartworks.ColumnField("@OrderedBy", OrderedBy);
uREQ[3] = new Smartworks.ColumnField("@DeliveredBy", DeliveredBy);
uREQ[4] = new Smartworks.ColumnField("@FromWarehouseId", FromWarehouseId);
uREQ[5] = new Smartworks.ColumnField("@ToWarehouseId", ToWarehouseId);
uREQ[6] = new Smartworks.ColumnField("@Remarks", Remarks);
uREQ[7] = new Smartworks.ColumnField("@BranchCode", BranchCode);
uREQ[8] = new Smartworks.ColumnField("@Closed", Closed);
uREQ[9] = new Smartworks.ColumnField("@IsApproved", IsApproved);
if (customdataAccess != null)
{
customdataAccess.ExecuteStoredProcedure("UpdateStockReqMaster", uREQ);
}
else
{
dataAccess.BeginTransaction();
dataAccess.ExecuteStoredProcedure("UpdateStockReqMaster", uREQ);
dataAccess.TransCommit();
}
}
public void UpdateSalesDetail(int SalesDetailId, Int32 ProductId, String StockType,
String BatchNo, DateTime ExpiryDate, Int32 WarehouseId, Decimal Quantity, Decimal Price, Decimal AmountReceived,
Decimal DiscountAmount, Decimal GSTPercent, Decimal GSTAmount, Int32 ReturnedQty,
Int32 UpdatedBy, DateTime UpdatedOn, Decimal UpdatedIpAddr)
{
Smartworks.ColumnField[] uSalesDetail = new Smartworks.ColumnField[20];
uSalesDetail[1] = new Smartworks.ColumnField("@ProductId ", ProductId);
uSalesDetail[2] = new Smartworks.ColumnField("@StockType ", StockType);
uSalesDetail[3] = new Smartworks.ColumnField("@BatchNo ", BatchNo);
uSalesDetail[4] = new Smartworks.ColumnField("@ExpiryDate ", ExpiryDate);
uSalesDetail[5] = new Smartworks.ColumnField("@WarehouseId", WarehouseId);
uSalesDetail[6] = new Smartworks.ColumnField("@Quantity ", Quantity);
uSalesDetail[7] = new Smartworks.ColumnField("@Price ", Price);
uSalesDetail[8] = new Smartworks.ColumnField("@DiscountPercent", AmountReceived);
uSalesDetail[9] = new Smartworks.ColumnField("@DiscountAmount ", DiscountAmount);
uSalesDetail[10] = new Smartworks.ColumnField("@GSTPercent ", GSTPercent);
uSalesDetail[11] = new Smartworks.ColumnField("@GSTAmount ", GSTAmount);
uSalesDetail[12] = new Smartworks.ColumnField("@ReturnedQty ", ReturnedQty);
uSalesDetail[13] = new Smartworks.ColumnField("@UpdatedBy ", UpdatedBy);
uSalesDetail[14] = new Smartworks.ColumnField("@UpdatedOn ", UpdatedOn);
uSalesDetail[15] = new Smartworks.ColumnField("@UpdatedIpAddr ", UpdatedIpAddr);
dataAccess.BeginTransaction();
dataAccess.ExecuteStoredProcedure("dbo.UpdateSalesDetail", uSalesDetail);
dataAccess.TransCommit();
}
public DataTable InsertStockRequisition(DateTime Date, string OrderedBy, string DeliveredBy, int FromWarehouseId, int ToWarehouseId,
string Remarks, string BranchCode, bool Closed, bool IsApproved, string ReqType, Smartworks.DAL customdataAccess = null)
{
DataTable dt = new DataTable();
Smartworks.ColumnField[] iREQ = new Smartworks.ColumnField[10];
iREQ[0] = new Smartworks.ColumnField("@Date", Date);
iREQ[1] = new Smartworks.ColumnField("@OrderedBy", OrderedBy);
iREQ[2] = new Smartworks.ColumnField("@DeliveredBy", DeliveredBy);
iREQ[3] = new Smartworks.ColumnField("@FromWarehouseId", FromWarehouseId);
iREQ[4] = new Smartworks.ColumnField("@ToWarehouseId", ToWarehouseId);
iREQ[5] = new Smartworks.ColumnField("@Remarks", Remarks);
iREQ[6] = new Smartworks.ColumnField("@BranchCode", BranchCode);
iREQ[7] = new Smartworks.ColumnField("@Closed", Closed);
iREQ[8] = new Smartworks.ColumnField("@IsApproved", IsApproved);
iREQ[9] = new Smartworks.ColumnField("@ReqType", ReqType);
if (customdataAccess != null)
{
dt = customdataAccess.getDataTableByStoredProcedure("InsertStockReqMaster", iREQ);
}
else
{
dataAccess.BeginTransaction();
dt = dataAccess.getDataTableByStoredProcedure("InsertStockReqMaster", iREQ);
dataAccess.TransCommit();
}
return(dt);
}
public DataTable GetReportTrialBalanceSheet(Nullable <DateTime> DateFrom, Nullable <DateTime> DateTo, bool OrderByCode)
{
DataTable dtReport = new DataTable();
Smartworks.ColumnField[] rLedger = new Smartworks.ColumnField[3];
if (DateFrom == null)
{
rLedger[0] = new Smartworks.ColumnField("@DateFrom", DBNull.Value);
}
else
{
rLedger[0] = new Smartworks.ColumnField("@DateFrom", DateFrom);
}
if (DateTo == null)
{
rLedger[1] = new Smartworks.ColumnField("@DateTo", DBNull.Value);
}
else
{
rLedger[1] = new Smartworks.ColumnField("@DateTo", DateTo);
}
rLedger[2] = new Smartworks.ColumnField("@OrderByCode", OrderByCode);
dtReport = dataAccess.getDataTableByStoredProcedure("sp_ReportTrialLedger", rLedger);
return(dtReport);
}
public DataTable GetReportCashLedger(string CashAccountCode, Nullable <DateTime> DateFrom, Nullable <DateTime> DateTo)
{
DataTable dtReport = new DataTable();
Smartworks.ColumnField[] rLedger = new Smartworks.ColumnField[3];
rLedger[0] = new Smartworks.ColumnField("@CashAccountCode", CashAccountCode);
if (DateFrom == null)
{
rLedger[1] = new Smartworks.ColumnField("@FromDate", DBNull.Value);
}
else
{
rLedger[1] = new Smartworks.ColumnField("@FromDate", DateFrom);
}
if (DateTo == null)
{
rLedger[2] = new Smartworks.ColumnField("@ToDate", DBNull.Value);
}
else
{
rLedger[2] = new Smartworks.ColumnField("@ToDate", DateTo);
}
dtReport = dataAccess.getDataTableByStoredProcedure("sp_ReportCashLedger", rLedger);
return(dtReport);
}
public DataTable GetReportPromotionStatus(Nullable <DateTime> FromDate, Nullable <DateTime> ToDate, string FromSONo, string ToSONo, string FromCustomer, string ToCustomer)
{
DataTable dtReport = new DataTable();
Smartworks.ColumnField[] rPOrder = new Smartworks.ColumnField[6];
if (FromDate == null)
{
rPOrder[0] = new Smartworks.ColumnField("@FromDate", DBNull.Value);
}
else
{
rPOrder[0] = new Smartworks.ColumnField("@FromDate", FromDate);
}
if (ToDate == null)
{
rPOrder[1] = new Smartworks.ColumnField("@ToDate", DBNull.Value);
}
else
{
rPOrder[1] = new Smartworks.ColumnField("@ToDate", ToDate);
}
rPOrder[2] = new Smartworks.ColumnField("@FromSOrderNo", FromSONo);
rPOrder[3] = new Smartworks.ColumnField("@ToSOrderNo", ToSONo);
rPOrder[4] = new Smartworks.ColumnField("@FromCustomer", FromCustomer);
rPOrder[5] = new Smartworks.ColumnField("@ToCustomer", ToCustomer);
dtReport = dataAccess.getDataTableByStoredProcedure("dbo.sp_ReportPromotionStatus", rPOrder);
return(dtReport);
}
public int InsertReceivedPayment(Int32 SaleMasterId, String TYPE, Decimal TotalAmount,
Decimal AmountReceived, Decimal CashBack, DateTime Date, Smartworks.DAL customdataAcess = null)
{
int id = 0;
Smartworks.ColumnField[] iReceivedPayment = new Smartworks.ColumnField[6];
iReceivedPayment[0] = new Smartworks.ColumnField("@SalesMasterId", SaleMasterId);
iReceivedPayment[1] = new Smartworks.ColumnField("@Type", TYPE);
iReceivedPayment[2] = new Smartworks.ColumnField("@TotalAmount", TotalAmount);
iReceivedPayment[3] = new Smartworks.ColumnField("@AmountReceived", AmountReceived);
iReceivedPayment[4] = new Smartworks.ColumnField("@CashBack", CashBack);
iReceivedPayment[5] = new Smartworks.ColumnField("@Date", Date);
if (customdataAcess != null)
{
id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("dbo.InsertPaymentReceived", iReceivedPayment));
}
else
{
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertPaymentReceived", iReceivedPayment));
dataAccess.TransCommit();
}
return(id);
}
public DataTable InsertPromotionMaster(DateTime Date, string SOrderNo, int ProductId, string Remarks, int GradeId, int WarehouseFrom, int WarehouseTo, int AddedBy,
DateTime AddedOn, string AddedIPAddr, Smartworks.DAL customdataAcess = null)
{
DataTable dt = new DataTable();
Smartworks.ColumnField[] iPromotion = new Smartworks.ColumnField[10];
iPromotion[0] = new Smartworks.ColumnField("@Date", Date);
iPromotion[1] = new Smartworks.ColumnField("@SOrderNo", SOrderNo);
iPromotion[2] = new Smartworks.ColumnField("@ProductId", ProductId);
iPromotion[3] = new Smartworks.ColumnField("@Remarks", Remarks);
iPromotion[4] = new Smartworks.ColumnField("@GradeId", GradeId);
iPromotion[5] = new Smartworks.ColumnField("@WarehouseFrom", WarehouseFrom);
iPromotion[6] = new Smartworks.ColumnField("@WarehouseTo", WarehouseTo);
iPromotion[7] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iPromotion[8] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iPromotion[9] = new Smartworks.ColumnField("@AddedIPAddr", AddedIPAddr);
if (customdataAcess != null)
{
dt = customdataAcess.getDataTableByStoredProcedure("dbo.InsertPromotionMaster", iPromotion);
}
else
{
dataAccess.BeginTransaction();
dt = dataAccess.getDataTableByStoredProcedure("dbo.InsertPromotionMaster", iPromotion);
dataAccess.TransCommit();
}
return(dt);
}
public void UpdateSalesMaster(int SalesMasterId, DateTime Date, DateTime DueDate, string CustomerCode,
String CustomerName, string Phone, Decimal TAmount, Decimal TDiscountPerc, Decimal TDiscount, Decimal AmountReceived,
string Remarks, bool Hold, int AddedBy, bool Posted,
DateTime AddedOn, String AddedIpAddr, Decimal CashReceived, Decimal CashBack, Decimal BankAmount, int TiltId)
{
Smartworks.ColumnField[] uSalesMaster = new Smartworks.ColumnField[20];
uSalesMaster[0] = new Smartworks.ColumnField("@SalesMasterId", SalesMasterId);
uSalesMaster[1] = new Smartworks.ColumnField("@Date", Date);
uSalesMaster[2] = new Smartworks.ColumnField("@DueDate", DueDate);
uSalesMaster[3] = new Smartworks.ColumnField("@CustomerCode", CustomerCode);
uSalesMaster[4] = new Smartworks.ColumnField("@CustomerName", CustomerName);
uSalesMaster[5] = new Smartworks.ColumnField("@Phone", Phone);
uSalesMaster[6] = new Smartworks.ColumnField("@TAmount", TAmount);
uSalesMaster[7] = new Smartworks.ColumnField("@TDiscountPerc", TDiscountPerc);
uSalesMaster[8] = new Smartworks.ColumnField("@TDiscount", TDiscount);
uSalesMaster[9] = new Smartworks.ColumnField("@AmountReceived", AmountReceived);
uSalesMaster[10] = new Smartworks.ColumnField("@Remarks", Remarks);
uSalesMaster[11] = new Smartworks.ColumnField("@Hold", Hold);
uSalesMaster[12] = new Smartworks.ColumnField("@AddedBy", AddedBy);
uSalesMaster[13] = new Smartworks.ColumnField("@Posted", Posted);
uSalesMaster[14] = new Smartworks.ColumnField("@AddedOn", AddedOn);
uSalesMaster[15] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
uSalesMaster[16] = new Smartworks.ColumnField("@CashReceived", CashReceived);
uSalesMaster[17] = new Smartworks.ColumnField("@CashBack", CashBack);
uSalesMaster[18] = new Smartworks.ColumnField("@BankAmount", BankAmount);
uSalesMaster[19] = new Smartworks.ColumnField("@TiltId", TiltId);
dataAccess.BeginTransaction();
dataAccess.ExecuteStoredProcedure("dbo.UpdateSaleMaster", uSalesMaster);
dataAccess.TransCommit();
}
public int InsertVendorLedger(int VendorId, DateTime Date,
string PurchaseInvoiceNo, int PurchaseInvoiceId, decimal PurchaseAmount, string VoucherNo,
int VoucherId, decimal VoucherAmount,
Smartworks.DAL customdataAcess = null)
{
int id = 0;
Smartworks.ColumnField[] iVendorLedger = new Smartworks.ColumnField[8];
iVendorLedger[0] = new Smartworks.ColumnField("@VendorId", VendorId);
iVendorLedger[1] = new Smartworks.ColumnField("@Date", Date);
iVendorLedger[2] = new Smartworks.ColumnField("@PurchaseInvoiceNo", PurchaseInvoiceNo);
iVendorLedger[3] = new Smartworks.ColumnField("@PurchaseInvoiceId", PurchaseInvoiceId);
iVendorLedger[4] = new Smartworks.ColumnField("@PurchaseAmount", PurchaseAmount);
iVendorLedger[5] = new Smartworks.ColumnField("@VoucherNo", VoucherNo);
iVendorLedger[6] = new Smartworks.ColumnField("@VoucherId", VoucherId);
iVendorLedger[7] = new Smartworks.ColumnField("@VoucherAmount", VoucherAmount);
if (customdataAcess != null)
{
id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("dbo.InsertVendorLedger", iVendorLedger));
}
else
{
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertVendorLedger", iVendorLedger));
dataAccess.TransCommit();
}
return(id);
}
public int InsertVoucherDetail(int VoucherMasterId, string CustomerCode,
string VendorCode, int COAId, string AccountCode, string FlagDC, decimal Amount, string Remarks, Smartworks.DAL customdataAcess = null)
{
int id = 0;
Smartworks.ColumnField[] iVoucherDetail = new Smartworks.ColumnField[8];
iVoucherDetail[0] = new Smartworks.ColumnField("@VoucherMasterId", VoucherMasterId);
iVoucherDetail[1] = new Smartworks.ColumnField("@CustomerCode", (string.IsNullOrEmpty(CustomerCode) ? (object)DBNull.Value : CustomerCode));
iVoucherDetail[2] = new Smartworks.ColumnField("@VendorCode", (string.IsNullOrEmpty(VendorCode) ? (object)DBNull.Value : VendorCode));
iVoucherDetail[3] = new Smartworks.ColumnField("@COAId", COAId);
iVoucherDetail[4] = new Smartworks.ColumnField("@AccountCode", AccountCode);
iVoucherDetail[5] = new Smartworks.ColumnField("@FlagDC", FlagDC);
iVoucherDetail[6] = new Smartworks.ColumnField("@Amount", Amount);
iVoucherDetail[7] = new Smartworks.ColumnField("@Remarks", Remarks);
if (customdataAcess != null)
{
id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("dbo.InsertVoucherDetail", iVoucherDetail));
}
else
{
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertVoucherDetail", iVoucherDetail));
dataAccess.TransCommit();
}
return(id);
}
public int InsertVendor(string VendorName, string Address, string phoneNumber, string contactPerson, int COAId, string STRegistration, string NTN,
bool inactive,
int AddedBy, DateTime AddedOn, string AddedIpAddr, Smartworks.DAL customdataAcess = null)
{
int id = 0;
Smartworks.ColumnField[] iVendor = new Smartworks.ColumnField[11];
iVendor[0] = new Smartworks.ColumnField("@VendorName", VendorName);
iVendor[1] = new Smartworks.ColumnField("@Address", Address);
iVendor[2] = new Smartworks.ColumnField("@Phone", phoneNumber);
iVendor[3] = new Smartworks.ColumnField("@ContactPerson", contactPerson);
iVendor[4] = new Smartworks.ColumnField("@COAId", COAId);
iVendor[5] = new Smartworks.ColumnField("@STRegistration", STRegistration);
iVendor[6] = new Smartworks.ColumnField("@NTN", NTN);
iVendor[7] = new Smartworks.ColumnField("@IsActive", inactive);
iVendor[8] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iVendor[9] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iVendor[10] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
if (customdataAcess != null)
{
id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("dbo.InsertVendor", iVendor));
}
else
{
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertVendor", iVendor));
dataAccess.TransCommit();
}
return(id);
}
public DataTable InsertVoucharMaster(DateTime Date, string VoucherType,
string BranchCode, string Narration, decimal TotalDebit, decimal TotalCredit,
int AddedBy, DateTime AddedOn, string AddedIpAddr, Smartworks.DAL customdataAcess = null)
{
DataTable dt = new DataTable();
Smartworks.ColumnField[] iVoucharMaster = new Smartworks.ColumnField[9];
iVoucharMaster[0] = new Smartworks.ColumnField("@Date", Date);
iVoucharMaster[1] = new Smartworks.ColumnField("@VoucherType", VoucherType);
iVoucharMaster[2] = new Smartworks.ColumnField("@BranchCode", BranchCode);
iVoucharMaster[3] = new Smartworks.ColumnField("@Narration", Narration);
iVoucharMaster[4] = new Smartworks.ColumnField("@TotalDebit", TotalDebit);
iVoucharMaster[5] = new Smartworks.ColumnField("@TotalCredit", TotalCredit);
iVoucharMaster[6] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iVoucharMaster[7] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iVoucharMaster[8] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
if (customdataAcess != null)
{
dt = customdataAcess.getDataTableByStoredProcedure("dbo.InsertVoucharMaster", iVoucharMaster);
}
else
{
dataAccess.BeginTransaction();
dt = dataAccess.getDataTableByStoredProcedure("dbo.InsertVoucharMaster", iVoucharMaster);
dataAccess.TransCommit();
}
return(dt);
}
//public DataTable GetPurchaseMasterList()
//{
// DataTable dt = new DataTable();
// dt = dataAccess.getDataTable("Select PurchaseMasterId , upper(left(Name, 1)) + right(Name, len(Name) - 1) as VendorCode from PurchaseMaster Order by Name ");
// return dt;
//}
#region PurchaseDetailMethods
public int InsertPurchaseDetail(int PurchaseDetailId, int PurchaseMasterId, int RPODetailId, int ProductId, decimal ReceivedQty, decimal Price,
decimal DiscountPercent, decimal DiscountAmount, decimal ReturnedQty,
int AddedBy, DateTime AddedOn, string AddedIpAddr, Smartworks.DAL customdataAcess = null)
{
Int32 id = 0;
Smartworks.ColumnField[] iPurchaseDetail = new Smartworks.ColumnField[12];
iPurchaseDetail[0] = new Smartworks.ColumnField("@PurchaseDetailId", PurchaseDetailId);
iPurchaseDetail[1] = new Smartworks.ColumnField("@PurchaseMasterId", PurchaseMasterId);
iPurchaseDetail[2] = new Smartworks.ColumnField("@RPODetailId", RPODetailId);
iPurchaseDetail[3] = new Smartworks.ColumnField("@ProductId", ProductId);
iPurchaseDetail[4] = new Smartworks.ColumnField("@ReceivedQty", ReceivedQty);
iPurchaseDetail[5] = new Smartworks.ColumnField("@Price", Price);
iPurchaseDetail[6] = new Smartworks.ColumnField("@DiscountPercent", DiscountPercent);
iPurchaseDetail[7] = new Smartworks.ColumnField("@DiscountAmount", DiscountAmount);
iPurchaseDetail[8] = new Smartworks.ColumnField("@ReturnedQty", ReturnedQty);
iPurchaseDetail[9] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iPurchaseDetail[10] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iPurchaseDetail[11] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
if (customdataAcess != null)
{
id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("dbo.InsertPurchaseDetail", iPurchaseDetail));
}
else
{
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertPurchaseDetail", iPurchaseDetail));
}
return(id);
}
public int UpdateCashPayment(int VoucherMasterId, DateTime Date, string VoucherType,
string BranchCode, string Narration, decimal TotalDebit, decimal TotalCredit,
int AddedBy, DateTime AddedOn, string AddedIpAddr, decimal Amount, string AccountCode, Smartworks.DAL customdataAcess = null)
{
int Id = 0;
Smartworks.ColumnField[] uCashPayment = new Smartworks.ColumnField[12];
uCashPayment[0] = new Smartworks.ColumnField("@VoucherMasterId", VoucherMasterId);
uCashPayment[1] = new Smartworks.ColumnField("@Date", Date);
uCashPayment[2] = new Smartworks.ColumnField("@VoucherType", VoucherType);
uCashPayment[3] = new Smartworks.ColumnField("@BranchCode", BranchCode);
uCashPayment[4] = new Smartworks.ColumnField("@Narration", Narration);
uCashPayment[5] = new Smartworks.ColumnField("@TotalDebit", TotalDebit);
uCashPayment[6] = new Smartworks.ColumnField("@TotalCredit", TotalCredit);
uCashPayment[7] = new Smartworks.ColumnField("@AddedBy", AddedBy);
uCashPayment[8] = new Smartworks.ColumnField("@AddedOn", AddedOn);
uCashPayment[9] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
uCashPayment[10] = new Smartworks.ColumnField("@Amount", Amount);
uCashPayment[11] = new Smartworks.ColumnField("@AccountCode", AccountCode);
if (customdataAcess != null)
{
Id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("dbo.UpdateCashPayment", uCashPayment));
}
else
{
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.getDataTableByStoredProcedure("dbo.UpdateCashPayment", uCashPayment));
dataAccess.TransCommit();
}
return(Id);
}
private void btnPSearch_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txtSONo.Text))
{
MessageBox.Show("Please Select Sale Order Number.", "Sale Order is Required.", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
frmSearch search = new frmSearch();
Smartworks.ColumnField[] gSalesOrderProduct = new Smartworks.ColumnField[1];
gSalesOrderProduct[0] = new Smartworks.ColumnField("@SaleOrderNo", txtSONo.Text);
search.getattributes("GetProductSearchForSalesOrder", gSalesOrderProduct, "Products");
search.ShowDialog();
if (!string.IsNullOrEmpty(MainForm.Searched_Id))
{
txtPCode.Text = MainForm.Searched_Id;
MainForm.Searched_Id = string.Empty;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void UpdateVoucharMaster(int VoucherMasterId, DateTime Date, string VoucherType,
string BranchCode, string Narration, decimal TotalDebit, decimal TotalCredit
, int UpdatedBy, DateTime UpdatedOn, string UpdatedIpAddr, Smartworks.DAL customdataAccess = null)
{
Smartworks.ColumnField[] uVoucharMaster = new Smartworks.ColumnField[10];
uVoucharMaster[0] = new Smartworks.ColumnField("@VoucherMasterId", VoucherMasterId);
uVoucharMaster[1] = new Smartworks.ColumnField("@Date", Date);
uVoucharMaster[2] = new Smartworks.ColumnField("@VoucherType", VoucherType);
uVoucharMaster[3] = new Smartworks.ColumnField("@BranchCode", BranchCode);
uVoucharMaster[4] = new Smartworks.ColumnField("@Narration", Narration);
uVoucharMaster[5] = new Smartworks.ColumnField("@TotalDebit", TotalDebit);
uVoucharMaster[6] = new Smartworks.ColumnField("@TotalCredit", TotalCredit);
uVoucharMaster[7] = new Smartworks.ColumnField("@UpdatedBy", UpdatedBy);
uVoucharMaster[8] = new Smartworks.ColumnField("@UpdatedOn", UpdatedOn);
uVoucharMaster[9] = new Smartworks.ColumnField("@UpdatedIpAddr", UpdatedIpAddr);
if (customdataAccess != null)
{
customdataAccess.ExecuteStoredProcedure("dbo.UpdateVoucharMaster", uVoucharMaster);
}
else
{
dataAccess.BeginTransaction();
dataAccess.ExecuteStoredProcedure("dbo.UpdateVoucharMaster", uVoucharMaster);
dataAccess.TransCommit();
}
}
private void btnPAccSearch_Click(object sender, EventArgs e)
{
try
{
if (cmbCategory.SelectedIndex == 0)
{
MessageBox.Show("Please Select Account Category First.", "Account Category not Found", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
frmSearch search = new frmSearch();
Smartworks.ColumnField[] gCOA = new Smartworks.ColumnField[1];
gCOA[0] = new Smartworks.ColumnField("@CategoryId", Convert.ToInt32(cmbCategory.SelectedValue));
search.getattributes("GetCOASearchByCategory", gCOA, "Chart Of Accounts");
search.ShowDialog();
if (!string.IsNullOrEmpty(MainForm.Searched_Id))
{
txtPAccCode.Text = MainForm.Searched_Id;
MainForm.Searched_Id = string.Empty;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public int InsertUpdatePromotionDetail(int PromotionDetailId, int PromotionId, int S39, int S40, int S41, int S42, int S43, int S44, int S45, int S46, int S47, Smartworks.DAL customdataAcess = null)
{
int Id = -1;
Smartworks.ColumnField[] iuPromotionDetail = new Smartworks.ColumnField[11];
iuPromotionDetail[0] = new Smartworks.ColumnField("@PromotionDetailId", PromotionDetailId);
iuPromotionDetail[1] = new Smartworks.ColumnField("@PromotionId", PromotionId);
iuPromotionDetail[2] = new Smartworks.ColumnField("@S39", S39);
iuPromotionDetail[3] = new Smartworks.ColumnField("@S40", S40);
iuPromotionDetail[4] = new Smartworks.ColumnField("@S41", S41);
iuPromotionDetail[5] = new Smartworks.ColumnField("@S42", S42);
iuPromotionDetail[6] = new Smartworks.ColumnField("@S43", S43);
iuPromotionDetail[7] = new Smartworks.ColumnField("@S44", S44);
iuPromotionDetail[8] = new Smartworks.ColumnField("@S45", S45);
iuPromotionDetail[9] = new Smartworks.ColumnField("@S46", S46);
iuPromotionDetail[10] = new Smartworks.ColumnField("@S47", S47);
if (customdataAcess != null)
{
Id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("dbo.sp_InsertUpdatePromotionDetail", iuPromotionDetail));
}
else
{
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.sp_InsertUpdatePromotionDetail", iuPromotionDetail));
dataAccess.TransCommit();
}
return(Id);
}
public DataTable GetReportProductionStatus(Nullable <DateTime> FromDate, Nullable <DateTime> ToDate)
{
DataTable dtReport = new DataTable();
Smartworks.ColumnField[] rPOrder = new Smartworks.ColumnField[2];
if (FromDate == null)
{
rPOrder[0] = new Smartworks.ColumnField("@FromDate", DBNull.Value);
}
else
{
rPOrder[0] = new Smartworks.ColumnField("@FromDate", FromDate);
}
if (ToDate == null)
{
rPOrder[1] = new Smartworks.ColumnField("@ToDate", DBNull.Value);
}
else
{
rPOrder[1] = new Smartworks.ColumnField("@ToDate", ToDate);
}
dtReport = dataAccess.getDataTableByStoredProcedure("dbo.sp_ReportProductionStatus", rPOrder);
return(dtReport);
}
public void UpdatePackingList(int PackingListId, string SOrderNo, DateTime Date, DateTime SODate, int WarehouseId, string CustomerCode, string EmployeeCode
, decimal TQuantity, bool Closed, string Remarks, string GatePassNo, int AddedBy, DateTime AddedOn, string AddedIpAddr, Smartworks.DAL customdataAcess = null)
{
Smartworks.ColumnField[] uPackingList = new Smartworks.ColumnField[14];
uPackingList[0] = new Smartworks.ColumnField("@PackingListId", PackingListId);
uPackingList[1] = new Smartworks.ColumnField("@SOrderNo", SOrderNo);
uPackingList[2] = new Smartworks.ColumnField("@Date", Date);
uPackingList[3] = new Smartworks.ColumnField("@SODate", SODate);
uPackingList[4] = new Smartworks.ColumnField("@WarehouseId", WarehouseId);
uPackingList[5] = new Smartworks.ColumnField("@CustomerCode", CustomerCode);
uPackingList[6] = new Smartworks.ColumnField("@EmployeeCode", EmployeeCode);
uPackingList[7] = new Smartworks.ColumnField("@TQuantity", TQuantity);
uPackingList[8] = new Smartworks.ColumnField("@Closed", Closed);
uPackingList[9] = new Smartworks.ColumnField("@Remarks", Remarks);
uPackingList[10] = new Smartworks.ColumnField("@GatePassNo", GatePassNo);
uPackingList[11] = new Smartworks.ColumnField("@UpdatedBy", AddedBy);
uPackingList[12] = new Smartworks.ColumnField("@UpdatedOn", AddedOn);
uPackingList[13] = new Smartworks.ColumnField("@UpdatedIpAddr", AddedIpAddr);
if (customdataAcess != null)
{
customdataAcess.ExecuteStoredProcedure("dbo.UpdatePackingListMaster", uPackingList);
}
else
{
dataAccess.BeginTransaction();
dataAccess.ExecuteStoredProcedure("dbo.UpdatePackingListMaster", uPackingList);
dataAccess.TransCommit();
}
}
