private void SetValues(String sm_Agent) { try { M_AgentDL objm_AgentDL = new M_AgentDL(); M_Agents objm_Agent = new M_Agents(); if (sm_Agent != "") { objm_Agent.AgentCode = sm_Agent; objm_Agent = objm_AgentDL.Selectm_Agent(objm_Agent); if (objm_Agent != null) { txt_AgentCode.Text = objm_Agent.AgentCode.ToString(); txt_Namex.Text = objm_Agent.Namex.ToString(); txt_Address1.Text = objm_Agent.Address1.ToString(); txt_Address2.Text = objm_Agent.Address2.ToString(); txt_Address3.Text = objm_Agent.Address3.ToString(); txt_TPOffice.Text = objm_Agent.TPOffice.ToString(); txt_TPPersonal.Text = objm_Agent.TPPersonal.ToString(); txt_Fax.Text = objm_Agent.Fax.ToString(); txt_Email.Text = objm_Agent.Email.ToString(); txt_AccNo.Text = objm_Agent.AccNo.ToString(); txt_NICno.Text = objm_Agent.NICno.ToString(); txt_PassportNo.Text = objm_Agent.PassportNo.ToString(); txt_remarks.Text = objm_Agent.Remarks; txt_AreaCode.Text = objm_Agent.District; formMode = 0; } } } catch (Exception ex) { throw ex; } }
public M_Agents Selectm_Agent(M_Agents objm_Agent) { try { strquery = @"select * from M_Agents where AgentCode = '" + objm_Agent.AgentCode + "'"; DataRow drType = u_DBConnection.ReturnDataRow(strquery); if (drType != null) { objm_Agent.AgentCode = drType["AgentCode"].ToString(); objm_Agent.Namex = drType["Namex"].ToString(); objm_Agent.Address1 = drType["Address1"].ToString(); objm_Agent.Address2 = drType["Address2"].ToString(); objm_Agent.Address3 = drType["Address3"].ToString(); objm_Agent.TPOffice = drType["TPOffice"].ToString(); objm_Agent.TPPersonal = drType["TPPersonal"].ToString(); objm_Agent.Fax = drType["Fax"].ToString(); objm_Agent.Email = drType["Email"].ToString(); objm_Agent.AccNo = drType["AccNo"].ToString(); objm_Agent.NICno = drType["NICno"].ToString(); objm_Agent.PassportNo = drType["PassportNo"].ToString(); objm_Agent.Datex = DateTime.Parse(drType["Datex"].ToString()); objm_Agent.userx = drType["userx"].ToString(); objm_Agent.TimeFrom = DateTime.Parse(drType["TimeFrom"].ToString()); objm_Agent.TimeTo = DateTime.Parse(drType["TimeTo"].ToString()); objm_Agent.District = drType["District"].ToString(); objm_Agent.Remarks = drType["Remarks"].ToString(); return(objm_Agent); } return(null); } catch (Exception ex) { throw ex; } }
public static string FindExisitingAgent(string suppcode) { string str = ""; if (M_AgentDL.ExistingM_Agent(suppcode.Trim())) { M_Agents cat = new M_Agents(); cat.AgentCode = suppcode.Trim(); M_AgentDL dl = new M_AgentDL(); cat = dl.Selectm_Agent(cat); str = cat.Namex.Trim(); } else { str = "<Error!!!>"; } return(str); }
/// <summary> /// Saves a record to the M_Agents table. /// </summary> public Boolean SaveM_AgentSP(M_Agents m_Agent, int formMode) { SqlCommand scom; bool retvalue = false; try { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "M_AgentsSave"; scom.Parameters.Add("@AgentCode", SqlDbType.VarChar, 20).Value = m_Agent.AgentCode; scom.Parameters.Add("@Namex", SqlDbType.VarChar, 50).Value = m_Agent.Namex; scom.Parameters.Add("@Address1", SqlDbType.VarChar, 150).Value = m_Agent.Address1; scom.Parameters.Add("@Address2", SqlDbType.VarChar, 150).Value = m_Agent.Address2; scom.Parameters.Add("@Address3", SqlDbType.VarChar, 150).Value = m_Agent.Address3; scom.Parameters.Add("@TPOffice", SqlDbType.VarChar, 50).Value = m_Agent.TPOffice; scom.Parameters.Add("@TPPersonal", SqlDbType.VarChar, 50).Value = m_Agent.TPPersonal; scom.Parameters.Add("@Fax", SqlDbType.VarChar, 50).Value = m_Agent.Fax; scom.Parameters.Add("@Email", SqlDbType.VarChar, 20).Value = m_Agent.Email; scom.Parameters.Add("@AccNo", SqlDbType.VarChar, 20).Value = m_Agent.AccNo; scom.Parameters.Add("@NICno", SqlDbType.VarChar, 20).Value = m_Agent.NICno; scom.Parameters.Add("@PassportNo", SqlDbType.VarChar, 20).Value = m_Agent.PassportNo; scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = m_Agent.Datex; scom.Parameters.Add("@userx", SqlDbType.VarChar, 20).Value = m_Agent.userx; scom.Parameters.Add("@TimeFrom", SqlDbType.DateTime, 8).Value = m_Agent.TimeFrom; scom.Parameters.Add("@TimeTo", SqlDbType.DateTime, 8).Value = m_Agent.TimeTo; scom.Parameters.Add("@District", SqlDbType.VarChar, 20).Value = m_Agent.District; scom.Parameters.Add("@Remarks", SqlDbType.VarChar, 150).Value = m_Agent.Remarks; 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 performButtons(xEnums.PerformanceType xenum) { switch (xenum) { case xEnums.PerformanceType.View: if (ActiveControl.Name.Trim() == txt_AgentCode.Name.Trim()) { int length = Convert.ToInt32(ConfigurationManager.AppSettings["AgentFieldLength"]); string[] strSearchField = new string[length]; string strSQL = ConfigurationManager.AppSettings["AgentSQL"].ToString(); for (int i = 0; i < length; i++) { string m; m = i.ToString(); strSearchField[i] = ConfigurationManager.AppSettings["AgentField" + 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_AgentCode.Focus(); errorProvider1.Clear(); break; case xEnums.PerformanceType.Edit: FunctionButtonStatus(xEnums.PerformanceType.Edit); formMode = 3; txt_AgentCode.Enabled = false; txt_Namex.Focus(); errorProvider1.Clear(); break; case xEnums.PerformanceType.Save: errorProvider1.Clear(); try { if (txt_Namex.Text.Trim() == "") { errorProvider1.SetError(txt_Namex, "Please enter a agent name !"); return; } if (txt_AgentCode.Text.Trim() == "") { errorProvider1.SetError(txt_AgentCode, "Please enter a Agent Code !"); return; } if (formMode == 1) { if (M_AgentDL.ExistingM_Agent(txt_AgentCode.Text.Trim())) { errorProvider1.SetError(txt_AgentCode, "The agent code you have entered already exists!"); return; } 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_Agents objm_Agent = new M_Agents(); objm_Agent.AgentCode = txt_AgentCode.Text.Trim(); objm_Agent.Namex = txt_Namex.Text.Trim(); objm_Agent.Address1 = txt_Address1.Text.Trim(); objm_Agent.Address2 = txt_Address2.Text.Trim(); objm_Agent.Address3 = txt_Address3.Text.Trim(); objm_Agent.TPOffice = txt_TPOffice.Text.Trim(); objm_Agent.TPPersonal = txt_TPPersonal.Text.Trim(); objm_Agent.Fax = txt_Fax.Text.Trim(); objm_Agent.Email = txt_Email.Text.Trim(); objm_Agent.AccNo = txt_AccNo.Text.Trim(); objm_Agent.NICno = txt_NICno.Text.Trim(); objm_Agent.PassportNo = txt_PassportNo.Text.Trim(); objm_Agent.Datex = DateTime.Now; // txt_Datex.Text.Trim(); objm_Agent.userx = commonFunctions.Loginuser; // txt_userx.Text.Trim(); objm_Agent.TimeFrom = dte_from.Value; objm_Agent.TimeTo = dte_to.Value; objm_Agent.District = txt_AreaCode.Text; objm_Agent.Remarks = txt_remarks.Text; M_AgentDL bal = new M_AgentDL(); bal.SaveM_AgentSP(objm_Agent, 1); GetData(); txt_AgentCode.Enabled = true; FunctionButtonStatus(xEnums.PerformanceType.Save); commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2); } } else if (formMode == 3) { if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes) { M_Agents objm_Agent = new M_Agents(); objm_Agent.AgentCode = txt_AgentCode.Text.Trim(); objm_Agent = new M_AgentDL().Selectm_Agent(objm_Agent); objm_Agent.Namex = txt_Namex.Text.Trim(); objm_Agent.Address1 = txt_Address1.Text.Trim(); objm_Agent.Address2 = txt_Address2.Text.Trim(); objm_Agent.Address3 = txt_Address3.Text.Trim(); objm_Agent.TPOffice = txt_TPOffice.Text.Trim(); objm_Agent.TPPersonal = txt_TPPersonal.Text.Trim(); objm_Agent.Fax = txt_Fax.Text.Trim(); objm_Agent.Email = txt_Email.Text.Trim(); objm_Agent.AccNo = txt_AccNo.Text.Trim(); objm_Agent.NICno = txt_NICno.Text.Trim(); objm_Agent.PassportNo = txt_PassportNo.Text.Trim(); objm_Agent.Datex = DateTime.Now; // txt_Datex.Text.Trim(); objm_Agent.userx = commonFunctions.Loginuser; // txt_userx.Text.Trim(); objm_Agent.TimeFrom = dte_from.Value; objm_Agent.TimeTo = dte_to.Value; objm_Agent.District = txt_AreaCode.Text; objm_Agent.Remarks = txt_remarks.Text; M_AgentDL bal = new M_AgentDL(); bal.SaveM_AgentSP(objm_Agent, 3); GetData(); txt_AgentCode.Enabled = true; FunctionButtonStatus(xEnums.PerformanceType.Save); commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Update_Sucess_string, 2); } } } 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_AgentCode.Enabled = true; FunctionButtonStatus(xEnums.PerformanceType.Default); errorProvider1.Clear(); break; case xEnums.PerformanceType.Print: UserDefineMessages.ShowMsg1("Print still in process", UserDefineMessages.Msg_Information); break; } }