private void LoadProductList()
{
this.repositoryItemLookUpEdit1.Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] {
new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strItemCode", "Product Code", 20, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None)
});
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
this.repositoryItemLookUpEdit1.DataSource = stockRequest.GetProductByBranch(this.terminalUser.Branch.Id); //pr.GetProductByBranch(this.lkBranchTo.EditValue.ToString());
this.repositoryItemLookUpEdit1.DisplayMember = "strItemCode";
this.repositoryItemLookUpEdit1.ValueMember = "strItemCode";
this.repositoryItemLookUpEdit1.NullText = "Select Product";
LookUpColumnInfoCollection col2 = repositoryItemLookUpEdit1.Columns;
//a column to display values of the ProductID field
//a column to display values of the ProductName field
//col2.Add(new LookUpColumnInfo("Id","Product Code",20));
col2.Add(new LookUpColumnInfo("strBrand", "Brand", 50));
col2.Add(new LookUpColumnInfo("strDescription", "Description", 50));
col2.Add(new LookUpColumnInfo("strStyle", "Style", 50));
col2.Add(new LookUpColumnInfo("strColor", "Color", 50));
col2.Add(new LookUpColumnInfo("strSize", "Size", 50));
col2.Add(new LookUpColumnInfo("nQuantity", "Quantity", 50));
lkBranchTo.Properties.AutoSearchColumnIndex = 0;
repositoryItemLookUpEdit1.BestFit();
repositoryItemLookUpEdit1.PopupWidth = 600;
}
public void LoadStockRequestDetail_Edit()
{
// Rp.StockRequestRepository srp = new Rp.StockRequestRepository();
// Acms.Core.Domain.StockRequest sr = srp.GetStockRequestById(Convert.ToInt32(this.StockRequestNo));
// this.sr=sr;
//
// this.txtBranchFrom.Text = sr.BranchFrom.Id;
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
DataTable dt = stockRequest.GetStockRequestById(Convert.ToInt32(this.StockRequestNo));
if (dt != null)
{
this.GetStockRequestDetail();
this.dateEdit1.EditValue = Convert.ToDateTime(dt.Rows[0]["dtDate"].ToString()).ToShortDateString();
this.txtBranchFrom.Text = dt.Rows[0]["strBranchCodeTo"].ToString();
this.txtStockRequestNo.Enabled = false;
this.txtBranchFrom.Enabled = false;
}
GetStockRequestDetail();
}
private void CheckAvailableQuantity(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e)
{
if (!isEdit)
{
if (CheckDuplicate())
{
DataRow row = this.gridView1.GetDataRow(gridView1.FocusedRowHandle);
if (row["strItemCode"].ToString().Length > 0 && row["strItemCode"].ToString() != "Select Product")
{
string strProductCode = row["strItemCode"].ToString();
int quantityRequest = Convert.ToInt32(row["nQuantity"].ToString());
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
if (!stockRequest.GetAvailableQuantity(strProductCode, this.lkBranchTo.EditValue.ToString(), quantityRequest))
{
UI.ShowErrorMessage(this, "Quantity request exceeded Balance", "Error");
this.canSave = false;
this.canAdd = false;
inValidQuantityRow = gridView1.FocusedRowHandle;
}
else
{
this.canSave = true;
this.canAdd = true;
return;
}
}
}
}
this.canSave = false;
}
private void lk_Product_Init()
{
//DataSet _ds = new DataSet();
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
//string strSQL = "select * from tblproduct";
//SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
//_ds.Tables[0];
DataTable dt = stockRequest.GetProductByBranch(this.lkBranchTo.EditValue.ToString()); //pr.GetProductByBranch(this.lkBranchTo.EditValue.ToString());
lk_Product.BestFit();
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[6];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strItemCode", "Item Code", 50, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription", "Description", 50, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
col[2] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strStyle", "Style", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
col[3] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strColor", "Color", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
col[4] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strSize", "Size", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
col[5] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nQuantity", "Quantity", 10, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
try
{
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lk_Product, dt, col, "strItemCode", "strItemCode", "Item Code");
}
catch (Exception ex)
{
return;
}
}
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 BindPage()
{
this.dateEdit1.Properties.Enabled = false;
this.dateEdit1.EditValue = DateTime.Today.ToShortDateString();
//Rp.StockRequestRepository srr = new Rp.StockRequestRepository();
//IList listBranchTo = srr.GetListByDomainAndExcludeById(typeof(Branch),this.terminalUser.Branch.Id);
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
this.lkBranchTo.Properties.DataSource = stockRequest.GetListByDomainAndExcludeById(this.terminalUser.Branch.Id);
//this.lkBranchTo.Properties.DataSource = listBranchTo;
//this.lkBranchTo.Properties.ValueMember = "Id";
//this.lkBranchTo.Properties.DisplayMember = "StrBranchName";
this.lkBranchTo.Properties.ValueMember = "strBranchCode";
this.lkBranchTo.Properties.DisplayMember = "strBranchName";
this.lkBranchTo.EditValue = "Select Branch";
this.lkBranchTo.Text = "Select Branch";
//add two columns in the dropdown
LookUpColumnInfoCollection coll = lkBranchTo.Properties.Columns;
//a column to display values of the ProductID field
// coll.Add(new LookUpColumnInfo("Id","Branch Code",2));
// //a column to display values of the ProductName field
// coll.Add(new LookUpColumnInfo("StrBranchName","Branch Name",50));
coll.Add(new LookUpColumnInfo("strBranchCode", "Branch Code", 2));
//a column to display values of the ProductName field
coll.Add(new LookUpColumnInfo("strBranchName", "Branch Name", 50));
//set column widths according to their contents
lkBranchTo.Properties.BestFit();
//specify the total dropdown width
lkBranchTo.Properties.PopupWidth = 300;
//enable auto completion search mode
//lkBranchTo.Properties.SearchMode = SearchMode.AutoComplete;
//the column against which to perform the search
lkBranchTo.Properties.AutoSearchColumnIndex = 0;
if (this.gridView1.DataRowCount == 0)
{
DataRow dr = dt.NewRow();
dr["strItemCode"] = "Select Product";
dr["nQuantity"] = "0";
dt.Rows.Add(dr);
this.gridControl1.DataSource = dt;
}
}
private void GetStockRequestDetail()
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
DataTable dt = stockRequest.GetStockRequestEntriesById(Convert.ToInt32(this.StockRequestNo));
if (dt != null)
{
this.gridControl1.DataSource = dt;
}
}
private void GetStockRequestDetail()
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
DataTable dt = stockRequest.GetStockRequestEntriesById(Convert.ToInt32(this.StockRequestNo));
if (dt != null)
{
this.gridControl1.DataSource = dt;
this.gridView1.Columns[0].OptionsColumn.AllowEdit = false;
}
this.simpleButton4.Visible = false;
}
public void LoadStockRequestEdit()
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
DataTable dt = stockRequest.GetStockRequestById(Convert.ToInt32(this.StockRequestNo));
if (dt != null)
{
this.GetStockRequestDetail();
this.dateEdit1.EditValue = Convert.ToDateTime(dt.Rows[0]["dtDate"].ToString()).ToShortDateString();
this.lkBranchTo.EditValue = dt.Rows[0]["strBranchCodeTo"].ToString();
this.txtRequestedBy.Text = dt.Rows[0]["strRemarks"].ToString();
}
this.btn_Save.Text = "Update";
this.btn_Add.Text = "Cancel";
this.btn_Add.Width = 75;
this.simpleButton3.Visible = false;
//Rp.StockRequestRepository srp = new Rp.StockRequestRepository();
//Acms.Core.Domain.StockRequest sr = srp.GetStockRequestById(Convert.ToInt32(this.StockRequestNo));
}
private void CheckAvailableQuantity(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e)
{
if (!isEdit)
{
DataRow row = this.gridView1.GetDataRow(gridView1.FocusedRowHandle);
if (row["strItemCode"] != null)
{
if (row["strItemCode"].ToString() != "Select Product")
{
string strProductCode = row["strItemCode"].ToString();
int quantityRequest = Convert.ToInt32(row["nQuantity"].ToString());
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
if (!stockRequest.GetAvailableQuantity(strProductCode, this.terminalUser.Branch.Id, quantityRequest))
{
UI.ShowErrorMessage(this, "Invalid Operation. Please change valid product quantity", "Error");
this.canSave = false;
this.canAdd = false;
inValidQuantityRow = gridView1.FocusedRowHandle;
}
else
{
this.canSave = true;
this.canAdd = true;
}
}
else
{
this.canSave = false;
}
}
else
{
this.canSave = false;
}
}
}
private void BindPage()
{
this.dateEdit1.Text = DateTime.Today.ToShortDateString();
//Rp.StockRequestRepository srr = new Rp.StockRequestRepository();
//IList listBranchTo = srr.GetListByDomainAndExcludeById(typeof(Branch),this.terminalUser.Branch.Id);
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
this.lkBranchTo.Properties.DataSource = stockRequest.GetListByDomainAndExcludeById(this.terminalUser.Branch.Id);
this.lkBranchTo.Properties.ValueMember = "strBranchCode";
this.lkBranchTo.Properties.DisplayMember = "strBranchName";
this.lkBranchTo.EditValue="Select Branch";
this.lkBranchTo.Text="Select Branch";
//add two columns in the dropdown
LookUpColumnInfoCollection coll = lkBranchTo.Properties.Columns;
//a column to display values of the ProductID field
coll.Add(new LookUpColumnInfo("strBranchCode","Branch Code",2));
//a column to display values of the ProductName field
coll.Add(new LookUpColumnInfo("strBranchName","Branch Name",50));
//set column widths according to their contents
lkBranchTo.Properties.BestFit();
//specify the total dropdown width
lkBranchTo.Properties.PopupWidth = 300;
//enable auto completion search mode
//lkBranchTo.Properties.SearchMode = SearchMode.AutoComplete;
//the column against which to perform the search
lkBranchTo.Properties.AutoSearchColumnIndex = 0;
if(this.gridView1.DataRowCount==0)
{
DataRow dr = dt.NewRow();
dr["strItemCode"]="Select Product";
dr["nQuantity"]="0";
dt.Rows.Add(dr);
this.gridControl1.DataSource = dt;
}
#region Disable Code
//TODO:Check Current Branch
//IList listBranchTo = srr.GetListByRange(typeof(Branch),"SP");
//this.lkBranchTo.Properties.DataSource = listBranchTo;
//this.lkBranchTo.Properties.ValueMember = "Id";
//this.lkBranchTo.Properties.DisplayMember = "StrBranchName";
//add two columns in the dropdown
//LookUpColumnInfoCollection col2 = lkBranchTo.Properties.Columns;
//a column to display values of the ProductID field
//col2.Add(new LookUpColumnInfo("Id","Id",2));
//a column to display values of the ProductName field
//col2.Add(new LookUpColumnInfo("StrBranchName","Branch Name",50));
//set column widths according to their contents
//lkBranchTo.Properties.BestFit();
//specify the total dropdown width
//lkBranchTo.Properties.PopupWidth = 300;
//enable auto completion search mode
//lkBranchTo.Properties.SearchMode = SearchMode.AutoComplete;
//the column against which to perform the search
//lkBranchTo.Properties.AutoSearchColumnIndex = 1;
//IList listEmployee = srr.GetListByDomain(typeof(Employee));
//this.lkRequestedBy.Properties.DataSource = listEmployee;
//this.lkRequestedBy.Properties.DisplayMember = "StrEmployeeName";
//this.lkRequestedBy.Properties.ValueMember = "Id";
//add two columns in the dropdown
//LookUpColumnInfoCollection col3 = lkRequestedBy.Properties.Columns;
//a column to display values of the ProductID field
//col3.Add(new LookUpColumnInfo("Id","Id",4));
//a column to display values of the ProductName field
//col3.Add(new LookUpColumnInfo("StrEmployeeName","Employee Name",50));
//set column widths according to their contents
//lkRequestedBy.Properties.BestFit();
//specify the total dropdown width
//lkRequestedBy.Properties.PopupWidth = 300;
//enable auto completion search mode
//lkRequestedBy.Properties.SearchMode = SearchMode.AutoComplete;
//the column against which to perform the search
//lkRequestedBy.Properties.AutoSearchColumnIndex = 1;
//IList listIBT = srr.GetListByDomain(typeof(IBT));
//this.lkIBT.Properties.DataSource = listIBT;
//this.lkIBT.Properties.DisplayMember = "Id";
//this.lkIBT.Properties.ValueMember = "Id";
//add two columns in the dropdown
//LookUpColumnInfoCollection col4 = lkIBT.Properties.Columns;
//a column to display values of the ProductID field
//col4.Add(new LookUpColumnInfo("Id"));
//set column widths according to their contents
//lkIBT.Properties.BestFit();
//enable auto completion search mode
//lkIBT.Properties.SearchMode = SearchMode.AutoComplete;
//the column against which to perform the search
//lkIBT.Properties.AutoSearchColumnIndex = 1;
//ArrayList _stockRequestStatus = new ArrayList();
//ACMS.Util.StockRequestStatus[] srs = (ACMS.Util.StockRequestStatus[])Enum.GetValues(typeof(ACMS.Util.StockRequestStatus));
//this.lkStatus.Properties.DataSource = srs;
#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();
}
}
public void LoadStockRequestEdit()
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
DataTable dt = stockRequest.GetStockRequestById(Convert.ToInt32(this.StockRequestNo));
if(dt!=null)
{
this.GetStockRequestDetail();
this.dateEdit1.EditValue = Convert.ToDateTime(dt.Rows[0]["dtDate"].ToString()).ToShortDateString();
this.lkBranchTo.EditValue = dt.Rows[0]["strBranchCodeTo"].ToString();
this.txtRequestedBy.Text = dt.Rows[0]["strRemarks"].ToString();
}
this.btn_Save.Text="Update";
this.btn_Add.Text="Cancel";
this.btn_Add.Width = 75;
this.simpleButton3.Visible=false;
//Rp.StockRequestRepository srp = new Rp.StockRequestRepository();
//Acms.Core.Domain.StockRequest sr = srp.GetStockRequestById(Convert.ToInt32(this.StockRequestNo));
}
private void CheckAvailableQuantity(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e)
{
if(!isEdit)
{
DataRow row = this.gridView1.GetDataRow(gridView1.FocusedRowHandle);
if(row["strItemCode"]!=null)
{
if(row["strItemCode"].ToString()!="Select Product")
{
string strProductCode = row["strItemCode"].ToString();
int quantityRequest = Convert.ToInt32(row["nQuantity"].ToString());
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
if(!stockRequest.GetAvailableQuantity(strProductCode,this.terminalUser.Branch.Id,quantityRequest))
{
UI.ShowErrorMessage(this,"Invalid Operation. Please change valid product quantity","Error");
this.canSave=false;
this.canAdd=false;
inValidQuantityRow=gridView1.FocusedRowHandle;
}
else
{
this.canSave=true;
this.canAdd=true;
}
}
else
{
this.canSave=false;
}
}
else
{
this.canSave=false;
}
}
}
private void LoadProductList()
{
this.repositoryItemLookUpEdit1.Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] {
new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strItemCode", "Product Code", 20, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None)});
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
this.repositoryItemLookUpEdit1.DataSource = stockRequest.GetProductByBranch(this.terminalUser.Branch.Id);//pr.GetProductByBranch(this.lkBranchTo.EditValue.ToString());
this.repositoryItemLookUpEdit1.DisplayMember = "strItemCode";
this.repositoryItemLookUpEdit1.ValueMember="strItemCode";
this.repositoryItemLookUpEdit1.NullText="Select Product";
LookUpColumnInfoCollection col2 = repositoryItemLookUpEdit1.Columns;
//a column to display values of the ProductID field
//a column to display values of the ProductName field
//col2.Add(new LookUpColumnInfo("Id","Product Code",20));
col2.Add(new LookUpColumnInfo("strBrand","Brand",50));
col2.Add(new LookUpColumnInfo("strDescription","Description",50));
col2.Add(new LookUpColumnInfo("strStyle","Style",50));
col2.Add(new LookUpColumnInfo("strColor","Color",50));
col2.Add(new LookUpColumnInfo("strSize","Size",50));
col2.Add(new LookUpColumnInfo("nQuantity","Quantity",50));
lkBranchTo.Properties.AutoSearchColumnIndex = 0;
repositoryItemLookUpEdit1.BestFit();
repositoryItemLookUpEdit1.PopupWidth = 600;
}
private void simpleButton3_Click(object sender, System.EventArgs e)
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
this.gridControl1.DataSource = stockRequest.SearchProduct(this.txtSearchStyle.Text,this.txtSearchProduct.Text,this.txtSearchProductDesc.Text,this.strBranchCode);
}
private void BindPage()
{
this.dateEdit1.Properties.Enabled=false;
this.dateEdit1.EditValue = DateTime.Today.ToShortDateString();
//Rp.StockRequestRepository srr = new Rp.StockRequestRepository();
//IList listBranchTo = srr.GetListByDomainAndExcludeById(typeof(Branch),this.terminalUser.Branch.Id);
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
this.lkBranchTo.Properties.DataSource = stockRequest.GetListByDomainAndExcludeById(this.terminalUser.Branch.Id);
//this.lkBranchTo.Properties.DataSource = listBranchTo;
//this.lkBranchTo.Properties.ValueMember = "Id";
//this.lkBranchTo.Properties.DisplayMember = "StrBranchName";
this.lkBranchTo.Properties.ValueMember = "strBranchCode";
this.lkBranchTo.Properties.DisplayMember = "strBranchName";
this.lkBranchTo.EditValue="Select Branch";
this.lkBranchTo.Text="Select Branch";
//add two columns in the dropdown
LookUpColumnInfoCollection coll = lkBranchTo.Properties.Columns;
//a column to display values of the ProductID field
// coll.Add(new LookUpColumnInfo("Id","Branch Code",2));
// //a column to display values of the ProductName field
// coll.Add(new LookUpColumnInfo("StrBranchName","Branch Name",50));
coll.Add(new LookUpColumnInfo("strBranchCode","Branch Code",2));
//a column to display values of the ProductName field
coll.Add(new LookUpColumnInfo("strBranchName","Branch Name",50));
//set column widths according to their contents
lkBranchTo.Properties.BestFit();
//specify the total dropdown width
lkBranchTo.Properties.PopupWidth = 300;
//enable auto completion search mode
//lkBranchTo.Properties.SearchMode = SearchMode.AutoComplete;
//the column against which to perform the search
lkBranchTo.Properties.AutoSearchColumnIndex = 0;
if(this.gridView1.DataRowCount==0)
{
DataRow dr = dt.NewRow();
dr["strItemCode"]="Select Product";
dr["nQuantity"]="0";
dt.Rows.Add(dr);
this.gridControl1.DataSource = dt;
}
}
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 GetStockRequestDetail()
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
DataTable dt = stockRequest.GetStockRequestEntriesById(Convert.ToInt32(this.StockRequestNo));
if(dt!=null)
{
this.gridControl1.DataSource = dt;
}
}
private void SerachProduct(object sender, System.Windows.Forms.KeyEventArgs e)
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
this.gridControl1.DataSource = stockRequest.SearchProduct(this.txtSearchStyle.Text,this.txtSearchProduct.Text,this.txtSearchProductDesc.Text,this.strBranchCode);
}
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 GetStockRequestDetail()
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
DataTable dt = stockRequest.GetStockRequestEntriesById(Convert.ToInt32(this.StockRequestNo));
if(dt!=null)
{
this.gridControl1.DataSource = dt;
this.gridView1.Columns[0].OptionsColumn.AllowEdit=false;
}
this.simpleButton4.Visible=false;
}
private void SerachProduct(object sender, System.Windows.Forms.KeyEventArgs e)
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
this.gridControl1.DataSource = stockRequest.SearchProduct(this.txtSearchStyle.Text, this.txtSearchProduct.Text, this.txtSearchProductDesc.Text, this.strBranchCode);
}
private void simpleButton3_Click(object sender, System.EventArgs e)
{
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
this.gridControl1.DataSource = stockRequest.SearchProduct(this.txtSearchStyle.Text, this.txtSearchProduct.Text, this.txtSearchProductDesc.Text, this.strBranchCode);
}
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
}
}
public void LoadStockRequestDetail_Edit()
{
// Rp.StockRequestRepository srp = new Rp.StockRequestRepository();
// Acms.Core.Domain.StockRequest sr = srp.GetStockRequestById(Convert.ToInt32(this.StockRequestNo));
// this.sr=sr;
//
// this.txtBranchFrom.Text = sr.BranchFrom.Id;
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
DataTable dt = stockRequest.GetStockRequestById(Convert.ToInt32(this.StockRequestNo));
if(dt!=null)
{
this.GetStockRequestDetail();
this.dateEdit1.EditValue = Convert.ToDateTime(dt.Rows[0]["dtDate"].ToString()).ToShortDateString();
this.txtBranchFrom.Text = dt.Rows[0]["strBranchCodeTo"].ToString();
this.txtStockRequestNo.Enabled=false;
this.txtBranchFrom.Enabled=false;
}
GetStockRequestDetail();
}
private void CheckAvailableQuantity(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e)
{
if(!isEdit)
{
if(CheckDuplicate())
{
DataRow row = this.gridView1.GetDataRow(gridView1.FocusedRowHandle);
if(row["strItemCode"].ToString().Length>0 && row["strItemCode"].ToString()!="Select Product")
{
string strProductCode = row["strItemCode"].ToString();
int quantityRequest = Convert.ToInt32(row["nQuantity"].ToString());
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
if(!stockRequest.GetAvailableQuantity(strProductCode,this.lkBranchTo.EditValue.ToString(),quantityRequest))
{
UI.ShowErrorMessage(this,"Quantity request exceeded Balance","Error");
this.canSave=false;
this.canAdd=false;
inValidQuantityRow=gridView1.FocusedRowHandle;
}
else
{
this.canSave=true;
this.canAdd=true;
return;
}
}
}
}
this.canSave=false;
}
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 lk_Product_Init()
{
//DataSet _ds = new DataSet();
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
//string strSQL = "select * from tblproduct";
//SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
//_ds.Tables[0];
DataTable dt = stockRequest.GetProductByBranch(this.lkBranchTo.EditValue.ToString());//pr.GetProductByBranch(this.lkBranchTo.EditValue.ToString());
lk_Product.BestFit();
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[6];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strItemCode","Item Code",50,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",50,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[2] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strStyle","Style",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[3] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strColor","Color",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[4] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strSize","Size",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[5] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nQuantity","Quantity",10,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
try
{
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lk_Product,dt,col,"strItemCode","strItemCode","Item Code");
}
catch(Exception ex)
{
return;
}
}
private void BindPage()
{
this.dateEdit1.Text = DateTime.Today.ToShortDateString();
//Rp.StockRequestRepository srr = new Rp.StockRequestRepository();
//IList listBranchTo = srr.GetListByDomainAndExcludeById(typeof(Branch),this.terminalUser.Branch.Id);
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
this.lkBranchTo.Properties.DataSource = stockRequest.GetListByDomainAndExcludeById(this.terminalUser.Branch.Id);
this.lkBranchTo.Properties.ValueMember = "strBranchCode";
this.lkBranchTo.Properties.DisplayMember = "strBranchName";
this.lkBranchTo.EditValue = "Select Branch";
this.lkBranchTo.Text = "Select Branch";
//add two columns in the dropdown
LookUpColumnInfoCollection coll = lkBranchTo.Properties.Columns;
//a column to display values of the ProductID field
coll.Add(new LookUpColumnInfo("strBranchCode", "Branch Code", 2));
//a column to display values of the ProductName field
coll.Add(new LookUpColumnInfo("strBranchName", "Branch Name", 50));
//set column widths according to their contents
lkBranchTo.Properties.BestFit();
//specify the total dropdown width
lkBranchTo.Properties.PopupWidth = 300;
//enable auto completion search mode
//lkBranchTo.Properties.SearchMode = SearchMode.AutoComplete;
//the column against which to perform the search
lkBranchTo.Properties.AutoSearchColumnIndex = 0;
if (this.gridView1.DataRowCount == 0)
{
DataRow dr = dt.NewRow();
dr["strItemCode"] = "Select Product";
dr["nQuantity"] = "0";
dt.Rows.Add(dr);
this.gridControl1.DataSource = dt;
}
#region Disable Code
//TODO:Check Current Branch
//IList listBranchTo = srr.GetListByRange(typeof(Branch),"SP");
//this.lkBranchTo.Properties.DataSource = listBranchTo;
//this.lkBranchTo.Properties.ValueMember = "Id";
//this.lkBranchTo.Properties.DisplayMember = "StrBranchName";
//add two columns in the dropdown
//LookUpColumnInfoCollection col2 = lkBranchTo.Properties.Columns;
//a column to display values of the ProductID field
//col2.Add(new LookUpColumnInfo("Id","Id",2));
//a column to display values of the ProductName field
//col2.Add(new LookUpColumnInfo("StrBranchName","Branch Name",50));
//set column widths according to their contents
//lkBranchTo.Properties.BestFit();
//specify the total dropdown width
//lkBranchTo.Properties.PopupWidth = 300;
//enable auto completion search mode
//lkBranchTo.Properties.SearchMode = SearchMode.AutoComplete;
//the column against which to perform the search
//lkBranchTo.Properties.AutoSearchColumnIndex = 1;
//IList listEmployee = srr.GetListByDomain(typeof(Employee));
//this.lkRequestedBy.Properties.DataSource = listEmployee;
//this.lkRequestedBy.Properties.DisplayMember = "StrEmployeeName";
//this.lkRequestedBy.Properties.ValueMember = "Id";
//add two columns in the dropdown
//LookUpColumnInfoCollection col3 = lkRequestedBy.Properties.Columns;
//a column to display values of the ProductID field
//col3.Add(new LookUpColumnInfo("Id","Id",4));
//a column to display values of the ProductName field
//col3.Add(new LookUpColumnInfo("StrEmployeeName","Employee Name",50));
//set column widths according to their contents
//lkRequestedBy.Properties.BestFit();
//specify the total dropdown width
//lkRequestedBy.Properties.PopupWidth = 300;
//enable auto completion search mode
//lkRequestedBy.Properties.SearchMode = SearchMode.AutoComplete;
//the column against which to perform the search
//lkRequestedBy.Properties.AutoSearchColumnIndex = 1;
//IList listIBT = srr.GetListByDomain(typeof(IBT));
//this.lkIBT.Properties.DataSource = listIBT;
//this.lkIBT.Properties.DisplayMember = "Id";
//this.lkIBT.Properties.ValueMember = "Id";
//add two columns in the dropdown
//LookUpColumnInfoCollection col4 = lkIBT.Properties.Columns;
//a column to display values of the ProductID field
//col4.Add(new LookUpColumnInfo("Id"));
//set column widths according to their contents
//lkIBT.Properties.BestFit();
//enable auto completion search mode
//lkIBT.Properties.SearchMode = SearchMode.AutoComplete;
//the column against which to perform the search
//lkIBT.Properties.AutoSearchColumnIndex = 1;
//ArrayList _stockRequestStatus = new ArrayList();
//ACMS.Util.StockRequestStatus[] srs = (ACMS.Util.StockRequestStatus[])Enum.GetValues(typeof(ACMS.Util.StockRequestStatus));
//this.lkStatus.Properties.DataSource = srs;
#endregion
}
