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