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;
}
}
}
}
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;
}
}
}
}
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;
}
}
}
}
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;
}
}
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 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;
}
}
}
}
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 InsertProduct()
{
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;
prod.PROD_IMAGE = (Bitmap)this.picPROD_IMAGE.Image;
prod.REMARK = this.txtREMARK.Text;
prod.REC_STAT = (bool)this.icbREC_STAT.EditValue;
//add new insert 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.InsertProduct(ref prod, userid);
if (lstProdProcess != null)
{
prodBll.UpdateProductionProcess(lstProdProcess, 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.GetProductList(string.Empty);
if (result.Equals("OK"))
{
GridView viewList = (GridView)this.grdProduct.Views[0];
viewList.ClearSorting();
int position = UiUtility.GetRowHandleByColumnValue(viewList, "PROD_SEQ_NO", prod.PROD_SEQ_NO);
if (position != 0)
{
if (position != GridControl.InvalidRowHandle)
{
this.dntProduct.Position = position;
}
}
else
{
viewList.FocusedRowHandle = 0;
}
}
}
}
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;
}
}