public void UpdatePOrderMasterClosedMarked(int POrderMasterId, Smartworks.DAL customdataAcess = null)
{
if (customdataAcess != null)
{
customdataAcess.ExecuteNonQuery("Update POrderMaster set Closed = 1 where POrderId =" + POrderMasterId);
}
else
{
dataAccess.ExecuteNonQuery("Update POrderMaster set Closed = 1 where POrderId =" + POrderMasterId);
}
}
public bool UpdateRequisitionApproved(int RequisitionId, Smartworks.DAL customdataAcess)
{
bool result = false;
if (customdataAcess != null)
{
result = Convert.ToBoolean(customdataAcess.ExecuteNonQuery("Update [StockReqMaster] set IsApproved = 1 where StockReqMasterId = " + RequisitionId));
}
else
{
result = Convert.ToBoolean(dataAccess.ExecuteNonQuery("Update [StockReqMaster] set IsApproved = 1 where StockReqMasterId = " + RequisitionId));
}
return(result);
}
public DataTable GetVoucherMaster(int VoucherMasterId, Smartworks.DAL customdataAcess = null)
{
DataTable dt;
if (customdataAcess != null)
{
dt = customdataAcess.getDataTable("Select * from VoucherMaster where VoucherMasterId =" + VoucherMasterId);
}
else
{
dt = dataAccess.getDataTable("Select * from VoucherMaster where VoucherMasterId =" + VoucherMasterId);
}
return(dt);
}
public void DeleteRequisitionDetailByDetailId(int StockReqDetailId, Smartworks.DAL customdataAcess = null)
{
Smartworks.ColumnField[] dReqDetail = new Smartworks.ColumnField[1];
dReqDetail[0] = new Smartworks.ColumnField("@StockReqDetailId", StockReqDetailId);
if (customdataAcess != null)
{
customdataAcess.ExecuteStoredProcedure("dbo.DeleteReqDetailByDetailId", dReqDetail);
}
else
{
dataAccess.BeginTransaction();
dataAccess.ExecuteStoredProcedure("dbo.DeleteReqDetailByDetailId", dReqDetail);
dataAccess.TransCommit();
}
}
public void DeletePackingListDetailByDetailId(int PLDetailId, Smartworks.DAL customdataAcess = null)
{
Smartworks.ColumnField[] dPackingDetail = new Smartworks.ColumnField[1];
dPackingDetail[0] = new Smartworks.ColumnField("@PLDetailId", PLDetailId);
if (customdataAcess != null)
{
customdataAcess.ExecuteStoredProcedure("dbo.DeletePackingListDetailByDetailId", dPackingDetail);
}
else
{
dataAccess.BeginTransaction();
dataAccess.ExecuteStoredProcedure("dbo.DeletePackingListDetailByDetailId", dPackingDetail);
dataAccess.TransCommit();
}
}
//public void DeleteProductionLedgerByTransNoAndDetailId(string TransNo, int DetailId, Smartworks.DAL customdataAccess = null)
//{
// Smartworks.ColumnField[] dProductionLedger = new Smartworks.ColumnField[2];
// dProductionLedger[0] = new Smartworks.ColumnField("@TransNo", TransNo);
// dProductionLedger[1] = new Smartworks.ColumnField("@DetailId", DetailId);
// if (customdataAccess != null)
// {
// customdataAccess.ExecuteStoredProcedure("dbo.sp_DeleteProductionLedgerByTransNo", dProductionLedger);
// }
// else
// {
// dataAccess.BeginTransaction();
// dataAccess.ExecuteStoredProcedure("dbo.sp_DeleteProductionLedgerByTransNo", dProductionLedger);
// dataAccess.TransCommit();
// }
//}
public void DeleteProductionLedgerByTransNo(string TransNo, Smartworks.DAL customdataAccess = null)
{
Smartworks.ColumnField[] dProductionLedger = new Smartworks.ColumnField[1];
dProductionLedger[0] = new Smartworks.ColumnField("@TransNo", TransNo);
if (customdataAccess != null)
{
customdataAccess.ExecuteStoredProcedure("dbo.sp_DeleteProductionLedgerByTransNo", dProductionLedger);
}
else
{
dataAccess.BeginTransaction();
dataAccess.ExecuteStoredProcedure("dbo.sp_DeleteProductionLedgerByTransNo", dProductionLedger);
dataAccess.TransCommit();
}
}
public void Check_And_Update_SOMaster_ProcessingClosed(string SOrderNo, Smartworks.DAL customDataAcess)
{
//yeh Method is liye banaya hai k agr Sales Order Detail k all Item Processing Closed Mark hogye hain toh Sales Master ko bhi Processing Closed Mark maar do , q k bar bar search mai uska naam nh aye ga .
Smartworks.ColumnField[] SOrderProcess = new Smartworks.ColumnField[1];
SOrderProcess[0] = new Smartworks.ColumnField("@SOrderNo", SOrderNo);
if (customDataAcess != null)
{
customDataAcess.ExecuteStoredProcedure("CheckAndUpdateSO_ProcessingClosed", SOrderProcess);
}
else
{
dataAccess.ExecuteStoredProcedure("CheckAndUpdateSO_ProcessingClosed", SOrderProcess);
}
}
public void DeletePurchaseByInvoiceNo(string PurchaseInvoiceNo, Smartworks.DAL customdataAcess = null)
{
Smartworks.ColumnField[] dPurchaseMasater = new Smartworks.ColumnField[1];
dPurchaseMasater[0] = new Smartworks.ColumnField("@PurhcaseInvoiceNo", PurchaseInvoiceNo);
if (customdataAcess != null)
{
customdataAcess.ExecuteStoredProcedure("dbo.DeletePurchaseByInvoiceNo", dPurchaseMasater);
}
else
{
dataAccess.BeginTransaction();
dataAccess.ExecuteStoredProcedure("dbo.DeletePurchaseByInvoiceNo", dPurchaseMasater);
dataAccess.TransCommit();
}
}
public void DeleteVoucharDetailByMasterId(int VoucherMasterId, Smartworks.DAL customdataAccess = null)
{
Smartworks.ColumnField[] dVoucherDetail = new Smartworks.ColumnField[1];
dVoucherDetail[0] = new Smartworks.ColumnField("@VoucherMasterId", VoucherMasterId);
if (customdataAccess != null)
{
customdataAccess.ExecuteStoredProcedure("dbo.DeleteVoucharDetailByMasterId", dVoucherDetail);
}
else
{
dataAccess.BeginTransaction();
dataAccess.ExecuteStoredProcedure("dbo.DeleteVoucharDetailByMasterId", dVoucherDetail);
dataAccess.TransCommit();
}
}
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 int DeleteRequisitionMaster(int StockReqMasterId, Smartworks.DAL customdataAccess = null)
{
int Id = -1;
Smartworks.ColumnField[] dREQ = new Smartworks.ColumnField[1];
dREQ[0] = new Smartworks.ColumnField("@StockReqMasterId", StockReqMasterId);
if (customdataAccess != null)
{
Id = Convert.ToInt32(customdataAccess.ExecuteStoredProcedure("dbo.DeleteStockReqMaster", dREQ));
}
else
{
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.DeleteStockReqMaster", dREQ));
dataAccess.TransCommit();
}
return(Id);
}
public int DeleteProcessLine(int ProcessMasterId, Smartworks.DAL customdataAcess = null)
{
int Id = -1;
Smartworks.ColumnField[] dProcessline = new Smartworks.ColumnField[1];
dProcessline[0] = new Smartworks.ColumnField("@ProcessMasterId", ProcessMasterId);
if (customdataAcess != null)
{
Id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("dbo.sp_DeleteProcessLine", dProcessline));
}
else
{
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.sp_DeleteProcessLine", dProcessline));
dataAccess.TransCommit();
}
return(Id);
}
public int DeletePackingListMaster(int PackingListId, Smartworks.DAL customdataAcess = null)
{
int Id = -1;
Smartworks.ColumnField[] dPackingList = new Smartworks.ColumnField[1];
dPackingList[0] = new Smartworks.ColumnField("@PackingListId", PackingListId);
if (customdataAcess != null)
{
Id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("dbo.DeletePackingListMaster", dPackingList));
}
else
{
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.DeletePackingListMaster", dPackingList));
dataAccess.TransCommit();
}
return(Id);
}
public int DeleteRecivingPOMaster(int RPOId, Smartworks.DAL customdataAcess = null)
{
int Id = -1;
Smartworks.ColumnField[] dRPO = new Smartworks.ColumnField[1];
dRPO[0] = new Smartworks.ColumnField("@RPOId", @RPOId);
if (customdataAcess != null)
{
Id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("dbo.DeleteRecivingPOMaster", dRPO));
}
else
{
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.DeleteRecivingPOMaster", dRPO));
dataAccess.TransCommit();
}
return(Id);
}
public int InsertSOMaster(DateTime OrderDate, DateTime DueDate, string BranchCode, string CustomerCode, string CustomerRef, string EmployeeCode, int TransportId, int CompanyId, int CurrencyId,
decimal Rate, decimal TQuantity, decimal TAmount, decimal TDiscountPerc, decimal TDiscount, bool Closed, bool IsProductionClosed, string Remarks, string PONo, decimal GSTPerc, decimal GSTAmount, int AddedBy, DateTime AddedOn, string AddedIpAddr,
bool IsDispatched, Smartworks.DAL customdataAcess = null)
{
int Id = -1;
Smartworks.ColumnField[] iSalesOrder = new Smartworks.ColumnField[24];
iSalesOrder[0] = new Smartworks.ColumnField("@OrderDate", OrderDate);
iSalesOrder[1] = new Smartworks.ColumnField("@DueDate", DueDate);
iSalesOrder[2] = new Smartworks.ColumnField("@BranchCode", BranchCode);
iSalesOrder[3] = new Smartworks.ColumnField("@CustomerCode", CustomerCode);
iSalesOrder[4] = new Smartworks.ColumnField("@CustomerRef", CustomerRef);
iSalesOrder[5] = new Smartworks.ColumnField("@EmployeeCode", EmployeeCode);
iSalesOrder[6] = new Smartworks.ColumnField("@TransportId", TransportId);
iSalesOrder[7] = new Smartworks.ColumnField("@CompanyId", CompanyId);
iSalesOrder[8] = new Smartworks.ColumnField("@CurrencyId", CurrencyId);
iSalesOrder[9] = new Smartworks.ColumnField("@Rate", Rate);
iSalesOrder[10] = new Smartworks.ColumnField("@TQuantity", TQuantity);
iSalesOrder[11] = new Smartworks.ColumnField("@TAmount", TAmount);
iSalesOrder[12] = new Smartworks.ColumnField("@TDiscountPerc", TDiscountPerc);
iSalesOrder[13] = new Smartworks.ColumnField("@TDiscount", TDiscount);
iSalesOrder[14] = new Smartworks.ColumnField("@Closed", Closed);
iSalesOrder[15] = new Smartworks.ColumnField("@Remarks", Remarks);
iSalesOrder[16] = new Smartworks.ColumnField("@PONo", PONo);
iSalesOrder[17] = new Smartworks.ColumnField("@GSTPerc", GSTPerc);
iSalesOrder[18] = new Smartworks.ColumnField("@GSTAmount", GSTAmount);
iSalesOrder[19] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iSalesOrder[20] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iSalesOrder[21] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
iSalesOrder[22] = new Smartworks.ColumnField("@IsProductionClosed", IsProductionClosed);
iSalesOrder[23] = new Smartworks.ColumnField("@IsDispatched", IsDispatched);
if (customdataAcess != null)
{
Id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("dbo.InsertSOMaster", iSalesOrder));
}
else
{
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertSOMaster", iSalesOrder));
dataAccess.TransCommit();
}
return(Id);
}
public int DeleteVoucharMaster(int VoucherMasterId, Smartworks.DAL customdataAcess = null)
{
int id;
Smartworks.ColumnField[] dVoucherMaster = new Smartworks.ColumnField[1];
dVoucherMaster[0] = new Smartworks.ColumnField("@VoucherMasterId", VoucherMasterId);
if (customdataAcess != null)
{
id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("dbo.DeleteVoucherMaster", dVoucherMaster));
}
else
{
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.DeleteVoucherMaster", dVoucherMaster));
dataAccess.TransCommit();
}
return(id);
}
public int DeleteVendorLedgerByTransNo(string PurchaseInvoiceNo, Smartworks.DAL customdataAcess = null)
{
int id = 0;
Smartworks.ColumnField[] dVendorLedger = new Smartworks.ColumnField[1];
dVendorLedger[0] = new Smartworks.ColumnField("@PurchaseInvoiceNo", PurchaseInvoiceNo);
if (customdataAcess != null)
{
customdataAcess.ExecuteStoredProcedure("dbo.DeleteVendorLedgerByInvoiceNo", dVendorLedger);
}
else
{
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.DeleteVendorLedgerByInvoiceNo", dVendorLedger));
dataAccess.TransCommit();
}
return(id);
}
public bool PostVoucher(string VoucherNo, Smartworks.DAL customdataAcess = null)
{
bool result = false;
Smartworks.ColumnField[] pVoucher = new Smartworks.ColumnField[1];
pVoucher[0] = new Smartworks.ColumnField("@VoucherNumber", VoucherNo);
if (customdataAcess != null)
{
result = Convert.ToBoolean(customdataAcess.ExecuteStoredProcedure("sp_PostVoucher", pVoucher));
}
else
{
dataAccess.BeginTransaction();
result = Convert.ToBoolean(dataAccess.ExecuteStoredProcedure("sp_PostVoucher", pVoucher));
dataAccess.TransCommit();
}
return(result);
}
public int DeletePurchaseDetail(int PurchaseDetailId, Smartworks.DAL customdataAccess = null)
{
int id = -1;
Smartworks.ColumnField[] dPurchaseDetail = new Smartworks.ColumnField[1];
dPurchaseDetail[0] = new Smartworks.ColumnField("@PurchaseDetailId", PurchaseDetailId);
if (customdataAccess != null)
{
customdataAccess.ExecuteStoredProcedure("dbo.DeletePurchaseDetail", dPurchaseDetail);
}
else
{
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.DeletePurchaseDetail", dPurchaseDetail));
dataAccess.TransCommit();
}
return(id);
}
public bool DeleteSalesReturnDetail(int DetailId, Smartworks.DAL customdataAcess = null)
{
bool result = true;
Smartworks.ColumnField[] dSalesReturnDetail = new Smartworks.ColumnField[1];
dSalesReturnDetail[0] = new Smartworks.ColumnField("@SalesReturnDetailId", DetailId);
if (customdataAcess != null)
{
customdataAcess.ExecuteStoredProcedure("DeleteSaleReturnDetailByDetailId", dSalesReturnDetail);
}
else
{
dataAccess.BeginTransaction();
dataAccess.ExecuteStoredProcedure("DeleteSaleReturnDetailByDetailId", dSalesReturnDetail);
dataAccess.TransCommit();
}
return(result);
}
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 string GetSaleOrderNoBySOrderId(int SOrderId, Smartworks.DAL customdataAcess = null)
{
string SOrderNo = "";
try
{
if (customdataAcess != null)
{
SOrderNo = customdataAcess.getDataTable("Select * FROM SOrderMaster WHERE SOrderId =" + SOrderId).Rows[0]["SOrderNo"].ToString();
}
else
{
SOrderNo = dataAccess.getDataTable("Select * FROM SOrderMaster WHERE SOrderId =" + SOrderId).Rows[0]["SOrderNo"].ToString();
}
}
catch (Exception ex)
{
SOrderNo = "";
}
return(SOrderNo);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txtPath.Text))
{
MessageBox.Show("File Path does not Found.", "Error File Path", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (!Directory.Exists(txtPath.Text))
{
MessageBox.Show("File Path does not Match or Location Error.", "Location does not Match", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (Directory.Exists(txtPath.Text))
{
string FileName = DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year;
string Path = txtPath.Text + "\\" + FileName + ".bak";
if (File.Exists(Path))
{
File.Delete(Path);
}
Smartworks.DAL dataAcess = new Smartworks.DAL();
string connString = ConfigurationManager.ConnectionStrings["HSConnectionString"].ConnectionString;
//ConfigurationManager.ConnectionStrings["HSConnectionString"].
IDbConnection connection = new SqlConnection(connString);
string dbName = connection.Database;
if (!string.IsNullOrEmpty(dbName))
{
bool result = false;
var status = dataAcess.getDataTable("BACKUP DATABASE " + dbName + " TO DISK = '" + Path + "'");
if (status != null)
{
result = true;
}
if (result)
{
if (File.Exists(Path))
{
ZipFile zip = new ZipFile();
try
{
zip.AddFile(Path);
zip.Save(txtPath.Text + "\\" + FileName + ".zip");
if (File.Exists(Path))
{
File.Delete(Path);
}
clsRemember.SetSessionValue("DatabaseFilePath", txtPath.Text);
}
catch (Exception ex)
{
}
finally
{
zip.Dispose();
}
}
MessageBox.Show("Database Backup Create Sucessfully.", "Backup Created", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Error to Create Database Backup.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Connection Instance does not Found.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private bool ImportExcelData(string strFilePath)
{
bool result = true;
string sSheetName = null;
string sConnection = null;
DataTable dtTablesList = new DataTable();
OleDbCommand oleExcelCommand = new OleDbCommand();
OleDbDataReader oleExcelReader;
OleDbConnection oleExcelConnection = new OleDbConnection();
DataTable dtExcelData = new DataTable();
DataTable dtExcelDataFinal = new DataTable();
Smartworks.DAL dataAccess = new Smartworks.DAL();
string extension = Path.GetExtension(strFilePath);
switch (extension)
{
case ".xls":
//sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFilePath + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";
sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strFilePath + ";Extended Properties=Excel 12.0;";
break;
case ".xlsx":
sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strFilePath + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1;'";
break;
default:
sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFilePath + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";
break;
}
//String constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFilePath + ";Extended Properties='Excel 8.0;HDR=YES;';";
// sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFilePath + ";Extended Properties='Excel 8.0;HDR=YES;';";
oleExcelConnection = new OleDbConnection(sConnection);
try
{
oleExcelConnection.Open();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "File does not read.", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
dtTablesList = oleExcelConnection.GetSchema("Tables");
int SheetIndex = 0;
foreach (DataRow drSheet in dtTablesList.Rows)
{
SheetIndex = SheetIndex + 1;
sSheetName = drSheet["TABLE_NAME"].ToString();
if (!sSheetName.Contains("$"))
{
continue;
}
//dtTablesList.Clear();
//dtTablesList.Dispose();
if (!string.IsNullOrEmpty(sSheetName))
{
oleExcelCommand = oleExcelConnection.CreateCommand();
oleExcelCommand.CommandText = "Select * From [" + sSheetName + "]";
oleExcelCommand.CommandType = CommandType.Text;
oleExcelReader = oleExcelCommand.ExecuteReader();
dtExcelData.Load(oleExcelReader, LoadOption.PreserveChanges);
oleExcelReader.Close();
}
if (SheetIndex == dtTablesList.Rows.Count)
{
oleExcelConnection.Close();
}
if (dtExcelData.Rows.Count > 0)
{
//if (dtExcelData.Columns.Count > 10 || dtExcelData.Columns.Count < 10)
//{
// MessageBox.Show("File Format does not match. Make sure your format is as per Sample.", "Format does not match", MessageBoxButtons.OK, MessageBoxIcon.Error);
// oleExcelConnection.Close();
// result = false;
// return result;
//}
//dtExcelData.Rows.RemoveAt(0);
/* yeh New format file hai */
dtExcelData.Columns[0].ColumnName = "ItemName";
dtExcelData.Columns[1].ColumnName = "CategoryName";
if (dtExcelDataFinal.Columns.Count == 0)
{
dtExcelDataFinal = dtExcelData.Clone();
}
foreach (DataRow dtRow in dtExcelData.Rows)
{
dtExcelDataFinal.ImportRow(dtRow);
}
}
}
if (dtExcelDataFinal.Columns.Count > 0)
{
if (dtExcelDataFinal.Rows.Count > 0)
{
int index = 0;
try
{
dataAccess.BeginTransaction();
for (int i = 0; i <= dtExcelDataFinal.Rows.Count - 1; i++)
{
index = i;
DataRow drImportRow = dtExcelDataFinal.Rows[i];
if (!string.IsNullOrEmpty(drImportRow["ItemName"].ToString()))
{
Smartworks.ColumnField[] importCustomer = new Smartworks.ColumnField[2];
importCustomer[0] = new Smartworks.ColumnField("@ItemName", drImportRow["ItemName"].ToString().Trim());
importCustomer[1] = new Smartworks.ColumnField("@CategoryName", drImportRow["CategoryName"].ToString().Trim());
dataAccess.ExecuteStoredProcedure("sp_ImportProduct", importCustomer);
}
}
dataAccess.TransCommit();
// dataAccess.TransRollback();
}
catch (SqlException sqlex)
{
dataAccess.TransRollback();
dataAccess.ConnectionClose();
//Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('Error!!.. File Date not Import.');", true);
MessageBox.Show("Error!!.. File Data not Import", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
result = false;
return(result);
}
catch (Exception ex)
{
dataAccess.ConnectionClose();
//Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('Error!!.. File Date not Import.');", true);
MessageBox.Show("Error!!.. File Data not Import", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
result = false;
return(result);
}
}
}
return(result);
}
private void UpdateProduct(int ProductId, string ProductName, int ProductCatagoryId, int ProductTypeId, int ProductColorId, int ProductSizeId, int MesurementUnitId, string ProductNature, decimal CostPrice, decimal RetailPrice, decimal ProfitMargin, decimal DiscountPerc, string Barcode, string ProductImage, string ReportName, int SubCatagoryId, bool IsNotification, byte[] pictureImage, Smartworks.DAL customDataAcess)
{
manageProduct.UpdateProduct(ProductId, ProductName, ProductCatagoryId, ProductTypeId, ProductColorId, ProductSizeId, MesurementUnitId, ProductNature, CostPrice, RetailPrice, ProfitMargin, DiscountPerc, MainForm.User_Id, DateTime.Now, "", Barcode, ProductImage, ReportName, SubCatagoryId, IsNotification, pictureImage, customDataAcess);
}
public int UpdateSalesReturnMaster(int SalesReturnMasterId, 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 UpdatedBy, DateTime UpdatedOn, string UpdatedIpAddr, Smartworks.DAL customdataAcess)
{
int Id = -1;
Smartworks.ColumnField[] uSalesReturn = new Smartworks.ColumnField[20];
uSalesReturn[0] = new Smartworks.ColumnField("@SalesReturnMasterId", SalesReturnMasterId);
uSalesReturn[1] = new Smartworks.ColumnField("@SalesInvoiceNo", SalesInvoiceNo);
uSalesReturn[2] = new Smartworks.ColumnField("@Date", Date);
uSalesReturn[3] = new Smartworks.ColumnField("@BranchCode", BranchCode);
uSalesReturn[4] = new Smartworks.ColumnField("@WarehouseId", WarehouseId);
uSalesReturn[5] = new Smartworks.ColumnField("@CustomerCode", CustomerCode);
uSalesReturn[6] = new Smartworks.ColumnField("@ReturnedBy", ReturnedBy);
uSalesReturn[7] = new Smartworks.ColumnField("@ReceivedBy", ReceivedBy);
uSalesReturn[8] = new Smartworks.ColumnField("@TAmount", TAmount);
uSalesReturn[9] = new Smartworks.ColumnField("@TDiscountPerc", TDiscountPerc);
uSalesReturn[10] = new Smartworks.ColumnField("@TDiscount", TDiscount);
uSalesReturn[11] = new Smartworks.ColumnField("@FreightCharges", FreightCharges);
uSalesReturn[12] = new Smartworks.ColumnField("@GSTPercent", GSTPercent);
uSalesReturn[13] = new Smartworks.ColumnField("@GSTAmount", GSTAmount);
uSalesReturn[14] = new Smartworks.ColumnField("@Remarks", Remarks);
uSalesReturn[15] = new Smartworks.ColumnField("@VoucherNo", VoucherNo);
uSalesReturn[16] = new Smartworks.ColumnField("@Posted", Posted);
uSalesReturn[17] = new Smartworks.ColumnField("@UpdatedBy", UpdatedBy);
uSalesReturn[18] = new Smartworks.ColumnField("@UpdatedOn", UpdatedOn);
uSalesReturn[19] = new Smartworks.ColumnField("@UpdatedIpAddr", UpdatedIpAddr);
if (customdataAcess != null)
{
Id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("UpdateSalesReturnMaster", uSalesReturn));
}
else
{
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.getDataTableByStoredProcedure("UpdateSalesReturnMaster", uSalesReturn));
dataAccess.TransCommit();
}
return(Id);
}
public int InsertUpdateSalesReturnDetail(int SalesReturnDetailId, int SalesReturnMasterId, int SalesDetailId, int ProductId, string StockType, string BatchNo, int WarehouseId, decimal Quantity,
decimal Price, decimal DiscountPercent, decimal DiscountAmount, decimal GSTPercent, decimal GSTAmount, int AddedBy, DateTime AddedOn, string AddedIpAddr, string Grade, Smartworks.DAL customdataAcess = null)
{
int Id = -1;
Smartworks.ColumnField[] iuSalesReturnDetail = new Smartworks.ColumnField[17];
iuSalesReturnDetail[0] = new Smartworks.ColumnField("@SalesReturnDetailId", SalesReturnDetailId);
iuSalesReturnDetail[1] = new Smartworks.ColumnField("@SalesReturnMasterId", SalesReturnMasterId);
iuSalesReturnDetail[2] = new Smartworks.ColumnField("@SalesDetailId", SalesDetailId);
iuSalesReturnDetail[3] = new Smartworks.ColumnField("@ProductId", ProductId);
iuSalesReturnDetail[4] = new Smartworks.ColumnField("@StockType", StockType);
iuSalesReturnDetail[5] = new Smartworks.ColumnField("@BatchNo", BatchNo);
iuSalesReturnDetail[6] = new Smartworks.ColumnField("@WarehouseId", WarehouseId);
iuSalesReturnDetail[7] = new Smartworks.ColumnField("@Quantity", Quantity);
iuSalesReturnDetail[8] = new Smartworks.ColumnField("@Price", Price);
iuSalesReturnDetail[9] = new Smartworks.ColumnField("@DiscountPercent", DiscountPercent);
iuSalesReturnDetail[10] = new Smartworks.ColumnField("@DiscountAmount", DiscountAmount);
iuSalesReturnDetail[11] = new Smartworks.ColumnField("@GSTPercent", GSTPercent);
iuSalesReturnDetail[12] = new Smartworks.ColumnField("@GSTAmount", GSTAmount);
iuSalesReturnDetail[13] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iuSalesReturnDetail[14] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iuSalesReturnDetail[15] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
iuSalesReturnDetail[16] = new Smartworks.ColumnField("@Grade", Grade);
if (customdataAcess != null)
{
Id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("InsertUpdateSalesRetrunDetail", iuSalesReturnDetail));
}
else
{
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.getDataTableByStoredProcedure("InsertUpdateSalesRetrunDetail", iuSalesReturnDetail));
dataAccess.TransCommit();
}
return(Id);
}
public void UNPOSTProduction(int PMId, int AddedBy, DateTime AddedOn, string AddedIpAddr, Smartworks.DAL customedataAcess = null)
{
Smartworks.ColumnField[] pProduction = new Smartworks.ColumnField[4];
pProduction[0] = new Smartworks.ColumnField("@PMId", PMId);
pProduction[1] = new Smartworks.ColumnField("@AddedBy", AddedBy);
pProduction[2] = new Smartworks.ColumnField("@AddedOn", AddedOn);
pProduction[3] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
if (customedataAcess != null)
{
customedataAcess.ExecuteStoredProcedure("sp_UNPostProduction", pProduction);
}
else
{
dataAccess.BeginTransaction();
dataAccess.ExecuteStoredProcedure("sp_PostProduction", pProduction);
dataAccess.TransCommit();
}
}
public int InsertUpdateProductionSubDetail(int SubDetailId, int PMId, int SOrderId, int ProductId, int WarehouseId, DateTime ReceivedDate,
decimal ProcessQty, int TransferWarehouseId, Nullable <DateTime> TransferDate, int StatusId, string Remarks, Smartworks.DAL customedataAcess = null)
{
int Id = -1;
Smartworks.ColumnField[] iuProcessDetail = new Smartworks.ColumnField[11];
iuProcessDetail[0] = new Smartworks.ColumnField("@SubDetailId", SubDetailId);
iuProcessDetail[1] = new Smartworks.ColumnField("@PMId", PMId);
iuProcessDetail[2] = new Smartworks.ColumnField("@SOrderId", SOrderId);
iuProcessDetail[3] = new Smartworks.ColumnField("@ProductId", ProductId);
iuProcessDetail[4] = new Smartworks.ColumnField("@WarehouseId", WarehouseId);
iuProcessDetail[5] = new Smartworks.ColumnField("@ReceivedDate", ReceivedDate);
iuProcessDetail[6] = new Smartworks.ColumnField("@ProcessQty", ProcessQty);
iuProcessDetail[7] = new Smartworks.ColumnField("@TransferWarehouseId", TransferWarehouseId);
if (TransferDate == null)
{
iuProcessDetail[8] = new Smartworks.ColumnField("@TransferDate", DBNull.Value);
}
else
{
iuProcessDetail[8] = new Smartworks.ColumnField("@TransferDate", TransferDate);
}
iuProcessDetail[9] = new Smartworks.ColumnField("@StatusId", StatusId);
iuProcessDetail[10] = new Smartworks.ColumnField("@Remarks", Remarks);
if (customedataAcess != null)
{
Id = Convert.ToInt32(customedataAcess.ExecuteStoredProcedure("InsertUpdateProductionSubDetail", iuProcessDetail));
}
else
{
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("InsertUpdateProductionSubDetail", iuProcessDetail));
dataAccess.TransCommit();
}
return(Id);
}
