private void UploadMaterialMaster()
{
try
{
string resultMsg = string.Empty;
using (MaterialBLL materialBll = new MaterialBLL())
{
resultMsg = materialBll.UploadMaterialMaster(this.dtCSVdata, this.LOCATION_ID, this.USER_ID);
}
if (resultMsg == "OK")
{
NotifierResult.Show("Upload CSV Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
XtraMessageBox.Show(this, resultMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
catch (Exception ex)
{
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (AlreadyAdded)
{
DialogResult dCliResTest = XtraMessageBox.Show(this, AleradyAddedMessage, "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
if (dCliResTest == DialogResult.No)
{
return;
}
}
string result = String.Empty;
using (MaterialSpecialBLL matBll = new MaterialSpecialBLL())
{
result = matBll.InsertMaterialSP(dtSrcUpload, ((frmMainMenu)this.ParentForm).UserID);
}
if (result == "OK")
{
NotifierResult.Show("Insert Complete", "Result", 50, 1000, 50, NotifyType.Safe);
AlreadyAdded = false;
AleradyAddedMessage = "";
}
this.LockUploadScreen();
}
private void InsertRole()
{
string result = string.Empty;
Role role = null;
try
{
DataRow rowRole = this.dtbRole.Rows[0];
if (rowRole != null)
{
role = new Role();
role.ROLE_ID = rowRole["ROLE_ID"].ToString().ToUpper();
role.ROLE_NAME = rowRole["ROLE_NAME"].ToString();
role.REC_STAT = (bool)rowRole["REC_STAT"];
}
using (AdministratorBLL adminBll = new AdministratorBLL())
{
result = adminBll.InsertRole(role, ((frmMainMenu)this.ParentForm).UserID);
}
if (result.Equals("OK"))
{
NotifierResult.Show("Insert Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
this.FormState = eFormState.ReadOnly;
//Get all Invoice on Invoice List
this.GetRoleList();
if (result.Equals("OK"))
{
GridView viewList = (GridView)this.grdRole.Views[0];
viewList.ClearSorting();
int position = UiUtility.GetRowHandleByColumnValue(viewList, "ROLE_ID", role.ROLE_ID);
if (position != 0)
{
if (position != GridControl.InvalidRowHandle)
{
this.dntRole.Position = position;
}
}
else
{
viewList.FocusedRowHandle = 0;
}
}
}
}
private void UploadSalesOrderSage50()
{
try
{
string resultMsg = string.Empty;
using (ShippingOrderBLL shippingBll = new ShippingOrderBLL())
{
resultMsg = shippingBll.UploadSalesOrder_SAGE50(this.dtCSVdata, this.USER_ID);
}
if (resultMsg == "OK")
{
NotifierResult.Show("Upload CSV Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
XtraMessageBox.Show(this, resultMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
catch (Exception ex)
{
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
private void UpdateMachine()
{
string result = string.Empty;
try
{
this.Cursor = Cursors.WaitCursor;
Machine mc = new Machine();
mc.MC_NO = this.txtMC_NO.Text;
mc.MACHINE_NAME = this.txtMACHINE_NAME.Text;
mc.MACHINE_TYPE = (string)this.lueMACHINE_TYPE.EditValue;
mc.MACHINE_SIZE = this.txtMACHINE_SIZE.Text;
mc.REMARK = this.txtREMARK.Text;
mc.REC_STAT = (bool)this.icbREC_STAT.EditValue;
using (MachineBLL mcBll = new MachineBLL())
{
result = mcBll.UpdateMachine(mc, ((frmMainMenu)this.ParentForm).UserID);
}
if (result.Equals("OK"))
{
GridView view = (GridView)this.grdMachine.Views[0];
view.BeginDataUpdate();
view.SetFocusedRowCellValue("MACHINE_NAME", mc.MACHINE_NAME);
view.SetFocusedRowCellValue("MACHINE_TYPE", mc.MACHINE_TYPE);
view.SetFocusedRowCellValue("MACHINE_SIZE", mc.MACHINE_SIZE);
view.SetFocusedRowCellValue("REMARK", mc.REMARK);
view.SetFocusedRowCellValue("REC_STAT", mc.REC_STAT);
view.EndDataUpdate();
NotifierResult.Show("Update Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
NotifierResult.Show(ex.Message, "Error", 100, 1000, 0, NotifyType.Warning);
}
finally
{
this.Cursor = Cursors.Default;
this.FormState = eFormState.ReadOnly;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string resultMsg = string.Empty;
GridView view = this.grdPickingList.Views[0] as GridView;
List <PickingDtl> lstPicking = null;
try
{
lstPicking = new List <PickingDtl>();
int flag = 0;
for (int i = 0; i < view.RowCount; i++)
{
flag = Convert.ToInt32(view.GetRowCellValue(i, "FLAG"), NumberFormatInfo.CurrentInfo);
if (flag.Equals(1))
{
lstPicking.Add((PickingDtl)view.GetRow(i));
}
}
if (lstPicking.Count > 0)
{
using (ShippingOrderBLL soBll = new ShippingOrderBLL())
{
resultMsg = soBll.UpdatePickingHDR(lstPicking, this.USER_ID);
}
if (resultMsg.Equals("OK"))
{
NotifierResult.Show("Update Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(resultMsg, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
else
{
NotifierResult.Show("No Data Update", "Result", 50, 1000, 50, NotifyType.Warning);
}
}
catch (Exception ex)
{
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
this.FormState = eFormState.ReadOnly;
}
}
private void UploadPartyMaster()
{
try
{
string resultMsg = string.Empty;
using (PartyBLL partyBll = new PartyBLL())
{
if (this.PARTY_TYPE == "C")
{
resultMsg = partyBll.UploadCustomerMaster(this.dtCSVdata, this.PARTY_TYPE, this.USER_ID);
}
else if (this.PARTY_TYPE == "V")
{
resultMsg = partyBll.UploadVendorMaster(this.dtCSVdata, this.PARTY_TYPE, this.USER_ID);
}
else
{
resultMsg = "NOTHING UPDATE";
}
}
if (resultMsg == "OK")
{
NotifierResult.Show("Upload CSV Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
XtraMessageBox.Show(this, resultMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
catch (Exception ex)
{
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
public void InsertShippingOrder()
{
string result = string.Empty;
ShippingOrder shippingOrd;
try
{
#region "Shipping Order Header"
var lstShippingOrd = this.grdSO_HDR.DataSource as List <ShippingOrder>;
shippingOrd = lstShippingOrd[0];
#endregion
#region "Shipping Order Detail"
DataTable dtbShippingDtl = this.grdSO_DTL.DataSource as DataTable;
var drSelect = dtbShippingDtl.Select("[PROD_SEQ_NO] IS NOT NULL", "[LINE_NO]");
ShippingOrderDtl shpOrdDtl;
foreach (DataRow dr in drSelect)
{
shpOrdDtl = new ShippingOrderDtl();
shpOrdDtl.SO_NO = dr["SO_NO"].ToString();
shpOrdDtl.LINE_NO = Convert.ToInt32(dr["LINE_NO"], NumberFormatInfo.CurrentInfo);
shpOrdDtl.PROD_SEQ_NO = dr["PROD_SEQ_NO"].ToString();
shpOrdDtl.UNIT_ID = dr["UNIT_ID"].ToString();
shpOrdDtl.PACKAGING = dr["PACKAGING"].ToString();
shpOrdDtl.QTY = Convert.ToInt32(dr["QTY"], NumberFormatInfo.CurrentInfo);
shpOrdDtl.UNIT_PRICE = (dr["UNIT_PRICE"] as decimal?) ?? 0.0M;
//shpOrdDtl.UNIT_PRICE = Convert.ToDecimal(dr["UNIT_PRICE"], NumberFormatInfo.CurrentInfo);
shpOrdDtl.REMARK = dr["REMARK"].ToString();
shpOrdDtl.PO_NO = dr["PO_NO"].ToString();
shpOrdDtl.REC_STAT = true;
shippingOrd.AddItem(shpOrdDtl);
}
#endregion
using (ShippingOrderBLL shipOrdBll = new ShippingOrderBLL())
{
result = shipOrdBll.InsertShippingOrder(ref shippingOrd, this.USER_ID);
}
if (result.Equals("OK"))
{
NotifierResult.Show("Insert Complete", "Result", 50, 1000, 50, NotifyType.Safe);
this._SO_NO = shippingOrd.SO_NO;
DialogResult = DialogResult.OK;
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
DialogResult = DialogResult.Cancel;
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
NotifierResult.Show(ex.Message, "Error", 100, 1000, 0, NotifyType.Warning);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void UpdateUser()
{
string result = string.Empty;
try
{
User user = new User();
user.USER_ID = (string)this.txtUSER_ID.EditValue;
user.USER_NAME = (string)this.txtUSER_NAME.EditValue;
user.WARE_ID = (string)this.txtWARE_ID.EditValue;
user.LOGIN = (string)this.txtLOGIN.EditValue;
user.PWD = (string)this.txtPWD.EditValue;
user.EMPLOYEE_ID = (string)UiUtility.IsNullValue(this.txtEMPLOYEE_ID.EditValue, "");
user.ROLE_ID = (string)this.lueDefaultRole.EditValue;
user.REMARK = (string)UiUtility.IsNullValue(this.txtREMARK.EditValue, "");
user.EMAIL = (string)UiUtility.IsNullValue(this.txtEMAIL.EditValue, "");
user.COMP_ID = (string)UiUtility.IsNullValue(this.txtCOMP_ID.EditValue, "");
user.REC_STAT = (bool)this.icbREC_STAT.EditValue;
using (AdministratorBLL adminBll = new AdministratorBLL())
{
result = adminBll.UpdateUser(user, ((frmMainMenu)this.ParentForm).UserID);
}
if (result.Equals("OK"))
{
this.UpdateUserRole();
GridView view = (GridView)this.grdUserList.Views[0];
view.BeginDataUpdate();
view.SetFocusedRowCellValue("USER_ID", user.USER_ID);
view.SetFocusedRowCellValue("USER_NAME", user.USER_NAME);
view.SetFocusedRowCellValue("WARE_ID", user.WARE_ID);
view.SetFocusedRowCellValue("EMPLOYEE_ID", user.EMPLOYEE_ID);
view.SetFocusedRowCellValue("ROLE_ID", user.ROLE_ID);
view.SetFocusedRowCellValue("EMAIL", user.EMAIL);
view.SetFocusedRowCellValue("REC_STAT", user.REC_STAT);
view.EndDataUpdate();
NotifierResult.Show("Update Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
NotifierResult.Show(ex.Message, "Error", 50, 1000, 0, NotifyType.Warning);
}
finally
{
this.FormState = eFormState.ReadOnly;
}
}
private void InsertUser()
{
string result = string.Empty;
try
{
User user = new User();
user.USER_ID = (string)this.txtUSER_ID.EditValue;
user.USER_NAME = (string)this.txtUSER_NAME.EditValue;
user.WARE_ID = (string)this.txtWARE_ID.EditValue;
user.LOGIN = (string)this.txtLOGIN.EditValue;
user.PWD = (string)this.txtPWD.EditValue;
user.EMPLOYEE_ID = (string)UiUtility.IsNullValue(this.txtEMPLOYEE_ID.EditValue, "");
user.ROLE_ID = (string)this.lueDefaultRole.EditValue;
user.REMARK = (string)UiUtility.IsNullValue(this.txtREMARK.EditValue, "");
user.EMAIL = (string)UiUtility.IsNullValue(this.txtEMAIL.EditValue, "");
user.COMP_ID = (string)UiUtility.IsNullValue(this.txtCOMP_ID.EditValue, "");
user.REC_STAT = (bool)this.icbREC_STAT.EditValue;
using (AdministratorBLL adminBll = new AdministratorBLL())
{
result = adminBll.InsertUser(user, ((frmMainMenu)this.ParentForm).UserID);
}
if (result.Equals("OK"))
{
this.UpdateUserRole();
NotifierResult.Show("Insert Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
NotifierResult.Show(ex.Message, "Error", 100, 1000, 0, NotifyType.Warning);
}
finally
{
this.FormState = eFormState.ReadOnly;
//Get all Invoice on Invoice List
this.GetUserList();
if (result.Equals("OK"))
{
GridView viewList = (GridView)this.grdUserList.Views[0];
viewList.ClearSorting();
int position = UiUtility.GetRowHandleByColumnValue(viewList, "USER_ID", this.txtUSER_ID.Text);
if (position != 0)
{
if (position != GridControl.InvalidRowHandle)
{
this.dntUser.Position = position;
}
}
else
{
viewList.FocusedRowHandle = 0;
}
}
}
}
public void UpdateMaterial()
{
string result = string.Empty;
Material material = null;
try
{
this.Cursor = Cursors.WaitCursor;
material = new Material();
material.MTL_SEQ_NO = this.txtMTL_SEQ_NO.Text;
material.MTL_CODE = this.txtMTL_CODE.Text;
material.MTL_NAME = this.txtMTL_NAME.Text;
material.MTL_GRADE = this.txtMTL_GRADE.Text;
material.MTL_COLOR = this.txtMTL_COLOR.Text;
if (this.lueUNIT.EditValue != null)
{
material.UNIT = (string)this.lueUNIT.EditValue;
}
material.STD_QTY = Convert.ToDecimal(this.txtSTD_QTY.EditValue, NumberFormatInfo.InvariantInfo);
material.MIN_QTY = Convert.ToDecimal(this.txtMIN_QTY.EditValue, NumberFormatInfo.InvariantInfo);
material.MAX_QTY = Convert.ToDecimal(this.txtMAX_QTY.EditValue, NumberFormatInfo.InvariantInfo);
material.PARTY_ID = this.btePARTY_ID.Text;
if ((Bitmap)this.picMTL_IMAGE.Image != null)
{
material.MTL_IMAGE = (Bitmap)this.picMTL_IMAGE.Image;
}
else
{
material.MTL_IMAGE = this._emptyImage;
}
if (this.lueLOCATION_ID.EditValue != null)
{
material.LOCATION_ID = (string)this.lueLOCATION_ID.EditValue;
}
material.REMARK = this.txtREMARK.Text;
material.REC_STAT = (bool)this.icbREC_STAT.EditValue;
string userid = ((frmMainMenu)this.ParentForm).UserID;
using (MaterialBLL materialBll = new MaterialBLL())
{
result = materialBll.UpdateMaterial(material, userid);
}
if (result.Equals("OK"))
{
GridView view = (GridView)this.grdMaterial.Views[0];
view.BeginDataUpdate();
view.SetFocusedRowCellValue("MTL_SEQ_NO", material.MTL_SEQ_NO);
view.SetFocusedRowCellValue("MTL_CODE", material.MTL_CODE);
view.SetFocusedRowCellValue("MTL_NAME", material.MTL_NAME);
view.SetFocusedRowCellValue("MTL_GRADE", material.MTL_GRADE);
view.SetFocusedRowCellValue("MTL_COLOR", material.MTL_COLOR);
view.SetFocusedRowCellValue("UNIT", material.UNIT);
view.SetFocusedRowCellValue("STD_QTY", material.STD_QTY);
view.SetFocusedRowCellValue("MIN_QTY", material.MIN_QTY);
view.SetFocusedRowCellValue("MAX_QTY", material.MAX_QTY);
view.SetFocusedRowCellValue("PARTY_ID", material.PARTY_ID);
view.SetFocusedRowCellValue("LOCATION_ID", material.LOCATION_ID);
view.SetFocusedRowCellValue("REMARK", material.REMARK);
view.SetFocusedRowCellValue("REC_STAT", material.REC_STAT);
view.EndDataUpdate();
NotifierResult.Show("Update Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
NotifierResult.Show(ex.Message, "Error", 100, 1000, 0, NotifyType.Warning);
}
finally
{
this.Cursor = Cursors.Default;
this.FormState = eFormState.ReadOnly;
}
}
public void InsertMaterial()
{
string result = string.Empty;
Material material = null;
try
{
this.Cursor = Cursors.WaitCursor;
material = new Material();
material.MTL_SEQ_NO = this.txtMTL_SEQ_NO.Text;
material.MTL_CODE = this.txtMTL_CODE.Text;
material.MTL_NAME = this.txtMTL_NAME.Text;
material.MTL_GRADE = this.txtMTL_GRADE.Text;
material.MTL_COLOR = this.txtMTL_COLOR.Text;
if (this.lueUNIT.EditValue != null)
{
material.UNIT = (string)this.lueUNIT.EditValue;
}
material.STD_QTY = Convert.ToDecimal(this.txtSTD_QTY.EditValue, NumberFormatInfo.InvariantInfo);
material.MIN_QTY = Convert.ToDecimal(this.txtMIN_QTY.EditValue, NumberFormatInfo.InvariantInfo);
material.MAX_QTY = Convert.ToDecimal(this.txtMAX_QTY.EditValue, NumberFormatInfo.InvariantInfo);
material.PARTY_ID = this.btePARTY_ID.Text;
material.MTL_IMAGE = (Bitmap)this.picMTL_IMAGE.Image;
if (this.lueLOCATION_ID.EditValue != null)
{
material.LOCATION_ID = (string)this.lueLOCATION_ID.EditValue;
}
material.REMARK = this.txtREMARK.Text;
material.REC_STAT = (bool)this.icbREC_STAT.EditValue;
string userid = ((frmMainMenu)this.ParentForm).UserID;
using (MaterialBLL materialBll = new MaterialBLL())
{
result = materialBll.InsertMaterial(ref material, userid);
}
if (result.Equals("OK"))
{
NotifierResult.Show("Insert Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
NotifierResult.Show(ex.Message, "Error", 100, 1000, 0, NotifyType.Warning);
}
finally
{
this.Cursor = Cursors.Default;
this.FormState = eFormState.ReadOnly;
this.GetMaterialList(string.Empty);
if (result.Equals("OK"))
{
GridView viewList = (GridView)this.grdMaterial.Views[0];
viewList.ClearSorting();
int position = UiUtility.GetRowHandleByColumnValue(viewList, "MTL_SEQ_NO", material.MTL_SEQ_NO);
if (position != 0)
{
if (position != GridControl.InvalidRowHandle)
{
this.dntProduct.Position = position;
}
}
else
{
viewList.FocusedRowHandle = 0;
}
}
}
}
public void InsertParty()
{
string result = string.Empty;
Party party = null;
try
{
this.Cursor = Cursors.WaitCursor;
party = new Party();
party.PARTY_ID = string.Empty;
party.PARTY_NAME = this.txtPARTY_NAME.Text;
party.PARTY_TYPE = (string)this.icbPARTY_TYPE.EditValue;
party.ADD1 = this.txtADD1.Text;
party.ADD2 = this.txtADD2.Text;
party.ADD3 = this.txtADD3.Text;
party.ADD4 = this.txtADD4.Text;
party.TEL = this.txtTEL.Text;
party.FAX = this.txtFAX.Text;
party.EMAIL = this.txtEMAIL.Text;
party.PIC = this.txtPIC.Text;
party.REMARK = this.txtREMARK.Text;
party.REC_STAT = (bool)this.icbREC_STAT.EditValue;
using (PartyBLL partyBll = new PartyBLL())
{
result = partyBll.InsertParty(ref party, ((frmMainMenu)this.ParentForm).UserID);
}
if (result.Equals("OK"))
{
NotifierResult.Show("Insert Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
NotifierResult.Show(ex.Message, "Error", 100, 1000, 0, NotifyType.Warning);
}
finally
{
this.Cursor = Cursors.Default;
this.FormState = eFormState.ReadOnly;
this.GetPartyList(string.Empty);
if (result.Equals("OK"))
{
this.txtPARTY_ID.Text = party.PARTY_ID;
GridView viewList = (GridView)this.grdParty.Views[0];
viewList.ClearSorting();
int position = UiUtility.GetRowHandleByColumnValue(viewList, "PARTY_ID", party.PARTY_ID);
if (position != 0)
{
if (position != GridControl.InvalidRowHandle)
{
this.dntParty.Position = position;
}
}
else
{
viewList.FocusedRowHandle = 0;
}
}
}
}
public void UpdateQCReturn()
{
string result = string.Empty;
QCReturnHdr qcReturn = new QCReturnHdr();
try
{
#region "QC Return Header"
qcReturn.RT_NO = this.txtRT_NO.Text;
qcReturn.RT_DATE = this.txtRT_DATE.DateTime;
qcReturn.WH_ID = this.lueWarehouse.EditValue.ToString();
qcReturn.RT_TYPE = this.lueReturnType.EditValue.ToString();
qcReturn.REMARK = this.txtREMARK.Text;
qcReturn.REC_STAT = (bool)this.icbREC_STAT.EditValue;
#endregion
using (QCReturnBLL qcReturnBll = new QCReturnBLL())
{
result = qcReturnBll.UpdateQCReturn(qcReturn, ((frmMainMenu)this.ParentForm).UserID);
}
if (result.Equals("OK"))
{
NotifierResult.Show("Update Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
NotifierResult.Show(ex.Message, "Error", 100, 1000, 0, NotifyType.Warning);
}
finally
{
this.FormState = eFormState.ReadOnly;
//Get all Invoice on Invoice List
this.GetQCReturnList(this.lueWarehouse.EditValue.ToString(), null, null);
if (result.Equals("OK"))
{
GridView viewList = (GridView)this.grdQCReturn.Views[0];
viewList.ClearSorting();
int position = UiUtility.GetRowHandleByColumnValue(viewList, "RT_NO", qcReturn.RT_NO);
if (position != 0)
{
if (position != GridControl.InvalidRowHandle)
{
this.dntQCReturn.Position = position;
}
}
else
{
viewList.FocusedRowHandle = 0;
}
}
this.Cursor = Cursors.Default;
}
}
public void UpdateProduct()
{
string result = string.Empty;
List <ProdProcess> lstProdProcess = null;
Product prod = null;
try
{
this.Cursor = Cursors.WaitCursor;
prod = new Product();
prod.PROD_SEQ_NO = this.txtPROD_SEQ_NO.Text;
prod.PRODUCT_NO = this.txtPRODUCT_NO.Text;
prod.PRODUCT_NAME = this.txtPRODUCT_NAME.Text;
prod.MATERIAL_TYPE = this.lblMATERIAL_TYPE_CODE.Text;
prod.PRODUCTION_TYPE = (string)this.luePRODUCTION_TYPE.EditValue;
prod.MC_NO = this.lblMC_NO_VALUE.Text;
prod.BOX_QTY = Convert.ToInt32(this.txtBOX_QTY.EditValue, NumberFormatInfo.InvariantInfo);
prod.UNIT = (string)this.lueUNIT.EditValue;
if ((Bitmap)this.picPROD_IMAGE.Image != null)
{
prod.PROD_IMAGE = (Bitmap)this.picPROD_IMAGE.Image;
}
else
{
prod.PROD_IMAGE = this._emptyImage;
}
prod.REMARK = this.txtREMARK.Text;
prod.REC_STAT = (bool)this.icbREC_STAT.EditValue;
//add new Update property on 07-Jun-2011
prod.CUST_PROD_NO = this.txtCUST_PROD_NO.Text;
prod.BUYER_PRICE = (this.txtBUYER_PRICE.EditValue as decimal?) ?? 0.0M;
prod.SELLING_PRICE = (this.txtSELLING_PRICE.EditValue as decimal?) ?? 0.0M;
prod.COST_PRICE = (this.txtCOST_PRICE.EditValue as decimal?) ?? 0.0M;
if (this.dtbProdProcess.Rows.Count != 0)
{
lstProdProcess = new List <ProdProcess>();
int flag = 0;
ProdProcess prodProcess;
foreach (DataRow rowProdProcess in this.dtbProdProcess.Rows)
{
flag = Convert.ToInt32(rowProdProcess["FLAG"], NumberFormatInfo.CurrentInfo);
if (flag == 2)
{
prodProcess = new ProdProcess();
prodProcess.PROD_SEQ_NO = rowProdProcess["PROD_SEQ_NO"].ToString();
prodProcess.PROCESS_NO = rowProdProcess["PROCESS_NO"].ToString();
prodProcess.STEP_NO = (int)rowProdProcess["STEP_NO"];
prodProcess.REC_STAT = (bool)rowProdProcess["REC_STAT"];
lstProdProcess.Add(prodProcess);
}
}
}
string userid = ((frmMainMenu)this.ParentForm).UserID;
using (ProductBLL prodBll = new ProductBLL())
{
result = prodBll.UpdateProduct(prod, userid);
if (lstProdProcess != null)
{
prodBll.UpdateProductionProcess(lstProdProcess, userid);
}
}
if (result.Equals("OK"))
{
GridView view = (GridView)this.grdProduct.Views[0];
view.BeginDataUpdate();
view.SetFocusedRowCellValue("PROD_SEQ_NO", prod.PROD_SEQ_NO);
view.SetFocusedRowCellValue("PRODUCT_NO", prod.PRODUCT_NO);
view.SetFocusedRowCellValue("PRODUCT_NAME", prod.PRODUCT_NAME);
view.SetFocusedRowCellValue("MATERIAL_TYPE", prod.MATERIAL_TYPE);
view.SetFocusedRowCellValue("PRODUCTION_TYPE", prod.PRODUCTION_TYPE);
view.SetFocusedRowCellValue("MC_NO", prod.MC_NO);
view.SetFocusedRowCellValue("BOX_QTY", prod.BOX_QTY);
view.SetFocusedRowCellValue("REMARK", prod.REMARK);
view.SetFocusedRowCellValue("REC_STAT", prod.REC_STAT);
view.EndDataUpdate();
NotifierResult.Show("Update Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
NotifierResult.Show(ex.Message, "Error", 100, 1000, 0, NotifyType.Warning);
}
finally
{
this.Cursor = Cursors.Default;
this.FormState = eFormState.ReadOnly;
}
}
private void UpdateProgramType()
{
ProgramType programType = null;
string result = string.Empty;
try
{
DataRow rowProgramType = this.dtbProgramType.Rows[0];
if (rowProgramType != null)
{
programType = new ProgramType();
programType.PROG_TYPE = rowProgramType["PROG_TYPE"].ToString().ToUpper();
programType.PROG_TYPE_NAME = rowProgramType["PROG_TYPE_NAME"].ToString();
programType.REC_STAT = (bool)rowProgramType["REC_STAT"];
if (!rowProgramType["ORDER_BY"].GetType().Equals(typeof(System.DBNull)))
{
programType.ORDER_BY = Convert.ToInt32(rowProgramType["ORDER_BY"].ToString());
}
programType.ICON = rowProgramType["ICON"].ToString();
}
using (AdministratorBLL adminBll = new AdministratorBLL())
{
result = adminBll.UpdateProgramType(programType, ((frmMainMenu)this.ParentForm).UserID);
}
if (result.Equals("OK"))
{
NotifierResult.Show("Update Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
NotifierResult.Show(ex.Message, "Error", 50, 1000, 0, NotifyType.Warning);
}
finally
{
this.GetProgramTypeList();
this.FormState = eFormState.ReadOnly;
if (result.Equals("OK"))
{
GridView viewList = (GridView)this.grdProgramType.Views[0];
viewList.ClearSorting();
int position = UiUtility.GetRowHandleByColumnValue(viewList, "PROG_TYPE", programType.PROG_TYPE);
if (position != 0)
{
if (position != GridControl.InvalidRowHandle)
{
this.dntProgramType.Position = position;
}
}
else
{
viewList.FocusedRowHandle = 0;
}
}
this.btnAddNew.Visible = true;
this.btnExit.Visible = true;
}
}
private void UpdateRole()
{
List <RoleProgram> lstRowProgUpd = null;
Role role = null;
string result = string.Empty;
string userid = ((frmMainMenu)this.ParentForm).UserID;
try
{
DataRow rowRole = this.dtbRole.Rows[0];
if (rowRole != null)
{
role = new Role();
role.ROLE_ID = rowRole["ROLE_ID"].ToString().ToUpper();
role.ROLE_NAME = rowRole["ROLE_NAME"].ToString();
role.REC_STAT = (bool)rowRole["REC_STAT"];
}
if (this.dtbRoleProg.Rows.Count != 0)
{
lstRowProgUpd = new List <RoleProgram>();
int flag = 0;
RoleProgram rowProgUpd;
foreach (DataRow rowProg in this.dtbRoleProg.Rows)
{
flag = Convert.ToInt32(rowProg["FLAG"], NumberFormatInfo.CurrentInfo);
if (flag == 2)
{
rowProgUpd = new RoleProgram();
rowProgUpd.ROLE_ID = rowProg["ROLE_ID"].ToString();
rowProgUpd.PROG_ID = rowProg["PROG_ID"].ToString();
rowProgUpd.REC_STAT = (bool)rowProg["REC_STAT"];
lstRowProgUpd.Add(rowProgUpd);
}
}
}
using (AdministratorBLL adminBll = new AdministratorBLL())
{
result = adminBll.UpdateRole(role, userid);
if (lstRowProgUpd != null)
{
adminBll.UpdateRoleProgram(lstRowProgUpd, userid);
}
}
if (result.Equals("OK"))
{
NotifierResult.Show("Update Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
this.GetRoleList();
this.FormState = eFormState.ReadOnly;
this.dntRole.Position = this.positionIndex;
this.btnAddNew.Visible = true;
this.btnExit.Visible = true;
//Reload Menu
if (lstRowProgUpd != null)
{
((frmMainMenu)this.ParentForm).ReloadMenu();
}
}
}
private void InsertMachine()
{
string result = string.Empty;
try
{
this.Cursor = Cursors.WaitCursor;
MaterialType mtlType = new MaterialType();
mtlType.SEQ_NO = this.txtSEQ_NO.Text;
mtlType.NAME = this.txtNAME.Text;
mtlType.REMARK = this.txtREMARK.Text;
mtlType.REC_STAT = (bool)this.icbREC_STAT.EditValue;
using (MaterialTypeBLL mtlTypeBll = new MaterialTypeBLL())
{
result = mtlTypeBll.InsertMTLType(mtlType, ((frmMainMenu)this.ParentForm).UserID);
}
if (result.Equals("OK"))
{
NotifierResult.Show("Insert Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
NotifierResult.Show(ex.Message, "Error", 100, 1000, 0, NotifyType.Warning);
}
finally
{
this.Cursor = Cursors.Default;
this.FormState = eFormState.ReadOnly;
this.GetMTLTypeList(string.Empty);
if (result.Equals("OK"))
{
GridView viewList = (GridView)this.grdMTLType.Views[0];
viewList.ClearSorting();
int position = UiUtility.GetRowHandleByColumnValue(viewList, "SEQ_NO", this.txtSEQ_NO.Text);
if (position != 0)
{
if (position != GridControl.InvalidRowHandle)
{
this.dntMaterial.Position = position;
}
}
else
{
viewList.FocusedRowHandle = 0;
}
}
}
}
private void UpdateProgram()
{
string result = string.Empty;
try
{
M_Program program = new M_Program();
program.PROG_ID = (string)this.txtPROG_ID.EditValue;
program.PROG_NAME = (string)UiUtility.IsNullValue(this.txtPROG_NAME.EditValue, "");
program.PROG_KEY = (string)UiUtility.IsNullValue(this.txtPROG_KEY.EditValue, "");
program.PROG_TYPE = (string)this.luePROG_TYPE.EditValue;
if (this.txtORDER_BY.EditValue != null)
{
program.ORDER_BY = (int)this.txtORDER_BY.EditValue;
}
program.ICON = (string)UiUtility.IsNullValue(this.txtICON.EditValue, "");
program.DESCRIPTION = (string)UiUtility.IsNullValue(this.txtDESCRIPTION.EditValue, "");
program.REC_STAT = (bool)this.icbREC_STAT.EditValue;
using (AdministratorBLL adminBll = new AdministratorBLL())
{
result = adminBll.UpdateProgram(program, ((frmMainMenu)this.ParentForm).UserID);
}
if (result.Equals("OK"))
{
GridView view = (GridView)this.grdProgramList.Views[0];
view.BeginDataUpdate();
view.SetFocusedRowCellValue("PROG_ID", program.PROG_ID);
view.SetFocusedRowCellValue("PROG_NAME", program.PROG_NAME);
view.SetFocusedRowCellValue("PROG_TYPE", program.PROG_TYPE);
view.SetFocusedRowCellValue("ORDER_BY", program.ORDER_BY);
view.SetFocusedRowCellValue("REC_STAT", program.REC_STAT);
view.EndDataUpdate();
NotifierResult.Show("Update Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
NotifierResult.Show(ex.Message, "Error", 50, 1000, 0, NotifyType.Warning);
}
finally
{
this.FormState = eFormState.ReadOnly;
//Get all Invoice on Invoice List
this.lueProgramType.EditValue = this.luePROG_TYPE.EditValue;
this.GetProgramList(this.lueProgramType.EditValue.ToString(), string.Empty);
if (result.Equals("OK"))
{
GridView viewList = (GridView)this.grdProgramList.Views[0];
viewList.ClearSorting();
int position = UiUtility.GetRowHandleByColumnValue(viewList, "PROG_ID", this.txtPROG_ID.Text);
if (position != 0)
{
if (position != GridControl.InvalidRowHandle)
{
this.dntProgram.Position = position;
}
}
else
{
viewList.FocusedRowHandle = 0;
}
//Reload Menu
((frmMainMenu)this.ParentForm).ReloadMenu();
}
}
}
public void UpdateParty()
{
string result = string.Empty;
Party party = null;
try
{
this.Cursor = Cursors.WaitCursor;
party = new Party();
party.PARTY_ID = this.txtPARTY_ID.Text;
party.PARTY_NAME = this.txtPARTY_NAME.Text;
party.PARTY_TYPE = (string)this.icbPARTY_TYPE.EditValue;
party.ADD1 = this.txtADD1.Text;
party.ADD2 = this.txtADD2.Text;
party.ADD3 = this.txtADD3.Text;
party.ADD4 = this.txtADD4.Text;
party.TEL = this.txtTEL.Text;
party.FAX = this.txtFAX.Text;
party.EMAIL = this.txtEMAIL.Text;
party.PIC = this.txtPIC.Text;
party.REMARK = this.txtREMARK.Text;
party.REC_STAT = (bool)this.icbREC_STAT.EditValue;
using (PartyBLL partyBll = new PartyBLL())
{
result = partyBll.UpdateParty(party, ((frmMainMenu)this.ParentForm).UserID);
}
if (result.Equals("OK"))
{
this.UpdatePartyProductList_Bulk();
GridView view = (GridView)this.grdParty.Views[0];
view.BeginDataUpdate();
view.SetFocusedRowCellValue("PARTY_ID", party.PARTY_ID);
view.SetFocusedRowCellValue("PARTY_NAME", party.PARTY_NAME);
view.SetFocusedRowCellValue("PARTY_TYPE", party.PARTY_TYPE);
view.SetFocusedRowCellValue("TEL", party.TEL);
view.SetFocusedRowCellValue("FAX", party.FAX);
view.SetFocusedRowCellValue("EMAIL", party.EMAIL);
view.SetFocusedRowCellValue("REC_STAT", party.REC_STAT);
view.EndDataUpdate();
NotifierResult.Show("Update Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
NotifierResult.Show(ex.Message, "Error", 100, 1000, 0, NotifyType.Warning);
}
finally
{
this.Cursor = Cursors.Default;
this.FormState = eFormState.ReadOnly;
}
}
public void UpdateLoadingOrder()
{
string result = string.Empty;
LoadingOrder loadingOrd = new LoadingOrder();
try
{
#region "Loading Order Header"
loadingOrd.LOADING_NO = this.txtLOADING_NO.Text;
loadingOrd.LOADING_DATE = Convert.ToDateTime(this.txtLOADING_DATE.EditValue, DateTimeFormatInfo.CurrentInfo);
loadingOrd.WH_ID = this.lueWarehouse.EditValue.ToString();
loadingOrd.TRUCK_NO = this.txtTRUCK_NO.Text;
loadingOrd.CONTAINER_NO = this.txtCONTAINER_NO.Text;
loadingOrd.DELIVERY_DATE = this.dtpDELIVERY_DATE.DateTime;
loadingOrd.REMARK = this.txtREMARK.Text;
loadingOrd.REC_STAT = (bool)this.icbREC_STAT.EditValue;
#endregion
using (LoadingOrderBLL loadingOrdBll = new LoadingOrderBLL())
{
result = loadingOrdBll.UpdateLoadingOrder(loadingOrd, ((frmMainMenu)this.ParentForm).UserID);
}
if (result.Equals("OK"))
{
NotifierResult.Show("Update Complete", "Result", 50, 1000, 50, NotifyType.Safe);
}
else
{
NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning);
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
NotifierResult.Show(ex.Message, "Error", 100, 1000, 0, NotifyType.Warning);
}
finally
{
this.FormState = eFormState.ReadOnly;
//Get all Invoice on Invoice List
//this.GetLoadingOrderList(this.txtSearch.Text, this.dteFromDate.DateTime, this.dteToDate.DateTime);
//if (result.Equals("OK"))
//{
// GridView viewList = (GridView)this.grdLoadingOrder.Views[0];
// int position = UiUtility.GetRowHandleByColumnValue(viewList, "LOADING_NO", loadingOrd.LOADING_NO);
// if (position != 0)
// {
// if (position != GridControl.InvalidRowHandle)
// {
// this.dntLoadingOrder.Position = position;
// }
// }
// else
// {
// viewList.FocusedRowHandle = 0;
// }
//}
this.Cursor = Cursors.Default;
}
}
