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 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);
}
private void DeletePOB()
{
if (string.IsNullOrEmpty(txtPOBId.Text))
{
return;
}
try
{
dataAcess.BeginTransaction();
manageProduct.DeleteProductOpeningBalanceMaster(ProductOpeningBalanceId, dataAcess);
dataAcess.TransCommit();
MessageBox.Show("Product Opening " + txtPOBId.Text + " is Deleted.", "Product Opening Delete Successful.", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearFeilds();
}
catch (SqlException sqlex)
{
dataAcess.TransRollback();
}
catch (Exception ex)
{
}
finally
{
dataAcess.ConnectionClose();
}
}
private void DeleteStockAdjustment()
{
if (string.IsNullOrEmpty(txtAdjustNo.Text))
{
return;
}
try
{
dataAcess.BeginTransaction();
//hum pehele ProductLedger se Clear kry gy than again insert.
manageProduct.DeleteProductLedgerByTransNo(txtAdjustNo.Text, true, dataAcess);
manageProduct.DeleteAdjustmentMaster(StockAdjusmentId, dataAcess);
dataAcess.TransCommit();
MessageBox.Show("Stock Adjustment " + txtAdjustNo.Text + " is Deleted.", "Adjustment Delete Successful.", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearFeilds();
}
catch (SqlException sqlex)
{
dataAcess.TransRollback();
}
catch (Exception ex)
{
}
finally
{
dataAcess.ConnectionClose();
}
}
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 int InsertEmployee(string EmployeeName, string FatherName, string DepartmentId, string Gender,
DateTime DOB, string NIC, string MaritalStatus, string Address, string HomePhone, string CellPhone,
string Email, DateTime HireDate, string DesignationId, string Remarks, int PayrollId, decimal Salery, bool IsMontly, int AddedBy, DateTime AddedOn,
string AddedIpAddr)
{
int id = 0;
Smartworks.ColumnField[] iEmployee = new Smartworks.ColumnField[20];
iEmployee[0] = new Smartworks.ColumnField("@EmployeeName", EmployeeName);
iEmployee[1] = new Smartworks.ColumnField("@FatherName", FatherName);
iEmployee[2] = new Smartworks.ColumnField("@DepartmentId", DepartmentId);
iEmployee[3] = new Smartworks.ColumnField("@Gender", Gender);
iEmployee[4] = new Smartworks.ColumnField("@DOB", DOB);
iEmployee[5] = new Smartworks.ColumnField("@NIC", NIC);
iEmployee[6] = new Smartworks.ColumnField("@MaritalStatus", MaritalStatus);
iEmployee[7] = new Smartworks.ColumnField("@Address", Address);
iEmployee[8] = new Smartworks.ColumnField("@HomePhone", HomePhone);
iEmployee[9] = new Smartworks.ColumnField("@CellPhone", CellPhone);
iEmployee[10] = new Smartworks.ColumnField("@Email", Email);
iEmployee[11] = new Smartworks.ColumnField("@HireDate", HireDate);
iEmployee[12] = new Smartworks.ColumnField("@DesignationId", DesignationId);
iEmployee[13] = new Smartworks.ColumnField("@Remarks", Remarks);
iEmployee[14] = new Smartworks.ColumnField("@PayrollId", PayrollId);
iEmployee[15] = new Smartworks.ColumnField("@Salery", Salery);
iEmployee[16] = new Smartworks.ColumnField("@IsMontly", IsMontly);
iEmployee[17] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iEmployee[18] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iEmployee[19] = new Smartworks.ColumnField("@AddedIpAddr", Address);
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertEmployee", iEmployee));
dataAccess.TransCommit();
return(id);
}
private void DeleteRequisition()
{
if (string.IsNullOrEmpty(txtRequisitionNo.Text))
{
return;
}
try
{
dataAcess.BeginTransaction();
manageRequisition.DeleteRequisitionMaster(StockReqMasterId, dataAcess);
dataAcess.TransCommit();
MessageBox.Show("Requisition " + txtRequisitionNo.Text + " is Deleted.", "Requisition Delete Successful.", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnClear_Click(null, null);
}
catch (SqlException sqlex)
{
dataAcess.TransRollback();
}
catch (Exception ex)
{
}
finally
{
dataAcess.ConnectionClose();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (Validation())
{
DataTable dtVoucher = null;
try
{
int CashCOAId, VendorCOAId = -1;
VendorCOAId = manageAccount.GetCOAIdByCode(txtAccCode.Text); // yeh Creadit hoga yani "C"
CashCOAId = manageAccount.GetCOAIdByCode(txtCashAcc.Text); //yeh Debit hoga yani "D"
if (VendorCOAId <= 0 || CashCOAId <= 0)
{
MessageBox.Show("Error While Save Cash Payment. Account Code or Cash Account is missing", "Account Missing", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (VendorCOAId == CashCOAId)
{
MessageBox.Show("Account Code and Cash Account should not be Same.", "Same Account Restriction", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
dataAcess.BeginTransaction();
if (dataAcess.getDBCommand().Transaction == null)
{
dataAcess.SetDBTransaction();
}
dtVoucher = VM.InsertVoucharMaster(Convert.ToDateTime(dtpVoucher.Value), "CP", "K", txtNaration.Text, Convert.ToDecimal(txtAmount.Text), Convert.ToDecimal(txtAmount.Text), MainForm.User_Id, DateTime.Now.Date, "", dataAcess);
VoucherMasterId = Convert.ToInt32(dtVoucher.Rows[0]["VoucherMasterId"]);
VM.InsertVoucherDetail(VoucherMasterId, "", "", CashCOAId, txtCashAcc.Text, "D", Convert.ToDecimal(txtAmount.Text), txtRemarks.Text, dataAcess);
VM.InsertVoucherDetail(VoucherMasterId, "", "", VendorCOAId, txtAccCode.Text, "C", Convert.ToDecimal(txtAmount.Text), txtRemarks.Text, dataAcess);
//int VendorId = Vendor.GetVendorIdByCode(txtVendorCode.Text);
//Vendor.InsertVendorLedger(VendorId, Convert.ToDateTime(dtpVoucher.Value), "", -1, 0, dtVoucher.Rows[0]["VoucherNumber"].ToString(), VoucherMasterId, Convert.ToDecimal(txtAmount.Text), dataAcess);
dataAcess.TransCommit();
MessageBox.Show("Cash Payment Record Insert Successfull", "Record Inserted.", MessageBoxButtons.OK, MessageBoxIcon.Information);
//if (VoucherMasterId > 0)
//{
// LoadVoucher(VoucherMasterId);
//}
ClearFeilds();
}
catch (SqlException sqlex)
{
dataAcess.TransRollback();
}
catch (Exception ex)
{
}
finally
{
dataAcess.ConnectionClose();
}
}
}
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);
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (Validation())
{
GenrateBarcode();
if (string.IsNullOrEmpty(txtBarcode.Text))
{
MessageBox.Show("SKU Code does not found.", "SKU Code Required", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
Image productImage = null;
byte[] pictureimage = null;
if (!IsPictureUploaded)
{
productImage = null;
}
else
{
productImage = pbitem.Image;
pictureimage = imageToByteArray(pbitem.Image);
}
try
{
dataAcess.BeginTransaction();
ProductId = InsertProduct(txtProductName.Text, (string.IsNullOrEmpty(txtCostPrice.Text) ? 0 : Convert.ToDecimal(txtCostPrice.Text)), Convert.ToInt32(cmbProductCatagory.SelectedValue), Convert.ToInt32(cmbProductType.SelectedValue),
Convert.ToInt32(cmbColor.SelectedValue), Convert.ToInt32(cmbSize.SelectedValue), Convert.ToInt32(cmbUnit.SelectedValue), cmbNature.SelectedValue.ToString(),
(string.IsNullOrEmpty(txtRetailPrice.Text) ? 0 : Convert.ToDecimal(txtRetailPrice.Text)),
(string.IsNullOrEmpty(txtProfitMargin.Text) ? 0 : Convert.ToDecimal(txtProfitMargin.Text)),
(string.IsNullOrEmpty(txtDiscPerc.Text) ? 0 : Convert.ToDecimal(txtDiscPerc.Text)),
txtBarcode.Text,
(productImage == null ? null : ImageToBase64(productImage, System.Drawing.Imaging.ImageFormat.Jpeg)), txtReportName.Text, Convert.ToInt32(cmbSubCategory.SelectedValue), chkNotification.Checked, (pictureimage == null ? null : pictureimage), dataAcess);
dataAcess.TransCommit();
MessageBox.Show("Product Insert Succesfull", "Product Insterted", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearFeilds();
if (ProductId > 0)
{
LoadProduct(ProductId);
}
}
catch (SqlException sqlex)
{
dataAcess.TransRollback();
MessageBox.Show(sqlex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
dataAcess.ConnectionClose();
}
}
}
public int InsertRole(string RoleName)
{
int intValue;
Smartworks.ColumnField[] iRoleManager = new Smartworks.ColumnField[1];
iRoleManager[0] = new Smartworks.ColumnField("@RoleName", RoleName);
dataAccess.BeginTransaction();
intValue = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertRole", iRoleManager));
dataAccess.TransCommit();
return(intValue);
}
public void UpdateSystemParameters(string PrinterGeneralReports, string PrinterForPOSSlip, string ReportFooterText, DateTime FicalYearStart, DateTime FicalYearEnd)
{
Smartworks.ColumnField[] iSystemPara = new Smartworks.ColumnField[5];
iSystemPara[0] = new Smartworks.ColumnField("@PrinterGeneralReports", PrinterGeneralReports);
iSystemPara[1] = new Smartworks.ColumnField("@PrinterForPOSSlip", PrinterForPOSSlip);
iSystemPara[2] = new Smartworks.ColumnField("@ReportFooterText", ReportFooterText);
iSystemPara[3] = new Smartworks.ColumnField("@FicalYearStart", FicalYearStart);
iSystemPara[4] = new Smartworks.ColumnField("@FicalYearEnd", FicalYearEnd);
dataAccess.BeginTransaction();
dataAccess.ExecuteStoredProcedure("dbo.UpdateSystemParameters", iSystemPara);
dataAccess.TransCommit();
}
public int InsertAssetsCatagory(string CategoryName, int AddedBy, DateTime AddedOn, string AddedIpAddr)
{
int id = 0;
Smartworks.ColumnField[] iAssetsCatagory = new Smartworks.ColumnField[4];
iAssetsCatagory[0] = new Smartworks.ColumnField("@CategoryName", CategoryName);
iAssetsCatagory[1] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iAssetsCatagory[2] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iAssetsCatagory[3] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertAssetsCategory", iAssetsCatagory));
dataAccess.TransCommit();
return(id);
}
public int InsertLastNo(string LastNo, int AddedBy, DateTime AddedOn,
string AddedIpAddr)
{
int id = 0;
Smartworks.ColumnField[] iLastNoCatagory = new Smartworks.ColumnField[4];
iLastNoCatagory[0] = new Smartworks.ColumnField("@LastNo", LastNo);
iLastNoCatagory[1] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iLastNoCatagory[2] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iLastNoCatagory[3] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertLastNo", iLastNoCatagory));
dataAccess.TransCommit();
return(id);
}
//private int InsertVoucher(DateTime Date, string VoucherType,
// string BranchCode, string POrderNo, string Narration, decimal TotalDebit, decimal TotalCredit, bool Hold,
// bool Posted, int AddedBy, DateTime AddedOn, string AddedIpAddr)
//{
// VoucherMasterId = VoucherMaster.InsertVoucharMaster(Date,VoucherType, BranchCode, POrderNo, Narration, TotalDebit, TotalCredit, Hold, Posted, AddedBy, AddedOn, AddedIpAddr);
// return VoucherMasterId;
//}
//private void UpdateVoucher(int VoucherMasterId, DateTime Date, string VoucherType,
// string BranchCode, string POrderNo, string Narration, decimal TotalDebit, decimal TotalCredit, bool Hold,
// bool Posted, int UpdatedBy, DateTime UpdatedOn, string UpdatedIpAddr)
//{
// VoucherMaster.UpdateVoucharMaster(VoucherMasterId, Date, VoucherType, BranchCode, POrderNo, Narration, TotalDebit, TotalCredit, Hold, Posted, UpdatedBy, UpdatedOn, UpdatedIpAddr);
//}
private void DeleteVoucher(int VoucherMasterId)
{
try
{
dataAcess.BeginTransaction();
manageBank.DeleteBankVoucherDetailByVoucherMasterId(VoucherMasterId, dataAcess);
VM.DeleteVoucharMaster(VoucherMasterId, dataAcess);
dataAcess.TransCommit();
MessageBox.Show("Voucher Record Delete Successfull.", "Record Deleted.", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearFeilds();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error To Delete Voucher", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (Validations())
{
try
{
int PolicyId = -1;
dataAcess.BeginTransaction();
managePolicy.InsertUpdateTimeAttendancePolicy(ref PolicyId, txtPolicyCode.Text, "-1", "-1", (string.IsNullOrEmpty(txtCasualLeave.Text) ? 0 : Convert.ToInt32(txtCasualLeave.Text)), (string.IsNullOrEmpty(txtSickLeave.Text) ? 0 : Convert.ToInt32(txtSickLeave.Text)),
(string.IsNullOrEmpty(txtHalfDayStartTime.Text) ? 0 : Convert.ToInt32(txtHalfDayStartTime.Text)), (string.IsNullOrEmpty(txtOverTimeRate.Text) ? 0 : Convert.ToInt32(txtOverTimeRate.Text)), "", 0, 0, 0,
DutyTimeON.Value, DutyTimeOFF.Value, BeginAttTime.Value, EndAttTime.Value, (string.IsNullOrEmpty(txtOffDayDutyRate.Text) ? 0 : Convert.ToInt32(txtOffDayDutyRate.Text)), (string.IsNullOrEmpty(txtGraceTime.Text) ? 0 : Convert.ToInt32(txtGraceTime.Text)),
(string.IsNullOrEmpty(txtLateAfter.Text) ? 0 : Convert.ToInt32(txtLateAfter.Text)), (string.IsNullOrEmpty(txtDeductionAfterLate.Text) ? 0 : Convert.ToInt32(txtDeductionAfterLate.Text)), dataAcess);
dataAcess.TransCommit();
MessageBox.Show("Time Attendance Policy Save Sucessfully", "Record Saved", MessageBoxButtons.OK, MessageBoxIcon.Information);
FillTimeAttendancePolicy();
}
catch (SqlException sqlex)
{
dataAcess.TransRollback();
MessageBox.Show(sqlex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
dataAcess.ConnectionClose();
}
}
}
public int InsertMenu(string menu, string parentName, int parent, bool isParent, bool isReport)
{
int Id = 0;
Smartworks.ColumnField[] iMenu = new Smartworks.ColumnField[5];
iMenu[0] = new Smartworks.ColumnField("@MenuName", menu);
iMenu[1] = new Smartworks.ColumnField("@ParentName", parentName);
iMenu[2] = new Smartworks.ColumnField("@Parent", parent);
iMenu[3] = new Smartworks.ColumnField("@IsParent", isParent);
iMenu[4] = new Smartworks.ColumnField("@IsReport", isReport);
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertMenu", iMenu));
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 int InsertCustomer(string customerName, string Address, string phoneNumber, string contactPerson, int COAId, string STRegistration, string NTN,
bool inactive, bool inPos,
int AddedBy, DateTime AddedOn, string AddedIpAddr)
{
int id = 0;
Smartworks.ColumnField[] iCustomer = new Smartworks.ColumnField[12];
iCustomer[0] = new Smartworks.ColumnField("@CustomerName", customerName);
iCustomer[1] = new Smartworks.ColumnField("@Address", Address);
iCustomer[2] = new Smartworks.ColumnField("@Phone", phoneNumber);
iCustomer[3] = new Smartworks.ColumnField("@ContactPerson", contactPerson);
iCustomer[4] = new Smartworks.ColumnField("@COAId", COAId);
iCustomer[5] = new Smartworks.ColumnField("@STRegistration", STRegistration);
iCustomer[6] = new Smartworks.ColumnField("@NTN", NTN);
iCustomer[7] = new Smartworks.ColumnField("@IsActive", inactive);
iCustomer[8] = new Smartworks.ColumnField("@IsPos", inPos);
iCustomer[9] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iCustomer[10] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iCustomer[11] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertCustomer", iCustomer));
dataAccess.TransCommit();
if (inPos == true)
{
UpdatePosCustomer(id);
}
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 InsertProductionStatus(string ProductionStatus, int AddedBy, DateTime AddedOn,
string AddedIpAddr)
{
int id = 0;
Smartworks.ColumnField[] iProductionStatus = new Smartworks.ColumnField[4];
iProductionStatus[0] = new Smartworks.ColumnField("@ProductionStatus", ProductionStatus);
iProductionStatus[1] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iProductionStatus[2] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iProductionStatus[3] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertProductionStatus", iProductionStatus));
dataAccess.TransCommit();
return(id);
}
public int InsertUserMaster(string UserName, string Password, string Name, int RoleId, bool IsActive)
{
int id;
Smartworks.ColumnField[] iUserManager = new Smartworks.ColumnField[5];
iUserManager[0] = new Smartworks.ColumnField("@UserName", UserName);
iUserManager[1] = new Smartworks.ColumnField("@Password", Encrypt(Password));
iUserManager[2] = new Smartworks.ColumnField("@Name", Name);
iUserManager[3] = new Smartworks.ColumnField("@RoleId", RoleId);
iUserManager[4] = new Smartworks.ColumnField("@IsActive", IsActive);
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertUser", iUserManager));
dataAccess.TransCommit();
return(id);
}
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);
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (Validation())
{
DataTable dtVoucher = new DataTable();
try
{
dataAcess.BeginTransaction();
if (dataAcess.getDBCommand().Transaction == null)
{
dataAcess.SetDBTransaction();
}
VoucherMasterId = Convert.ToInt32(VM.InsertVoucharMaster(Convert.ToDateTime(dtpVoucher.Value), this.VoucherType, "H", txtNaration.Text, Convert.ToDecimal(txtTotalDebit.Text), Convert.ToDecimal(txtTotalCredit.Text), MainForm.User_Id, DateTime.Now.Date, "", dataAcess).Rows[0]["VoucherMasterId"]);
foreach (DataRow dr in dsMain.Tables["VoucherDetail"].Rows)
{
VM.InsertVoucherDetail(VoucherMasterId, "", "", Convert.ToInt32(dr["COAId"]), dr["AccountCode"].ToString(), dr["FlagDC"].ToString(), Convert.ToDecimal(dr["Amount"]), dr["Remarks"].ToString(), dataAcess);
}
if (this.VoucherType == "CR" || this.VoucherType == "CP")
{
//agr Cash Receipt , ya Cash Payment hoga tog BillNo and Bill Date wala kaam kry ga warna nh.
manageBank.InsertUpdateBankVoucherDetail(BankVoucherDetailId, dtpVoucher.Value, string.Empty, string.Empty, -1, -1, 0, DateTime.Now, -1, "", ((this.VoucherType == "CR") ? "Receipt" : "Payment"), VoucherMasterId, this.VoucherType, txtBillNo.Text, dtpBillDate.Value, dataAcess);
}
dataAcess.TransCommit();
MessageBox.Show("Voucher Insert Successfull", "Record Inserted", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearFeilds();
}
catch (SqlException sqlex)
{
dataAcess.TransRollback();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
dataAcess.ConnectionClose();
}
}
}
public int InsertRolePrivilege(int roleId, int menuId, bool allowPrivilege, bool addPrivilege, bool editPrivilege, bool deletePrivilege, bool postPrivilege)
{
int Id = 0;
Smartworks.ColumnField[] iRolePrivilege = new Smartworks.ColumnField[7];
iRolePrivilege[0] = new Smartworks.ColumnField("@RoleId", roleId);
iRolePrivilege[1] = new Smartworks.ColumnField("@MenuId", menuId);
iRolePrivilege[2] = new Smartworks.ColumnField("@AllowPrivilege", allowPrivilege);
iRolePrivilege[3] = new Smartworks.ColumnField("@AddPrivilege", addPrivilege);
iRolePrivilege[4] = new Smartworks.ColumnField("@EditPrivilege", editPrivilege);
iRolePrivilege[5] = new Smartworks.ColumnField("@DeletePrivilege", deletePrivilege);
iRolePrivilege[6] = new Smartworks.ColumnField("@PostPrivilege", postPrivilege);
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertRolePrivilege", iRolePrivilege));
dataAccess.TransCommit();
return(Id);
}
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 int InsertPOMaster(DateTime OrderDate, DateTime DueDate, string BranchCode, string VendorCode, string VendorRef, string EmployeeCode, int CompanyId, int CurrencyId,
decimal Rate, decimal TAmount, decimal TDiscountPerc, decimal TDiscount, bool Closed, string Remarks, string VoucherNo, int AddedBy, DateTime AddedOn, string AddedIpAddr, Smartworks.DAL customdataAcess = null)
{
int Id = -1;
Smartworks.ColumnField[] iPurchaseOrder = new Smartworks.ColumnField[18];
iPurchaseOrder[0] = new Smartworks.ColumnField("@OrderDate", OrderDate);
iPurchaseOrder[1] = new Smartworks.ColumnField("@DueDate", DueDate);
iPurchaseOrder[2] = new Smartworks.ColumnField("@BranchCode", BranchCode);
iPurchaseOrder[3] = new Smartworks.ColumnField("@VendorCode", VendorCode);
iPurchaseOrder[4] = new Smartworks.ColumnField("@VendorRef", VendorRef);
iPurchaseOrder[5] = new Smartworks.ColumnField("@EmployeeCode", EmployeeCode);
iPurchaseOrder[6] = new Smartworks.ColumnField("@CompanyId", CompanyId);
iPurchaseOrder[7] = new Smartworks.ColumnField("@CurrencyId", CurrencyId);
iPurchaseOrder[8] = new Smartworks.ColumnField("@Rate", Rate);
iPurchaseOrder[9] = new Smartworks.ColumnField("@TAmount", TAmount);
iPurchaseOrder[10] = new Smartworks.ColumnField("@TDiscountPerc", TDiscountPerc);
iPurchaseOrder[11] = new Smartworks.ColumnField("@TDiscount", TDiscount);
iPurchaseOrder[12] = new Smartworks.ColumnField("@Closed", Closed);
iPurchaseOrder[13] = new Smartworks.ColumnField("@Remarks", Remarks);
iPurchaseOrder[14] = new Smartworks.ColumnField("@VoucherNo", VoucherNo);
iPurchaseOrder[15] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iPurchaseOrder[16] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iPurchaseOrder[17] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
if (customdataAcess != null)
{
Id = Convert.ToInt32(customdataAcess.ExecuteStoredProcedure("dbo.InsertPOMaster", iPurchaseOrder));
}
else
{
dataAccess.BeginTransaction();
Id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertPOMaster", iPurchaseOrder));
dataAccess.TransCommit();
}
return(Id);
}
public int InsertWarehouse(string Name, string Address, int Manager, string Email, string Fax, string Phone, bool IsStore, int AddedBy, DateTime AddedOn, string AddedIpAddr)
{
int id = 0;
Smartworks.ColumnField[] iWarehouse = new Smartworks.ColumnField[10];
iWarehouse[0] = new Smartworks.ColumnField("@Name", Name);
iWarehouse[1] = new Smartworks.ColumnField("@Address", Address);
iWarehouse[2] = new Smartworks.ColumnField("@Manager", Manager);
iWarehouse[3] = new Smartworks.ColumnField("@Email", Email);
iWarehouse[4] = new Smartworks.ColumnField("@Fax", Fax);
iWarehouse[5] = new Smartworks.ColumnField("@Phone", Phone);
iWarehouse[6] = new Smartworks.ColumnField("@AddedBy", AddedBy);
iWarehouse[7] = new Smartworks.ColumnField("@AddedOn", AddedOn);
iWarehouse[8] = new Smartworks.ColumnField("@AddedIpAddr", AddedIpAddr);
iWarehouse[9] = new Smartworks.ColumnField("@IsStore", IsStore);
dataAccess.BeginTransaction();
id = Convert.ToInt32(dataAccess.ExecuteStoredProcedure("dbo.InsertWarehouse", iWarehouse));
dataAccess.TransCommit();
return(id);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (Validation())
{
try
{
dataAcess.BeginTransaction();
if (dataAcess.getDBCommand().Transaction == null)
{
dataAcess.SetDBTransaction();
}
foreach (int id in DeletedIds)
{
manageProduct.DeleteFormulaConfigByConfigId(id, dataAcess);
}
foreach (DataRow dr in dsMain.Tables["FormulaConfig"].Rows)
{
if (dr.RowState != DataRowState.Deleted)
{
manageProduct.InsertUpdateFormulaConfig(Convert.ToInt32(dr["FormulaConfigId"]), Convert.ToInt32(dr["WarehouseId"]), Convert.ToInt32(dr["ProductId"]), Convert.ToInt32(dr["UnitId"]), Convert.ToInt32(dr["WarehouseSequance"]), Convert.ToInt32(dr["ProductSequance"]), dataAcess);
}
}
dataAcess.TransCommit();
MessageBox.Show("Product Formula Config Update Successfull", "Record Updated", MessageBoxButtons.OK, MessageBoxIcon.Information);
DeletedIds = new List <int>();
setupGrip();
}
catch (SqlException sqlex)
{
MessageBox.Show(sqlex.Message);
dataAcess.TransRollback();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
dataAcess.ConnectionClose();
}
}
}