private void SetValues(String sm_Area) { try { M_AreaDL objm_AreaDL = new M_AreaDL(); M_Area objm_Area = new M_Area(); if (sm_Area != "") { objm_Area.AreaCode = sm_Area; objm_Area = objm_AreaDL.Selectm_Area(objm_Area); if (objm_Area != null) { txt_AreaCode.Text = objm_Area.AreaCode.ToString(); //txt_Compcode.Text = "";// objm_Area.Compcode.ToString(); //txt_Locacode.Text = objm_Area.Locacode.ToString(); txt_Descri.Text = objm_Area.Descri.ToString(); //txt_Datex.Text = objm_Area.Datex.ToString(); //txt_Userx.Text = objm_Area.Userx.ToString(); formMode = 3; } } } catch (Exception ex) { throw ex; } }
/// <summary> /// Saves a record to the M_Area table. /// </summary> public Boolean SaveM_AreaSP(M_Area m_Area, int formMode) { SqlCommand scom; bool retvalue = false; try { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "M_AreaSave"; scom.Parameters.Add("@AreaCode", SqlDbType.VarChar, 20).Value = m_Area.AreaCode; scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 50).Value = m_Area.Compcode; scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 50).Value = m_Area.Locacode; scom.Parameters.Add("@Descri", SqlDbType.VarChar, 120).Value = m_Area.Descri; scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = m_Area.Datex; scom.Parameters.Add("@Userx", SqlDbType.VarChar, 20).Value = m_Area.Userx; scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0; u_DBConnection dbcon = new u_DBConnection(); retvalue = dbcon.RunQuery(scom); return(retvalue); } catch (Exception ex) { throw (ex); } }
private void button1_Click(object sender, EventArgs e) { if (txt_AreaCode.Text.Trim() != "" && txt_Areaname.Text.Trim() != "") { if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes) { if (M_AreaDL.ExistingM_Area(txt_AreaCode.Text.Trim())) { M_Area cat = new M_Area(); cat.AreaCode = txt_AreaCode.Text.Trim(); M_AreaDL dl = new M_AreaDL(); cat = dl.Selectm_Area(cat); txt_AreaCode.Text = cat.AreaCode.Trim(); txt_Areaname.Text = cat.Descri; } else { M_Area objm_Category = new M_Area(); objm_Category.AreaCode = txt_AreaCode.Text.Trim(); objm_Category.Descri = txt_Areaname.Text.Trim(); objm_Category.Datex = DateTime.Now; objm_Category.Locacode = ""; objm_Category.Userx = commonFunctions.Loginuser; objm_Category.Compcode = commonFunctions.GlobalCompany; objm_Category.Userx = commonFunctions.Loginuser; M_AreaDL bal = new M_AreaDL(); bal.SaveM_AreaSP(objm_Category, 1); } } } }
private void FindExisitingCategory() { if (M_AreaDL.ExistingM_Area(txt_AreaCode.Text.Trim())) { M_Area cat = new M_Area(); cat.AreaCode = txt_AreaCode.Text.Trim(); M_AreaDL dl = new M_AreaDL(); cat = dl.Selectm_Area(cat); txt_AreaCode.Text = cat.AreaCode.Trim(); txt_Areaname.Text = cat.Descri; } else { txt_Areaname.Text = "<Area Not Exists.>"; } }
public M_Area Selectm_Area(M_Area objm_Area) { try { strquery = @"select * from M_Area where AreaCode = '" + objm_Area.AreaCode + "'"; DataRow drType = u_DBConnection.ReturnDataRow(strquery); if (drType != null) { objm_Area.AreaCode = drType["AreaCode"].ToString(); objm_Area.Compcode = drType["Compcode"].ToString(); objm_Area.Locacode = drType["Locacode"].ToString(); objm_Area.Descri = drType["Descri"].ToString(); objm_Area.Datex = DateTime.Parse(drType["Datex"].ToString()); objm_Area.Userx = drType["Userx"].ToString(); return(objm_Area); } return(null); } catch (Exception ex) { throw ex; } }
private void performButtons(xEnums.PerformanceType xenum) { switch (xenum) { case xEnums.PerformanceType.View: if (ActiveControl.Name.Trim() == txt_AreaCode.Name.Trim()) { int length = Convert.ToInt32(ConfigurationManager.AppSettings["AreaFieldLength"]); string[] strSearchField = new string[length]; string strSQL = ConfigurationManager.AppSettings["AreaSQL"].ToString(); for (int i = 0; i < length; i++) { string m; m = i.ToString(); strSearchField[i] = ConfigurationManager.AppSettings["AreaField" + m + ""].ToString(); } frmU_Search find = new frmU_Search(strSQL, strSearchField, this); find.ShowDialog(this); } break; case xEnums.PerformanceType.New: FunctionButtonStatus(xEnums.PerformanceType.New); formMode = 1; txt_AreaCode.Focus(); errorProvider1.Clear(); break; case xEnums.PerformanceType.Edit: FunctionButtonStatus(xEnums.PerformanceType.Edit); formMode = 3; txt_AreaCode.Enabled = false; txt_Descri.Focus(); errorProvider1.Clear(); break; case xEnums.PerformanceType.Save: try { if (txt_AreaCode.Text.Trim() == "") { errorProvider1.SetError(txt_AreaCode, "Please enter a area Code !"); return; } if (txt_Descri.Text.Trim() == "") { errorProvider1.SetError(txt_Descri, "Please enter a area name !"); return; } if (formMode == 1) { if (M_AreaDL.ExistingM_Area(txt_AreaCode.Text.Trim())) { errorProvider1.SetError(txt_AreaCode, "The area code you have entered already exists!"); return; } if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes) { M_Area objm_Area = new M_Area(); objm_Area.AreaCode = txt_AreaCode.Text.Trim(); objm_Area.Compcode = commonFunctions.GlobalCompany; // txt_Compcode.Text.Trim(); objm_Area.Locacode = commonFunctions.GlobalLocation; // txt_Locacode.Text.Trim(); objm_Area.Descri = txt_Descri.Text.Trim(); objm_Area.Datex = DateTime.Now; //txt_Datex.Text.Trim(); objm_Area.Userx = commonFunctions.Loginuser; // txt_Userx.Text.Trim(); M_AreaDL bal = new M_AreaDL(); bal.SaveM_AreaSP(objm_Area, 1); GetData(); txt_AreaCode.Enabled = true; FunctionButtonStatus(xEnums.PerformanceType.Save); UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Save_Sucess, commonFunctions.Softwarename.Trim()); } } else if (formMode == 3) { if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes) { M_Area objm_Area = new M_Area(); objm_Area.AreaCode = txt_AreaCode.Text.Trim(); objm_Area.Compcode = commonFunctions.GlobalCompany; // txt_Compcode.Text.Trim(); objm_Area.Locacode = commonFunctions.GlobalLocation; // txt_Locacode.Text.Trim(); objm_Area.Descri = txt_Descri.Text.Trim(); objm_Area.Datex = DateTime.Now; //txt_Datex.Text.Trim(); objm_Area.Userx = commonFunctions.Loginuser; // txt_Userx.Text.Trim(); M_AreaDL bal = new M_AreaDL(); bal.SaveM_AreaSP(objm_Area, 3); GetData(); txt_AreaCode.Enabled = true; FunctionButtonStatus(xEnums.PerformanceType.Save); UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Update_Sucess, commonFunctions.Softwarename.Trim()); } } } catch (Exception ex) { LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception"); commonFunctions.SetMDIStatusMessage("Genaral Error on updating data", 1); } break; case xEnums.PerformanceType.Cancel: txt_AreaCode.Enabled = true; FunctionButtonStatus(xEnums.PerformanceType.Default); errorProvider1.Clear(); break; case xEnums.PerformanceType.Print: UserDefineMessages.ShowMsg1("Print still in process", UserDefineMessages.Msg_Information); break; } }