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;
}
}
