public DataTable GetPurchaseOrderReport(Nullable <DateTime> FromDate, Nullable <DateTime> ToDate, string FromPONo, string ToPONo, string FromVendor, string ToVendor, int POrderId)
{
DataTable dtReport = new DataTable();
Smartworks.ColumnField[] rPOrder = new Smartworks.ColumnField[7];
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("@FromPONo", FromPONo);
rPOrder[3] = new Smartworks.ColumnField("@ToPONo", ToPONo);
rPOrder[4] = new Smartworks.ColumnField("@FromVendor", FromVendor);
rPOrder[5] = new Smartworks.ColumnField("@ToVendor", ToVendor);
rPOrder[6] = new Smartworks.ColumnField("@POrderId", POrderId);
dtReport = dataAccess.getDataTableByStoredProcedure("dbo.sp_ReportPurchaseOrder", rPOrder);
return(dtReport);
}
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);
}
public DataTable InsertWTMaster(int RequestedBy, int WarehouseFrom, int WarehouseTo, DateTime TransferDate, string SOrderNo, int ProductId, string Narration, bool Hold, bool Posted, string BranchCode,
int AddedBy, DateTime AddedOn, string AddedIpAddr, bool IsStartProcessing, decimal ProcessQty, string BatchNo, Smartworks.DAL customdataAcess = null)
{
DataTable dt = new DataTable();
Smartworks.ColumnField[] iWTMaster = new Smartworks.ColumnField[16];
iWTMaster[0] = new Smartworks.ColumnField("@RequestedBy", RequestedBy);
iWTMaster[1] = new Smartworks.ColumnField("@WarehouseFrom", WarehouseFrom);
iWTMaster[2] = new Smartworks.ColumnField("@WarehouseTo", WarehouseTo);
iWTMaster[3] = new Smartworks.ColumnField("@TransferDate", TransferDate);
iWTMaster[4] = new Smartworks.ColumnField("@SOrderNo", SOrderNo);
iWTMaster[5] = new Smartworks.ColumnField("@ProductId", ProductId);
iWTMaster[6] = new Smartworks.ColumnField("@Narration", Narration);
iWTMaster[7] = new Smartworks.ColumnField("@Hold", Hold);
iWTMaster[8] = new Smartworks.ColumnField("@Posted", Posted);
iWTMaster[9] = new Smartworks.ColumnField("@BranchCode", BranchCode);
iWTMaster[10] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iWTMaster[11] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iWTMaster[12] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
iWTMaster[13] = new Smartworks.ColumnField("@IsStartProcessing", IsStartProcessing);
iWTMaster[14] = new Smartworks.ColumnField("@ProcessQty", ProcessQty);
iWTMaster[15] = new Smartworks.ColumnField("@BatchNo", BatchNo);
if (customdataAcess != null)
{
dt = customdataAcess.getDataTableByStoredProcedure("dbo.InsertWTMaster", iWTMaster);
}
else
{
dataAccess.BeginTransaction();
dt = customdataAcess.getDataTableByStoredProcedure("dbo.InsertWTMaster", iWTMaster);
dataAccess.TransCommit();
}
return(dt);
}
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 DataTable InsertPackingListMaster(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)
{
DataTable dt = new DataTable();
Smartworks.ColumnField[] iPackingList = new Smartworks.ColumnField[13];
iPackingList[0] = new Smartworks.ColumnField("@SOrderNo", SOrderNo);
iPackingList[1] = new Smartworks.ColumnField("@Date", Date);
iPackingList[2] = new Smartworks.ColumnField("@SODate", SODate);
iPackingList[3] = new Smartworks.ColumnField("@WarehouseId", WarehouseId);
iPackingList[4] = new Smartworks.ColumnField("@CustomerCode", CustomerCode);
iPackingList[5] = new Smartworks.ColumnField("@EmployeeCode", EmployeeCode);
iPackingList[6] = new Smartworks.ColumnField("@TQuantity", TQuantity);
iPackingList[7] = new Smartworks.ColumnField("@Closed", Closed);
iPackingList[8] = new Smartworks.ColumnField("@Remarks", Remarks);
iPackingList[9] = new Smartworks.ColumnField("@GatePassNo", GatePassNo);
iPackingList[10] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iPackingList[11] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iPackingList[12] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
if (customdataAcess != null)
{
dt = customdataAcess.getDataTableByStoredProcedure("dbo.InsertPackingListMaster", iPackingList);
}
else
{
dataAccess.BeginTransaction();
dt = dataAccess.getDataTableByStoredProcedure("dbo.InsertPackingListMaster", iPackingList);
dataAccess.TransCommit();
}
return(dt);
}
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 GetCustomerByUserId(int UserId)
{
DataTable dt;
Smartworks.ColumnField[] gCustomer = new Smartworks.ColumnField[1];
gCustomer[0] = new Smartworks.ColumnField("@UserId", UserId);
dt = dataAccess.getDataTableByStoredProcedure("dbo.GetCustomer", gCustomer);
return(dt);
}
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 InsertProcessMaster(DateTime Date, int ProductId, decimal ProcessQty,
int WarehouseId, int TransferWarehouseId, string SOrderNo, string Remarks, Smartworks.DAL customedataAcess = null)
{
DataTable dt = null;
Smartworks.ColumnField[] iProcessMaster = new Smartworks.ColumnField[7];
iProcessMaster[0] = new Smartworks.ColumnField("@Date", Date);
iProcessMaster[1] = new Smartworks.ColumnField("@ProductId", ProductId);
iProcessMaster[2] = new Smartworks.ColumnField("@ProcessQty", ProcessQty);
iProcessMaster[3] = new Smartworks.ColumnField("@WarehouseId", WarehouseId);
iProcessMaster[4] = new Smartworks.ColumnField("@TransferWarehouseId", TransferWarehouseId);
iProcessMaster[5] = new Smartworks.ColumnField("@SOrderNo", SOrderNo);
iProcessMaster[6] = new Smartworks.ColumnField("@Remarks", Remarks);
if (customedataAcess != null)
{
dt = customedataAcess.getDataTableByStoredProcedure("InsertProcessMaster", iProcessMaster);
}
else
{
dataAccess.BeginTransaction();
dt = dataAccess.getDataTableByStoredProcedure("InsertProcessMaster", iProcessMaster);
dataAccess.TransCommit();
}
return(dt);
}
public int InsertUpdateBankVoucherDetail(int BankVoucherDetailId, DateTime Date, string CustomerCode, string VendorCode, int BankId, int BankAccountId, decimal ChequeAmount,
DateTime ChequeDate, int ChequeBankId, string ChequeNumber, string VoucherNature, int VoucherId, string VoucherType, string BillNo, DateTime BillDate, Smartworks.DAL customdataAcess = null)
{
int BVDId = -1;
Smartworks.ColumnField[] iuBankVoucherDetail = new Smartworks.ColumnField[15];
iuBankVoucherDetail[0] = new Smartworks.ColumnField("@BankVoucherDetailId", BankVoucherDetailId);
iuBankVoucherDetail[1] = new Smartworks.ColumnField("@Date", Date);
iuBankVoucherDetail[2] = new Smartworks.ColumnField("@CustomerCode", CustomerCode);
iuBankVoucherDetail[3] = new Smartworks.ColumnField("@VendorCode", VendorCode);
iuBankVoucherDetail[4] = new Smartworks.ColumnField("@BankId", BankId);
iuBankVoucherDetail[5] = new Smartworks.ColumnField("@BankAccountId", BankAccountId);
iuBankVoucherDetail[6] = new Smartworks.ColumnField("@ChequeAmount", ChequeAmount);
iuBankVoucherDetail[7] = new Smartworks.ColumnField("@ChequeDate", ChequeDate);
iuBankVoucherDetail[8] = new Smartworks.ColumnField("@ChequeBankId", ChequeBankId);
iuBankVoucherDetail[9] = new Smartworks.ColumnField("@ChequeNumber", ChequeNumber);
iuBankVoucherDetail[10] = new Smartworks.ColumnField("@VoucherNature", VoucherNature);
iuBankVoucherDetail[11] = new Smartworks.ColumnField("@VoucherId", VoucherId);
iuBankVoucherDetail[12] = new Smartworks.ColumnField("@VoucherType", VoucherType);
iuBankVoucherDetail[13] = new Smartworks.ColumnField("@BillNo", BillNo);
iuBankVoucherDetail[14] = new Smartworks.ColumnField("@BillDate", BillDate);
if (customdataAcess != null)
{
BVDId = Convert.ToInt32(customdataAcess.getDataTableByStoredProcedure("dbo.InsertUpdateBankVoucherDetail", iuBankVoucherDetail).Rows[0]["Id"]);
}
else
{
dataAccess.BeginTransaction();
BVDId = Convert.ToInt32(dataAccess.getDataTableByStoredProcedure("dbo.InsertVoucharMaster", iuBankVoucherDetail));
dataAccess.TransCommit();
}
return(BVDId);
}
// public DataTable GetRolePrivilege(int roleId)
// {
// DataTable dt;
// //string queryString = " SELECT dbo.Menu.MenuName, dbo.Menu.MenuId, dbo.RolePrivilege.* " +
// // " FROM dbo.RolePrivilege INNER JOIN " +
// // " dbo.Menu ON dbo.RolePrivilege.MenuId = dbo.Menu.MenuId and " +
// // " dbo.RolePrivilege.RoleId = " + roleId;
// string queryString = " SELECT user_privilege.roleId, " +
//" Isnull(dbo.user_privilege.Privilege_Id , -1) as Privilege_Id, " +
// " Isnull(dbo.user_privilege.Menu_Id , Menu.MenuId ) as Menu_Id," +
// " Isnull(dbo.user_privilege.Privilege_Allow , 0 ) as Privilege_Allow, isnull(dbo.user_privilege.Privilege_Add , 0) as Privilege_Add, " +
// " isnull(dbo.user_privilege.Privilege_Edit , 0) as Privilege_Edit, isnull(dbo.user_privilege.Privilege_Delete , 0) as Privilege_Delete, " +
// " isnull(dbo.user_privilege.Privilege_Post , 0) as Privilege_Post , Menu.MenuItemTitle as MenuName " +
// " from Menu " +
// " left join user_privilege on user_privilege.Menu_Id = Menu.MenuId " +
// " left join usertype on usertype.typeid=user_privilege.roleId " +
// " where dbo.user_privilege.RoleId = " + roleId + " or dbo.user_privilege.RoleId is null";
// //" FROM dbo.user_privilege"+
// // " inner join usertype on usertype.typeid=user_privilege.roleId"+
// // " left join Menu on user_privilege.Menu_Id = Menu.MenuId " +
// // " where dbo.user_privilege.RoleId = " + roleId;
// dataAccess.ConnectionOpen();
// dt = dataAccess.getDataTable(queryString);
// dataAccess.ConnectionClose();
// return dt;
// }
public DataTable GetRolePrivilege(int roleId)
{
DataTable dtRolePrivilege = new DataTable();
Smartworks.ColumnField[] gUserPrivilege = new Smartworks.ColumnField[1];
gUserPrivilege[0] = new Smartworks.ColumnField("@RoleId", roleId);
dtRolePrivilege = dataAccess.getDataTableByStoredProcedure("GetPrivilegeByRoleId", gUserPrivilege);
return(dtRolePrivilege);
}
public DataTable GetTransferSummaryReport(Nullable <DateTime> Date, int WarehouseId, string SOrderNo, int ProductId)
{
DataTable dt = new DataTable();
Smartworks.ColumnField[] report = new Smartworks.ColumnField[4];
if (Date == null)
{
report[0] = new Smartworks.ColumnField("@Date", DBNull.Value);
}
else
{
report[0] = new Smartworks.ColumnField("@Date", Date);
}
report[1] = new Smartworks.ColumnField("@FromWarehouse", WarehouseId);
report[2] = new Smartworks.ColumnField("@SOrderNo", SOrderNo);
report[3] = new Smartworks.ColumnField("@ProductId", ProductId);
dt = dataAccess.getDataTableByStoredProcedure("sp_ReportWarehouseTransferSummary", report);
return(dt);
}
//public DataTable GetVendorLedgerByCashPayment(string PaymentNo)
//{
// DataTable dt;
// dt = dataAccess.getDataTable("select * from [VendorLedger] where VoucherNo = '" + PaymentNo + "'");
// return dt;
//}
//public void DeleteVendorLedger(int LedgerId)
//{
// dataAccess.ExecuteNonQuery("Delete from VendorLedger where LedgerId = " + LedgerId);
//}
#region ReportProduct
public DataTable GetReportVendorLedger(String VendorCode, DateTime FromDate, DateTime ToDate)
{
DataTable dt = new DataTable();
Smartworks.ColumnField[] Vendorledger = new Smartworks.ColumnField[3];
Vendorledger[0] = new Smartworks.ColumnField("@VenderCode", VendorCode);
Vendorledger[1] = new Smartworks.ColumnField("@FromDate", FromDate);
Vendorledger[2] = new Smartworks.ColumnField("@ToDate", ToDate);
dt = dataAccess.getDataTableByStoredProcedure("sp_ReportVenderLedger", Vendorledger);
return(dt);
}
public DataTable InsertSalesReturnMaster(string SalesInvoiceNo, DateTime Date, string BranchCode, int WarehouseId, string CustomerCode, string ReturnedBy, string ReceivedBy,
decimal TAmount, decimal TDiscountPerc, decimal TDiscount, decimal FreightCharges, decimal GSTPercent, decimal GSTAmount, string Remarks, string VoucherNo, bool Posted, int AddedBy, DateTime AddedOn, string AddedIpAddr,
Smartworks.DAL customdataAcess)
{
DataTable dt = new DataTable();
Smartworks.ColumnField[] iSalesReturn = new Smartworks.ColumnField[19];
iSalesReturn[0] = new Smartworks.ColumnField("@SalesInvoiceNo", SalesInvoiceNo);
iSalesReturn[1] = new Smartworks.ColumnField("@Date", Date);
iSalesReturn[2] = new Smartworks.ColumnField("@BranchCode", BranchCode);
iSalesReturn[3] = new Smartworks.ColumnField("@WarehouseId", WarehouseId);
iSalesReturn[4] = new Smartworks.ColumnField("@CustomerCode", CustomerCode);
iSalesReturn[5] = new Smartworks.ColumnField("@ReturnedBy", ReturnedBy);
iSalesReturn[6] = new Smartworks.ColumnField("@ReceivedBy", ReceivedBy);
iSalesReturn[7] = new Smartworks.ColumnField("@TAmount", TAmount);
iSalesReturn[8] = new Smartworks.ColumnField("@TDiscountPerc", TDiscountPerc);
iSalesReturn[9] = new Smartworks.ColumnField("@TDiscount", TDiscount);
iSalesReturn[10] = new Smartworks.ColumnField("@FreightCharges", FreightCharges);
iSalesReturn[11] = new Smartworks.ColumnField("@GSTPercent", GSTPercent);
iSalesReturn[12] = new Smartworks.ColumnField("@GSTAmount", GSTAmount);
iSalesReturn[13] = new Smartworks.ColumnField("@Remarks", Remarks);
iSalesReturn[14] = new Smartworks.ColumnField("@VoucherNo", VoucherNo);
iSalesReturn[15] = new Smartworks.ColumnField("@Posted", Posted);
iSalesReturn[16] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iSalesReturn[17] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iSalesReturn[18] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
if (customdataAcess != null)
{
dt = customdataAcess.getDataTableByStoredProcedure("InsertSalesReturnMaster", iSalesReturn);
}
else
{
dataAccess.BeginTransaction();
dt = dataAccess.getDataTableByStoredProcedure("InsertSalesReturnMaster", iSalesReturn);
dataAccess.TransCommit();
}
return(dt);
}
public DataTable InsertPurchaseMaster(string RPONo, DateTime ReceivedOn, DateTime DueDate, string VendorCode,
String EmployeeCode, decimal TAmount, decimal TDiscountPerc, decimal TDiscount, decimal GSTPercent, decimal GSTAmount, decimal AmountPaid,
string Remarks, string VoucherNo, int AddedBy
, DateTime AddedOn, String AddedIpAddr, bool Hold, bool Posted
, Smartworks.DAL customdataAcess = null)
{
DataTable dt = new DataTable();
Smartworks.ColumnField[] iPurchaseMaster = new Smartworks.ColumnField[18];
iPurchaseMaster[0] = new Smartworks.ColumnField("@RPONo", RPONo);
iPurchaseMaster[1] = new Smartworks.ColumnField("@ReceivedOn", ReceivedOn);
iPurchaseMaster[2] = new Smartworks.ColumnField("@DueDate", DueDate);
iPurchaseMaster[3] = new Smartworks.ColumnField("@VendorCode", VendorCode);
iPurchaseMaster[4] = new Smartworks.ColumnField("@EmployeeCode", EmployeeCode);
iPurchaseMaster[5] = new Smartworks.ColumnField("@TAmount", TAmount);
iPurchaseMaster[6] = new Smartworks.ColumnField("@TDiscountPerc", TDiscountPerc);
iPurchaseMaster[7] = new Smartworks.ColumnField("@TDiscount", TDiscount);
iPurchaseMaster[8] = new Smartworks.ColumnField("@GSTPercent", GSTPercent);
iPurchaseMaster[9] = new Smartworks.ColumnField("@GSTAmount", GSTAmount);
iPurchaseMaster[10] = new Smartworks.ColumnField("@AmountPaid", AmountPaid);
iPurchaseMaster[11] = new Smartworks.ColumnField("@Remarks", Remarks);
iPurchaseMaster[12] = new Smartworks.ColumnField("@VoucherNo", VoucherNo);
iPurchaseMaster[13] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iPurchaseMaster[14] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iPurchaseMaster[15] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
iPurchaseMaster[16] = new Smartworks.ColumnField("@Hold", Hold);
iPurchaseMaster[17] = new Smartworks.ColumnField("@Posted", Posted);
if (customdataAcess != null)
{
dt = customdataAcess.getDataTableByStoredProcedure("dbo.InsertPurchaseMaster", iPurchaseMaster);
}
else
{
dataAccess.BeginTransaction();
dt = dataAccess.getDataTableByStoredProcedure("dbo.InsertPurchaseMaster", iPurchaseMaster);
dataAccess.TransCommit();
}
return(dt);
}
public DataTable GetUserName(string userName, string password)
{
DataTable dt = new DataTable();
Smartworks.ColumnField[] GetUserManager = new Smartworks.ColumnField[2];
GetUserManager[0] = new Smartworks.ColumnField("@UserName", userName);
GetUserManager[1] = new Smartworks.ColumnField("@Password", Encrypt(password));
try
{
dataAccess.ConnectionOpen();
dt = dataAccess.getDataTableByStoredProcedure("dbo.GetUserName", GetUserManager);
dataAccess.ConnectionClose();
}
catch (Exception ex)
{
}
finally
{
dataAccess.ConnectionClose();
}
return(dt);
}
public DataTable GetRolesById(int roleId)
{
DataTable dt;
Smartworks.ColumnField[] gRole = new Smartworks.ColumnField[1];
gRole[0] = new Smartworks.ColumnField("@RoleId", roleId);
dt = dataAccess.getDataTableByStoredProcedure("dbo.GetRolesByRoleId", gRole);
return(dt);
}
public DataTable InsertSalesMaster(int SalesMasterId, string PackingListNo, DateTime Date, DateTime DueDate, string CustomerCode, string OrderedBy,
string Phone, decimal TAmount, decimal TDiscountPerc, decimal TDiscount, decimal AmountReceived,
decimal GSTPercent, decimal GSTAmount, string Remarks, bool Hold, int AddedBy, bool Posted,
DateTime AddedOn, string AddedIpAddr, decimal CashReceived, decimal CashBack, decimal BankAmount, int TiltId, bool IsGSTInvoice, int FYear
, Smartworks.DAL customdataAcess = null)
{
DataTable dt = new DataTable();
Smartworks.ColumnField[] iSalesMaster = new Smartworks.ColumnField[25];
iSalesMaster[0] = new Smartworks.ColumnField("@SalesMasterId", SalesMasterId);
iSalesMaster[1] = new Smartworks.ColumnField("@PackingListNo", PackingListNo);
iSalesMaster[2] = new Smartworks.ColumnField("@Date", Date);
iSalesMaster[3] = new Smartworks.ColumnField("@DueDate", DueDate);
iSalesMaster[4] = new Smartworks.ColumnField("@CustomerCode", CustomerCode);
iSalesMaster[5] = new Smartworks.ColumnField("@OrderedBy", OrderedBy);
iSalesMaster[6] = new Smartworks.ColumnField("@Phone", Phone);
iSalesMaster[7] = new Smartworks.ColumnField("@TAmount", TAmount);
iSalesMaster[8] = new Smartworks.ColumnField("@TDiscountPerc", TDiscountPerc);
iSalesMaster[9] = new Smartworks.ColumnField("@TDiscount", TDiscount);
iSalesMaster[10] = new Smartworks.ColumnField("@AmountReceived", AmountReceived);
iSalesMaster[11] = new Smartworks.ColumnField("@GSTPercent", GSTPercent);
iSalesMaster[12] = new Smartworks.ColumnField("@GSTAmount", GSTAmount);
iSalesMaster[13] = new Smartworks.ColumnField("@Remarks", Remarks);
iSalesMaster[14] = new Smartworks.ColumnField("@Hold", Hold);
iSalesMaster[15] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iSalesMaster[16] = new Smartworks.ColumnField("@Posted", Posted);
iSalesMaster[17] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iSalesMaster[18] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
iSalesMaster[19] = new Smartworks.ColumnField("@CashReceived", CashReceived);
iSalesMaster[20] = new Smartworks.ColumnField("@CashBack", CashBack);
iSalesMaster[21] = new Smartworks.ColumnField("@BankAmount", BankAmount);
iSalesMaster[22] = new Smartworks.ColumnField("@TiltId", TiltId);
iSalesMaster[23] = new Smartworks.ColumnField("@IsGSTInvoice", IsGSTInvoice);
iSalesMaster[24] = new Smartworks.ColumnField("@FYear", FYear);
if (customdataAcess != null)
{
dt = customdataAcess.getDataTableByStoredProcedure("dbo.InsertSaleMaster", iSalesMaster);
}
else
{
dataAccess.BeginTransaction();
dt = dataAccess.getDataTableByStoredProcedure("dbo.InsertSaleMaster", iSalesMaster);
dataAccess.TransCommit();
}
return(dt);
}
public DataTable InsertProductionMaster(DateTime Date, int ProductId, decimal ProcessQty, string Construction, string BatchNo,
int LastNoId, string SizeRange, string ModelSize, int PFMId, int StatusId, int WarehouseId, string SOrderNo, string Remarks,
bool Posted, int TransferWarehouseId, int S39, int S40, int S41, int S42, int S43, int S44, int S45, int S46, int S47,
int A39, int A40, int A41, int A42, int A43, int A44, int A45, int A46, int A47, int AddedBy,
DateTime AddedOn, string AddedIPAddr, int ToWarehouseId, decimal ActualQty, DateTime ProcessDate, bool IsCompleteStage, Smartworks.DAL customedataAcess = null)
{
DataTable dt = null;
Smartworks.ColumnField[] iProductionMaster = new Smartworks.ColumnField[40];
iProductionMaster[0] = new Smartworks.ColumnField("@Date", Date);
iProductionMaster[1] = new Smartworks.ColumnField("@ProductId", ProductId);
iProductionMaster[2] = new Smartworks.ColumnField("@ProcessQty", ProcessQty);
iProductionMaster[3] = new Smartworks.ColumnField("@Construction", Construction);
iProductionMaster[4] = new Smartworks.ColumnField("@BatchNo", BatchNo);
iProductionMaster[5] = new Smartworks.ColumnField("@LastNoId", LastNoId);
iProductionMaster[6] = new Smartworks.ColumnField("@SizeRange", SizeRange);
iProductionMaster[7] = new Smartworks.ColumnField("@ModelSize", ModelSize);
iProductionMaster[8] = new Smartworks.ColumnField("@PFMId", PFMId);
iProductionMaster[9] = new Smartworks.ColumnField("@StatusId", StatusId);
iProductionMaster[10] = new Smartworks.ColumnField("@WarehouseId", WarehouseId);
iProductionMaster[11] = new Smartworks.ColumnField("@SOrderNo", SOrderNo);
iProductionMaster[12] = new Smartworks.ColumnField("@Remarks", Remarks);
iProductionMaster[13] = new Smartworks.ColumnField("@Posted", Posted);
iProductionMaster[14] = new Smartworks.ColumnField("@TransferWarehouseId", TransferWarehouseId);
iProductionMaster[15] = new Smartworks.ColumnField("@S39", S39);
iProductionMaster[16] = new Smartworks.ColumnField("@S40", S40);
iProductionMaster[17] = new Smartworks.ColumnField("@S41", S41);
iProductionMaster[18] = new Smartworks.ColumnField("@S42", S42);
iProductionMaster[19] = new Smartworks.ColumnField("@S43", S43);
iProductionMaster[20] = new Smartworks.ColumnField("@S44", S44);
iProductionMaster[21] = new Smartworks.ColumnField("@S45", S45);
iProductionMaster[22] = new Smartworks.ColumnField("@S46", S46);
iProductionMaster[23] = new Smartworks.ColumnField("@S47", S47);
iProductionMaster[24] = new Smartworks.ColumnField("@A39", A39);
iProductionMaster[25] = new Smartworks.ColumnField("@A40", A40);
iProductionMaster[26] = new Smartworks.ColumnField("@A41", A41);
iProductionMaster[27] = new Smartworks.ColumnField("@A42", A42);
iProductionMaster[28] = new Smartworks.ColumnField("@A43", A43);
iProductionMaster[29] = new Smartworks.ColumnField("@A44", A44);
iProductionMaster[30] = new Smartworks.ColumnField("@A45", A45);
iProductionMaster[31] = new Smartworks.ColumnField("@A46", A46);
iProductionMaster[32] = new Smartworks.ColumnField("@A47", A47);
iProductionMaster[33] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iProductionMaster[34] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iProductionMaster[35] = new Smartworks.ColumnField("@AddedIPAddr", AddedIPAddr);
iProductionMaster[36] = new Smartworks.ColumnField("@ToWarehouseId", ToWarehouseId);
iProductionMaster[37] = new Smartworks.ColumnField("@ActualQty", ActualQty);
iProductionMaster[38] = new Smartworks.ColumnField("@ProcessDate", ProcessDate);
iProductionMaster[39] = new Smartworks.ColumnField("@IsCompleteStage", IsCompleteStage);
if (customedataAcess != null)
{
dt = customedataAcess.getDataTableByStoredProcedure("InsertProductionMaster", iProductionMaster);
}
else
{
dataAccess.BeginTransaction();
dt = dataAccess.getDataTableByStoredProcedure("InsertProductionMaster", iProductionMaster);
dataAccess.TransCommit();
}
return(dt);
}