private void SaveAuditTrail(string strReference, string strAuditEntry, int employeeId)
{
// ACMS.Util.AuditTrail at = new ACMS.Util.AuditTrail();
// at.SaveAuditTrail(strReference,strAuditEntry,employeeId);
ACMSLogic.AuditTrail.AuditTrail auditTrail = new ACMSLogic.AuditTrail.AuditTrail();
auditTrail.SaveAuditTrail(1, strReference, strAuditEntry, employeeId);
}
private void Process_Btn_Click(object sender, System.EventArgs e)
{
//Update stock request status
if (this.txtRemarks.Text == "")
{
ACMS.Utils.UI.ShowErrorMessage(this, "Please enter reason for rejection", "Error");
}
else
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
stockRequest.RejectStockRequest(Convert.ToInt32(StockRequestNo), 2, this.txtRemarks.Text);
ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail();
audit.SaveAuditTrail(7, "Reject Stock Request Status No " + this.StockRequestNo, "Stock Request", this.employee.Id);
// Fc.StockRequestFactory srf = new Fc.StockRequestFactory();
// Hashtable htStockRequest = new Hashtable();
// htStockRequest.Add("Id",StockRequestNo);
//
// //int
// htStockRequest.Add("nStatusID",2);
//
// htStockRequest.Add("strRemarks",this.txtRemarks.Text);
//
// srf.MakeUpdateStockRequest(htStockRequest);
//
// SaveAuditTrail("Reject Stock Request Status No "+this.StockRequestNo,"Stock Request",this.employee.Id);
//
MessageBox.Show("Record Has Been Updated", "Save");
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void SaveAuditTrail(int nAuditTypeId,string strReference,string strAuditEntry,int employeeId)
{
// ACMS.Util.AuditTrail at = new ACMS.Util.AuditTrail();
// at.SaveAuditTrail(strReference,strAuditEntry,employeeId);
ACMSLogic.AuditTrail.AuditTrail auditTrail = new ACMSLogic.AuditTrail.AuditTrail();
auditTrail.SaveAuditTrail(nAuditTypeId,strReference,strAuditEntry,employeeId);
}
private void btn_Save_Click(object sender, System.EventArgs e)
{
// simpleButton2_Click(sender,e);
//if (btn_Save.Text=="Update")
canSave=true;
if(this.lkBranchTo.EditValue.ToString()=="Select Branch" |this.lkBranchTo.EditValue.ToString()=="" )
{
ACMS.Utils.UI.ShowErrorMessage(this,"Please select valid Branch Code","Error");
}
else
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
SqlConnection sqlcon = new SqlConnection(SqlHelperUtils.connectionString);
sqlcon.Open();
SqlTransaction trans = sqlcon.BeginTransaction();
if(canSave)
{
int nStockRequestNo = 0;
if(isEdit)
{
if(!stockRequest.EditStockRequest(trans,Convert.ToDateTime(this.dateEdit1.EditValue),this.lkBranchTo.EditValue.ToString(),this.employee.Id,DateTime.Today,Convert.ToInt32(StockRequestNo),this.txtRequestedBy.Text))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this,"RollBack Transaction - Update StockRequest","Error");
return;
}
}
else
{
try
{
nStockRequestNo = stockRequest.SaveStockRequest(trans,DateTime.Today,this.terminalUser.Branch.Id,this.lkBranchTo.EditValue.ToString(),0,this.employee.Id,DateTime.Today,0,this.txtRequestedBy.Text);
}
catch(Exception ex)
{
UI.ShowErrorMessage(this,ex.Message,"Error");
}
if(nStockRequestNo==0)
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this,"RollBack Transaction - Insert StockRequest ","Error");
return;
}
}
DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("strItemCode");
DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("nQuantity");
DevExpress.XtraGrid.Columns.GridColumn col3 = gridView1.Columns.ColumnByFieldName("nEntryID");
for(int i=0;i<this.gridView1.DataRowCount;i++)
{
object cellValue1 = gridView1.GetRowCellValue(i, col1);
object cellValue2 = gridView1.GetRowCellValue(i, col2);
object cellValue3 = gridView1.GetRowCellValue(i, col3);
if(cellValue1.ToString()=="" | cellValue2.ToString()=="")
{
ACMS.Utils.UI.ShowErrorMessage(this,"Please enter valid Product Code and valid quantity","Error");
canSave=false;
return;
}
else
{
if(isEdit)
{
if(!stockRequest.UpdateStockRequestEntries(trans,Convert.ToInt32(cellValue3.ToString()),Convert.ToInt32(cellValue2.ToString()),cellValue1.ToString(),this.lkBranchTo.EditValue.ToString()))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this,"RollBack Transaction - Update StockRequestEntries","Error");
return;
}
}
else
{
if(!stockRequest.SaveStockRequestEntries(trans,nStockRequestNo,cellValue1.ToString(),Convert.ToInt32(cellValue2.ToString()),this.lkBranchTo.EditValue.ToString()))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this,"RollBack Transaction - Insert StockRequestEntries","Error");
return;
}
}
}
}
ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail();
if(isEdit)
{
if(!audit.SaveAuditTrail(trans,7,"Update Stock Request No "+StockRequestNo,"Stock Request",this.employee.Id))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this,"RollBack Transaction - Insert Audit","Error");
return;
}
UI.ShowErrorMessage(this,"Record Has Been Updated", "Save");
}
else
{
if(!audit.SaveAuditTrail(trans,7,"Add New Stock Request No "+nStockRequestNo,"Stock Request",this.employee.Id))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this,"RollBack Transaction - Insert Audit","Error");
return;
}
UI.ShowErrorMessage(this,"Record Has Been Saved", "Save");
}
trans.Commit();
sqlcon.Close();
this.DialogResult = DialogResult.OK;
this.Close();
canSave=true;
}
#region nHibernate Code
// if(canSave)
// {
// //Variable Hashtable
// Hashtable htStockRequest = new Hashtable();
// //htint
// if(isEdit)
// {
// htStockRequest.Add("Id",this.StockRequestNo);
//
// htStockRequest.Add("Branch_strBranchCodeTo",this.lkBranchTo.EditValue.ToString());
// }
// else
// {
// //DateTime
// htStockRequest.Add("dtDate",DateTime.Today);
// //Add pending value
// htStockRequest.Add("nStatusID",0);//this.lkStatus.Properties.ValueMember);
// //DateTime
// htStockRequest.Add("dtLastEditDate",DateTime.Today);
//
// //string
// //htStockRequest.Add("Branch_strBranchCodeFrom",this.lkBranchTo.EditValue.ToString());
// htStockRequest.Add("Branch_strBranchCodeFrom",this.terminalUser.Branch.Id);
//
// //string
// //htStockRequest.Add("Branch_strBranchCodeTo",this.terminalUser.Branch.Id);
// htStockRequest.Add("Branch_strBranchCodeTo",this.lkBranchTo.EditValue.ToString());
//
// //int
// htStockRequest.Add("Employee_nEmployeeID",this.employee.Id);
// }
//
// //int
// //htStockRequest.Add("IBT_nIBTNo",this.lkIBT.EditValue.ToString());
//
// ArrayList stockRequestList = new ArrayList();
//
// DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("ProductStrItemCode");
// DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("NQuantity");
//
// for(int i=0;i<this.gridView1.DataRowCount;i++)
// {
//
// object cellValue1 = gridView1.GetRowCellValue(i, "ProductStrItemCode");
// object cellValue2 = gridView1.GetRowCellValue(i, col2);
// if(cellValue1.ToString()=="" | cellValue2.ToString()=="")
// {
// ACMS.Utils.UI.ShowErrorMessage(this,"Please enter valid Product Code and valid quantity","Error");
// canSave=false;
// return;
// }
// else
// {
// Hashtable htStockRequestEntries = new Hashtable();
//
// htStockRequestEntries.Add("Product_strItemCode",cellValue1.ToString());
// //htStockRequestEntries.Add("Test_strProductCode",2);
// //int
// htStockRequestEntries.Add("nQuantity",cellValue2.ToString());
//
// stockRequestList.Add(htStockRequestEntries);
// }
// }
//
// //Object In ArrayList
// htStockRequest.Add("StockRequestEntries",stockRequestList);
//
// Fc.StockRequestFactory srf = new Fc.StockRequestFactory();
//
// if(canSave)
// {
// try
// {
// if(!isEdit)
// {
// srf.MakeSaveStockRequest(htStockRequest);
// SaveAuditTrail("Add New Stock Request","Stock Request",this.employee.Id);
// MessageBox.Show("Record Has Been Saved", "Save");
// }
// else
// {
// srf.MakeUpdateStockRequest(htStockRequest);
// SaveAuditTrail("Update Stock Request","Stock Request",this.employee.Id);
// MessageBox.Show("Record Has Been Updated", "Updated");
// isEdit=false;
// }
// this.DialogResult = DialogResult.OK;
// this.Close();
// canSave=true;
// }
// catch
// {
// ACMS.Utils.UI.ShowErrorMessage(this,"Please enter valid Product Code and valid Quantity","Error");
// }
// }
//
// }
// else
// {
// ACMS.Utils.UI.ShowErrorMessage(this,"Please enter a valid quantity","Error");
// }
#endregion
}
}
private void Process_Btn_Click(object sender, System.EventArgs e)
{
//Update stock request status
if(this.txtRemarks.Text=="")
{
ACMS.Utils.UI.ShowErrorMessage(this,"Please enter reason for rejection","Error");
}
else
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
stockRequest.RejectStockRequest(Convert.ToInt32(StockRequestNo),2,this.txtRemarks.Text);
ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail();
audit.SaveAuditTrail(7,"Reject Stock Request Status No "+this.StockRequestNo,"Stock Request",this.employee.Id);
// Fc.StockRequestFactory srf = new Fc.StockRequestFactory();
// Hashtable htStockRequest = new Hashtable();
// htStockRequest.Add("Id",StockRequestNo);
//
// //int
// htStockRequest.Add("nStatusID",2);
//
// htStockRequest.Add("strRemarks",this.txtRemarks.Text);
//
// srf.MakeUpdateStockRequest(htStockRequest);
//
// SaveAuditTrail("Reject Stock Request Status No "+this.StockRequestNo,"Stock Request",this.employee.Id);
//
MessageBox.Show("Record Has Been Updated", "Save");
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void simpleButton1_Click(object sender, System.EventArgs e)
{
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
try
{
if (dr.Table.Rows.Count==0)
{
MessageBox.Show("Not allowed to Save Empty Entries","Warning");
return;
}
}
catch (Exception ex)
{
return;
}
SqlConnection sqlcon = new SqlConnection(SqlHelperUtils.connectionString);
sqlcon.Open();
SqlTransaction trans = sqlcon.BeginTransaction();
if(this.lkBranchTo.EditValue.ToString()=="Select Branch" | this.lkBranchTo.EditValue.ToString()=="")
{
ACMS.Utils.UI.ShowErrorMessage(this,"Please select valid Branch Code","Error");
}
else if(canSave)
{
ACMSLogic.InterBranchTransfer.InterBranchTransfer ibts = new ACMSLogic.InterBranchTransfer.InterBranchTransfer();
int nIBTNo = 0;
//Hashtable htIBT = new Hashtable();
//htint
if(isEdit)
{
if(!ibts.UpdateIBT(trans,DateTime.Now,this.terminalUser.Branch.Id,this.lkBranchTo.EditValue.ToString(),0,this.employee.Id,DateTime.Now,this.txtRemarks.Text,this.nIBTNo))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this,"RollBack Transaction - Update IBT","Error");
return;
}
ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail();
audit.SaveAuditTrail(trans,8,"Update IBT "+this.nIBTNo,"IBT",this.employee.Id);
}
else
{
nIBTNo = ibts.SaveIBT(trans,DateTime.Now,this.terminalUser.Branch.Id,this.lkBranchTo.EditValue.ToString(),0,this.employee.Id,DateTime.Now,this.txtRemarks.Text);
ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail();
audit.SaveAuditTrail(trans,8,"Save IBT "+this.nIBTNo,"IBT",this.employee.Id);
#region nHibernate Code
// //DateTime
// htIBT.Add("dtDate",DateTime.Now);
// //int
// //Status 0 - Pending Request
// htIBT.Add("nStatusID",0);
// //DateTime
// htIBT.Add("dtLastEditDate",DateTime.Now);
// //string
// htIBT.Add("strRemarks",this.txtRemarks.Text);
//
// //string
// htIBT.Add("Branch_strBranchCodeFrom",this.terminalUser.Branch.Id);
//
// //string
// htIBT.Add("Branch_strBranchCodeTo",this.lkBranchTo.EditValue);
//
// //int
// htIBT.Add("Employee_nEmployeeID",this.employee.Id);
#endregion
}
ArrayList ibtEntryList = new ArrayList();
ArrayList ibtProductTransferList = new ArrayList();
DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("strItemCode");
DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("nQuantity");
DevExpress.XtraGrid.Columns.GridColumn col3 = gridView1.Columns.ColumnByFieldName("nEntryID");
for(int i=0;i<this.gridView1.DataRowCount;i++)
{
object cellValue1 = gridView1.GetRowCellValue(i, col1);
object cellValue2 = gridView1.GetRowCellValue(i, col2);
object cellValue3 = null;
IBTProductTransfer ibt;
int nEntryID = 0;
string strProductCode = cellValue1.ToString();
int quantity = Convert.ToInt32(cellValue2.ToString());
if(isEdit)
{
cellValue3 = gridView1.GetRowCellValue(i, col3);
nEntryID = Convert.ToInt32(cellValue3);
ibt = new IBTProductTransfer(strProductCode,quantity,nEntryID);
}
else
{
ibt = new IBTProductTransfer(strProductCode,quantity);
}
if(ibtProductTransferList.Count==0)
{
ibtProductTransferList.Add(ibt);
}
else
{
bool duplicate=false;
for(int _i=0;_i<ibtProductTransferList.Count;_i++)
{
IBTProductTransfer _ibt = ibtProductTransferList[_i] as IBTProductTransfer;
if(strProductCode==_ibt.StrProductCode)
{
_ibt.Quantity=_ibt.Quantity+quantity;
duplicate=true;
}
}
if(!duplicate)
ibtProductTransferList.Add(ibt);
}
}
//Variable Hashtable
//bool doubleCheckCanSave=true;
if(isEdit)
{
foreach(IBTProductTransfer ibt in ibtProductTransferList)
{
if(!ibts.UpdateIBTEntries(trans,NIBTNo,ibt.StrProductCode,ibt.Quantity,this.terminalUser.Branch.Id,ibt.NEntryID))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this,"RollBack Transaction - Update IBTEntries","Error");
return;
}
}
ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail();
audit.SaveAuditTrail(trans,8,"Update IBTEntries "+NIBTNo,"IBTEntries",this.employee.Id);
UI.ShowMessage(this,"Record Has Been Updated");
}
else
{
if(nIBTNo!=0)
{
foreach(IBTProductTransfer ibt in ibtProductTransferList)
{
if(!ibts.SaveIBTEntries(trans,nIBTNo,ibt.StrProductCode,ibt.Quantity,this.terminalUser.Branch.Id))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this,"RollBack Transaction - Update StockRequestEntries","Error");
return;
}
#region nHibernate Code
// Hashtable htIBTEntries = new Hashtable();
//
// htIBTEntries.Add("strItemCode",ibt.StrProductCode);
// //int
// htIBTEntries.Add("nQuantity",ibt.Quantity);
//
// Rp.ProductRepository pr = new Rp.ProductRepository();
//
// Acms.Core.Domain.ProductInventory pi = pr.CheckQuantityAvailable(ibt.StrProductCode,this.terminalUser.Branch.Id);
// if(pi!=null)
// {
//
// if(!pi.IsValidQuantityRequest(ibt.Quantity))
// {
// doubleCheckCanSave=false;
// //return;
// }
// }
//
// ibtEntryList.Add(htIBTEntries);
#endregion
}
ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail();
audit.SaveAuditTrail(trans,8,"Save IBTEntries "+NIBTNo,"IBTEntries",this.employee.Id);
}
UI.ShowMessage(this,"Record Has Been Saved");
}
}
trans.Commit();
sqlcon.Close();
this.DialogResult = DialogResult.OK;
}
private void btn_Save_Click(object sender, System.EventArgs e)
{
// simpleButton2_Click(sender,e);
//if (btn_Save.Text=="Update")
canSave = true;
if (this.lkBranchTo.EditValue.ToString() == "Select Branch" | this.lkBranchTo.EditValue.ToString() == "")
{
ACMS.Utils.UI.ShowErrorMessage(this, "Please select valid Branch Code", "Error");
}
else
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
SqlConnection sqlcon = new SqlConnection(SqlHelperUtils.connectionString);
sqlcon.Open();
SqlTransaction trans = sqlcon.BeginTransaction();
if (canSave)
{
int nStockRequestNo = 0;
if (isEdit)
{
if (!stockRequest.EditStockRequest(trans, Convert.ToDateTime(this.dateEdit1.EditValue), this.lkBranchTo.EditValue.ToString(), this.employee.Id, DateTime.Today, Convert.ToInt32(StockRequestNo), this.txtRequestedBy.Text))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this, "RollBack Transaction - Update StockRequest", "Error");
return;
}
}
else
{
try
{
nStockRequestNo = stockRequest.SaveStockRequest(trans, DateTime.Today, this.terminalUser.Branch.Id, this.lkBranchTo.EditValue.ToString(), 0, this.employee.Id, DateTime.Today, 0, this.txtRequestedBy.Text);
}
catch (Exception ex)
{
UI.ShowErrorMessage(this, ex.Message, "Error");
}
if (nStockRequestNo == 0)
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this, "RollBack Transaction - Insert StockRequest ", "Error");
return;
}
}
DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("strItemCode");
DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("nQuantity");
DevExpress.XtraGrid.Columns.GridColumn col3 = gridView1.Columns.ColumnByFieldName("nEntryID");
for (int i = 0; i < this.gridView1.DataRowCount; i++)
{
object cellValue1 = gridView1.GetRowCellValue(i, col1);
object cellValue2 = gridView1.GetRowCellValue(i, col2);
object cellValue3 = gridView1.GetRowCellValue(i, col3);
if (cellValue1.ToString() == "" | cellValue2.ToString() == "")
{
ACMS.Utils.UI.ShowErrorMessage(this, "Please enter valid Product Code and valid quantity", "Error");
canSave = false;
return;
}
else
{
if (isEdit)
{
if (!stockRequest.UpdateStockRequestEntries(trans, Convert.ToInt32(cellValue3.ToString()), Convert.ToInt32(cellValue2.ToString()), cellValue1.ToString(), this.lkBranchTo.EditValue.ToString()))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this, "RollBack Transaction - Update StockRequestEntries", "Error");
return;
}
}
else
{
if (!stockRequest.SaveStockRequestEntries(trans, nStockRequestNo, cellValue1.ToString(), Convert.ToInt32(cellValue2.ToString()), this.lkBranchTo.EditValue.ToString()))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this, "RollBack Transaction - Insert StockRequestEntries", "Error");
return;
}
}
}
}
ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail();
if (isEdit)
{
if (!audit.SaveAuditTrail(trans, 7, "Update Stock Request No " + StockRequestNo, "Stock Request", this.employee.Id))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this, "RollBack Transaction - Insert Audit", "Error");
return;
}
UI.ShowErrorMessage(this, "Record Has Been Updated", "Save");
}
else
{
if (!audit.SaveAuditTrail(trans, 7, "Add New Stock Request No " + nStockRequestNo, "Stock Request", this.employee.Id))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this, "RollBack Transaction - Insert Audit", "Error");
return;
}
UI.ShowErrorMessage(this, "Record Has Been Saved", "Save");
}
trans.Commit();
sqlcon.Close();
this.DialogResult = DialogResult.OK;
this.Close();
canSave = true;
}
#region nHibernate Code
// if(canSave)
// {
// //Variable Hashtable
// Hashtable htStockRequest = new Hashtable();
// //htint
// if(isEdit)
// {
// htStockRequest.Add("Id",this.StockRequestNo);
//
// htStockRequest.Add("Branch_strBranchCodeTo",this.lkBranchTo.EditValue.ToString());
// }
// else
// {
// //DateTime
// htStockRequest.Add("dtDate",DateTime.Today);
// //Add pending value
// htStockRequest.Add("nStatusID",0);//this.lkStatus.Properties.ValueMember);
// //DateTime
// htStockRequest.Add("dtLastEditDate",DateTime.Today);
//
// //string
// //htStockRequest.Add("Branch_strBranchCodeFrom",this.lkBranchTo.EditValue.ToString());
// htStockRequest.Add("Branch_strBranchCodeFrom",this.terminalUser.Branch.Id);
//
// //string
// //htStockRequest.Add("Branch_strBranchCodeTo",this.terminalUser.Branch.Id);
// htStockRequest.Add("Branch_strBranchCodeTo",this.lkBranchTo.EditValue.ToString());
//
// //int
// htStockRequest.Add("Employee_nEmployeeID",this.employee.Id);
// }
//
// //int
// //htStockRequest.Add("IBT_nIBTNo",this.lkIBT.EditValue.ToString());
//
// ArrayList stockRequestList = new ArrayList();
//
// DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("ProductStrItemCode");
// DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("NQuantity");
//
// for(int i=0;i<this.gridView1.DataRowCount;i++)
// {
//
// object cellValue1 = gridView1.GetRowCellValue(i, "ProductStrItemCode");
// object cellValue2 = gridView1.GetRowCellValue(i, col2);
// if(cellValue1.ToString()=="" | cellValue2.ToString()=="")
// {
// ACMS.Utils.UI.ShowErrorMessage(this,"Please enter valid Product Code and valid quantity","Error");
// canSave=false;
// return;
// }
// else
// {
// Hashtable htStockRequestEntries = new Hashtable();
//
// htStockRequestEntries.Add("Product_strItemCode",cellValue1.ToString());
// //htStockRequestEntries.Add("Test_strProductCode",2);
// //int
// htStockRequestEntries.Add("nQuantity",cellValue2.ToString());
//
// stockRequestList.Add(htStockRequestEntries);
// }
// }
//
// //Object In ArrayList
// htStockRequest.Add("StockRequestEntries",stockRequestList);
//
// Fc.StockRequestFactory srf = new Fc.StockRequestFactory();
//
// if(canSave)
// {
// try
// {
// if(!isEdit)
// {
// srf.MakeSaveStockRequest(htStockRequest);
// SaveAuditTrail("Add New Stock Request","Stock Request",this.employee.Id);
// MessageBox.Show("Record Has Been Saved", "Save");
// }
// else
// {
// srf.MakeUpdateStockRequest(htStockRequest);
// SaveAuditTrail("Update Stock Request","Stock Request",this.employee.Id);
// MessageBox.Show("Record Has Been Updated", "Updated");
// isEdit=false;
// }
// this.DialogResult = DialogResult.OK;
// this.Close();
// canSave=true;
// }
// catch
// {
// ACMS.Utils.UI.ShowErrorMessage(this,"Please enter valid Product Code and valid Quantity","Error");
// }
// }
//
// }
// else
// {
// ACMS.Utils.UI.ShowErrorMessage(this,"Please enter a valid quantity","Error");
// }
#endregion
}
}
private void Process_Btn_Click(object sender, System.EventArgs e)
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
SqlConnection sqlcon = new SqlConnection(SqlHelperUtils.connectionString);
sqlcon.Open();
SqlTransaction trans = sqlcon.BeginTransaction();
//string strBranchCodeFrom=this.terminalUser.Branch.Id;
//string strBranchCodeTo=this._strBranchCodeTo;
int IBTNo = stockRequest.ProcessStockRequest(trans, DateTime.Now, 0, DateTime.Now, this.txtRemarks.Text, this.terminalUser.Branch.Id, this._strBranchCodeFrom, this.employee.Id);
DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("strItemCode");
DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("nQuantity");
DevExpress.XtraGrid.Columns.GridColumn col3 = gridView1.Columns.ColumnByFieldName("nEntryID");
for (int i = 0; i < this.gridView1.DataRowCount; i++)
{
object cellValue1 = gridView1.GetRowCellValue(i, col1);
object cellValue2 = gridView1.GetRowCellValue(i, col2);
object cellValue3 = gridView1.GetRowCellValue(i, col3);
if (!stockRequest.ProcessStockRequestEntries(trans, cellValue1.ToString(), Convert.ToInt32(cellValue2.ToString()), IBTNo, this.terminalUser.Branch.Id, Convert.ToInt32(cellValue3.ToString())))
{
int rowNumber = i + 1;
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this, "RollBack Transaction - Process StockRequest :: Invalid Quantity For Product = " + cellValue1.ToString(), "Error");
return;
}
}
if (!stockRequest.UpdateStockRequestIBTNo(trans, IBTNo, Convert.ToInt32(this.StockRequestNo)))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this, "RollBack Transaction - Update StockRequest", "Error");
return;
}
ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail();
audit.SaveAuditTrail(trans, 7, "Save Process IBT No " + IBTNo, "IBT", this.employee.Id);
audit.SaveAuditTrail(trans, 7, "Update Stock Request Status No " + this.StockRequestNo, "IBT", this.employee.Id);
trans.Commit();
sqlcon.Close();
MessageBox.Show("Record Has Been Saved", "Save");
this.DialogResult = DialogResult.OK;
#region nHibernate Code
// //Variable Hashtable
// Hashtable htIBT = new Hashtable();
// //htint
// //htIBT.Add("Id","");
// //DateTime
// htIBT.Add("dtDate",DateTime.Now);
// //int
// //Status 0 - Pending Request
// htIBT.Add("nStatusID",0);
// //DateTime
// htIBT.Add("dtLastEditDate",DateTime.Now);
// //string
// htIBT.Add("strRemarks",this.txtRemarks.Text);
//
// //string
// htIBT.Add("Branch_strBranchCodeFrom",this.terminalUser.Branch.Id);
//
// //string
// htIBT.Add("Branch_strBranchCodeTo",sr.BranchFrom.Id);
//
// //int
// htIBT.Add("Employee_nEmployeeID",this.employee.Id);
//
// ArrayList ibtEntryList = new ArrayList();
//
// DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("ProductStrItemCode");
// DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("NQuantity");
//
// for(int i=0;i<this.gridView1.DataRowCount;i++)
// {
//
// object cellValue1 = gridView1.GetRowCellValue(i, "ProductStrItemCode");
// object cellValue2 = gridView1.GetRowCellValue(i, col2);
// //Variable Hashtable
// Hashtable htIBTEntries = new Hashtable();
// //string
// htIBTEntries.Add("strItemCode",cellValue1.ToString());
// //int
// htIBTEntries.Add("nQuantity",cellValue2.ToString());
//
// ibtEntryList.Add(htIBTEntries);
//
// //Need to refactoring using Service Layer later
// Rp.ProductRepository pr = new Rp.ProductRepository();
// pr.UpdateProductInventoryQuantity(cellValue1.ToString(),this.terminalUser.Branch.Id,"VW",Convert.ToInt32(cellValue2.ToString()),0);
//
// }
//
// htIBT.Add("IBTEntries",ibtEntryList);
//
// //Save IBT and IBTEntries
// Fc.IBTFactory ifactory = new Fc.IBTFactory();
// ifactory.MakeSaveIBT(htIBT);
//
// //Update stock request status
// Fc.StockRequestFactory srf = new Fc.StockRequestFactory();
// Hashtable htStockRequest = new Hashtable();
// htStockRequest.Add("Id",StockRequestNo);
//
// //int
// htStockRequest.Add("nStatusID",1);
//
// htStockRequest.Add("IBT_nIBTNo",Fc.IBTFactory.GetIBT.Id);
//
// srf.MakeUpdateStockRequest(htStockRequest);
//
// //Update ProductInventory for Virtual Warehouse
//
//
//
#endregion
}
private void Process_Btn_Click(object sender, System.EventArgs e)
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
SqlConnection sqlcon = new SqlConnection(SqlHelperUtils.connectionString);
sqlcon.Open();
SqlTransaction trans = sqlcon.BeginTransaction();
//string strBranchCodeFrom=this.terminalUser.Branch.Id;
//string strBranchCodeTo=this._strBranchCodeTo;
int IBTNo = stockRequest.ProcessStockRequest(trans,DateTime.Now,0,DateTime.Now,this.txtRemarks.Text,this.terminalUser.Branch.Id,this._strBranchCodeFrom,this.employee.Id);
DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("strItemCode");
DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("nQuantity");
DevExpress.XtraGrid.Columns.GridColumn col3 = gridView1.Columns.ColumnByFieldName("nEntryID");
for(int i=0;i<this.gridView1.DataRowCount;i++)
{
object cellValue1 = gridView1.GetRowCellValue(i, col1);
object cellValue2 = gridView1.GetRowCellValue(i, col2);
object cellValue3 = gridView1.GetRowCellValue(i, col3);
if(!stockRequest.ProcessStockRequestEntries(trans,cellValue1.ToString(),Convert.ToInt32(cellValue2.ToString()),IBTNo,this.terminalUser.Branch.Id,Convert.ToInt32(cellValue3.ToString())))
{
int rowNumber =i+1;
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this,"RollBack Transaction - Process StockRequest :: Invalid Quantity For Product = "+cellValue1.ToString(),"Error");
return;
}
}
if(!stockRequest.UpdateStockRequestIBTNo(trans,IBTNo,Convert.ToInt32(this.StockRequestNo)))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this,"RollBack Transaction - Update StockRequest","Error");
return;
}
ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail();
audit.SaveAuditTrail(trans,7,"Save Process IBT No "+IBTNo,"IBT",this.employee.Id);
audit.SaveAuditTrail(trans,7,"Update Stock Request Status No "+this.StockRequestNo,"IBT",this.employee.Id);
trans.Commit();
sqlcon.Close();
MessageBox.Show("Record Has Been Saved", "Save");
this.DialogResult = DialogResult.OK;
#region nHibernate Code
// //Variable Hashtable
// Hashtable htIBT = new Hashtable();
// //htint
// //htIBT.Add("Id","");
// //DateTime
// htIBT.Add("dtDate",DateTime.Now);
// //int
// //Status 0 - Pending Request
// htIBT.Add("nStatusID",0);
// //DateTime
// htIBT.Add("dtLastEditDate",DateTime.Now);
// //string
// htIBT.Add("strRemarks",this.txtRemarks.Text);
//
// //string
// htIBT.Add("Branch_strBranchCodeFrom",this.terminalUser.Branch.Id);
//
// //string
// htIBT.Add("Branch_strBranchCodeTo",sr.BranchFrom.Id);
//
// //int
// htIBT.Add("Employee_nEmployeeID",this.employee.Id);
//
// ArrayList ibtEntryList = new ArrayList();
//
// DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("ProductStrItemCode");
// DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("NQuantity");
//
// for(int i=0;i<this.gridView1.DataRowCount;i++)
// {
//
// object cellValue1 = gridView1.GetRowCellValue(i, "ProductStrItemCode");
// object cellValue2 = gridView1.GetRowCellValue(i, col2);
// //Variable Hashtable
// Hashtable htIBTEntries = new Hashtable();
// //string
// htIBTEntries.Add("strItemCode",cellValue1.ToString());
// //int
// htIBTEntries.Add("nQuantity",cellValue2.ToString());
//
// ibtEntryList.Add(htIBTEntries);
//
// //Need to refactoring using Service Layer later
// Rp.ProductRepository pr = new Rp.ProductRepository();
// pr.UpdateProductInventoryQuantity(cellValue1.ToString(),this.terminalUser.Branch.Id,"VW",Convert.ToInt32(cellValue2.ToString()),0);
//
// }
//
// htIBT.Add("IBTEntries",ibtEntryList);
//
// //Save IBT and IBTEntries
// Fc.IBTFactory ifactory = new Fc.IBTFactory();
// ifactory.MakeSaveIBT(htIBT);
//
// //Update stock request status
// Fc.StockRequestFactory srf = new Fc.StockRequestFactory();
// Hashtable htStockRequest = new Hashtable();
// htStockRequest.Add("Id",StockRequestNo);
//
// //int
// htStockRequest.Add("nStatusID",1);
//
// htStockRequest.Add("IBT_nIBTNo",Fc.IBTFactory.GetIBT.Id);
//
// srf.MakeUpdateStockRequest(htStockRequest);
//
// //Update ProductInventory for Virtual Warehouse
//
//
//
#endregion
}
private void simpleButton1_Click(object sender, System.EventArgs e)
{
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
try
{
if (dr.Table.Rows.Count == 0)
{
MessageBox.Show("Not allowed to Save Empty Entries", "Warning");
return;
}
}
catch (Exception ex)
{
return;
}
SqlConnection sqlcon = new SqlConnection(SqlHelperUtils.connectionString);
sqlcon.Open();
SqlTransaction trans = sqlcon.BeginTransaction();
if (this.lkBranchTo.EditValue.ToString() == "Select Branch" | this.lkBranchTo.EditValue.ToString() == "")
{
ACMS.Utils.UI.ShowErrorMessage(this, "Please select valid Branch Code", "Error");
}
else if (canSave)
{
ACMSLogic.InterBranchTransfer.InterBranchTransfer ibts = new ACMSLogic.InterBranchTransfer.InterBranchTransfer();
int nIBTNo = 0;
//Hashtable htIBT = new Hashtable();
//htint
if (isEdit)
{
if (!ibts.UpdateIBT(trans, DateTime.Now, this.terminalUser.Branch.Id, this.lkBranchTo.EditValue.ToString(), 0, this.employee.Id, DateTime.Now, this.txtRemarks.Text, this.nIBTNo))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this, "RollBack Transaction - Update IBT", "Error");
return;
}
ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail();
audit.SaveAuditTrail(trans, 8, "Update IBT " + this.nIBTNo, "IBT", this.employee.Id);
}
else
{
nIBTNo = ibts.SaveIBT(trans, DateTime.Now, this.terminalUser.Branch.Id, this.lkBranchTo.EditValue.ToString(), 0, this.employee.Id, DateTime.Now, this.txtRemarks.Text);
ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail();
audit.SaveAuditTrail(trans, 8, "Save IBT " + this.nIBTNo, "IBT", this.employee.Id);
#region nHibernate Code
// //DateTime
// htIBT.Add("dtDate",DateTime.Now);
// //int
// //Status 0 - Pending Request
// htIBT.Add("nStatusID",0);
// //DateTime
// htIBT.Add("dtLastEditDate",DateTime.Now);
// //string
// htIBT.Add("strRemarks",this.txtRemarks.Text);
//
// //string
// htIBT.Add("Branch_strBranchCodeFrom",this.terminalUser.Branch.Id);
//
// //string
// htIBT.Add("Branch_strBranchCodeTo",this.lkBranchTo.EditValue);
//
// //int
// htIBT.Add("Employee_nEmployeeID",this.employee.Id);
#endregion
}
ArrayList ibtEntryList = new ArrayList();
ArrayList ibtProductTransferList = new ArrayList();
DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("strItemCode");
DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("nQuantity");
DevExpress.XtraGrid.Columns.GridColumn col3 = gridView1.Columns.ColumnByFieldName("nEntryID");
for (int i = 0; i < this.gridView1.DataRowCount; i++)
{
object cellValue1 = gridView1.GetRowCellValue(i, col1);
object cellValue2 = gridView1.GetRowCellValue(i, col2);
object cellValue3 = null;
IBTProductTransfer ibt;
int nEntryID = 0;
string strProductCode = cellValue1.ToString();
int quantity = Convert.ToInt32(cellValue2.ToString());
if (isEdit)
{
cellValue3 = gridView1.GetRowCellValue(i, col3);
nEntryID = Convert.ToInt32(cellValue3);
ibt = new IBTProductTransfer(strProductCode, quantity, nEntryID);
}
else
{
ibt = new IBTProductTransfer(strProductCode, quantity);
}
if (ibtProductTransferList.Count == 0)
{
ibtProductTransferList.Add(ibt);
}
else
{
bool duplicate = false;
for (int _i = 0; _i < ibtProductTransferList.Count; _i++)
{
IBTProductTransfer _ibt = ibtProductTransferList[_i] as IBTProductTransfer;
if (strProductCode == _ibt.StrProductCode)
{
_ibt.Quantity = _ibt.Quantity + quantity;
duplicate = true;
}
}
if (!duplicate)
{
ibtProductTransferList.Add(ibt);
}
}
}
//Variable Hashtable
//bool doubleCheckCanSave=true;
if (isEdit)
{
foreach (IBTProductTransfer ibt in ibtProductTransferList)
{
if (!ibts.UpdateIBTEntries(trans, NIBTNo, ibt.StrProductCode, ibt.Quantity, this.terminalUser.Branch.Id, ibt.NEntryID))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this, "RollBack Transaction - Update IBTEntries", "Error");
return;
}
}
ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail();
audit.SaveAuditTrail(trans, 8, "Update IBTEntries " + NIBTNo, "IBTEntries", this.employee.Id);
UI.ShowMessage(this, "Record Has Been Updated");
}
else
{
if (nIBTNo != 0)
{
foreach (IBTProductTransfer ibt in ibtProductTransferList)
{
if (!ibts.SaveIBTEntries(trans, nIBTNo, ibt.StrProductCode, ibt.Quantity, this.terminalUser.Branch.Id))
{
trans.Rollback();
sqlcon.Close();
UI.ShowErrorMessage(this, "RollBack Transaction - Update StockRequestEntries", "Error");
return;
}
#region nHibernate Code
// Hashtable htIBTEntries = new Hashtable();
//
// htIBTEntries.Add("strItemCode",ibt.StrProductCode);
// //int
// htIBTEntries.Add("nQuantity",ibt.Quantity);
//
// Rp.ProductRepository pr = new Rp.ProductRepository();
//
// Acms.Core.Domain.ProductInventory pi = pr.CheckQuantityAvailable(ibt.StrProductCode,this.terminalUser.Branch.Id);
// if(pi!=null)
// {
//
// if(!pi.IsValidQuantityRequest(ibt.Quantity))
// {
// doubleCheckCanSave=false;
// //return;
// }
// }
//
// ibtEntryList.Add(htIBTEntries);
#endregion
}
ACMSLogic.AuditTrail.AuditTrail audit = new ACMSLogic.AuditTrail.AuditTrail();
audit.SaveAuditTrail(trans, 8, "Save IBTEntries " + NIBTNo, "IBTEntries", this.employee.Id);
}
UI.ShowMessage(this, "Record Has Been Saved");
}
}
trans.Commit();
sqlcon.Close();
this.DialogResult = DialogResult.OK;
}
