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 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;
}