// Update
#region Update Data
protected void btnUpdate_Click(object sender, EventArgs e)
{
BL_University objBL = new BL_University();
EWA_University objEWA = new EWA_University();
try
{
string[] confirmValue = Request.Form["confirm_value"].Split(',');
if (confirmValue[confirmValue.Length - 1] == "Yes")
{
lock (this)
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString);
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from [tblUniversity] ";
cmd.Connection = cn;
SqlDataReader rd = cmd.ExecuteReader();
//while (rd.Read())
//{
// if (rd[1].ToString() == txtUniversityName.Text)
// {
// flag = true;
// break;
// }
//}
if (flag == true)
{
msgBox.ShowMessage("Record Already Exist!!!", "Saved", UserControls.MessageBox.MessageStyle.Successfull);
clear();
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Designation Already Exists')", true);
}
else
{
Action("Update");
clear();
btnNew.Visible = true;
btnUpdate.Enabled = false;
btnDelete.Enabled = false;
}
}
}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
//Check Existing Data
#region [Check Data]
private int CheckData()
{
try
{
EWA_University objEWA = new EWA_University();
objEWA.UniversityName = txtUniversityName.Text;
int i = objBL.CheckDuplicateUniversity_BL(objEWA);
return(i);
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
return(0);
}
}
//To Check Duplicate Data Of University
#region [Check Duplicate University]
public int CheckDuplicateUniversity_BL(EWA_University objEWA)
{
try
{
DL_University objDL = new DL_University();
int i = objDL.CheckDuplicateUniversity_DL(objEWA);
return(i);
}
catch (Exception)
{
throw;
}
finally
{
objDL = null;
}
}
//Insert Update Delete operaeion on Document Table
#region [Action Performed]
public int UniversityAction_BL(EWA_University objEWA)
{
// DL_Documents objDL = new DL_Documents();
try
{
DL_University objDL = new DL_University();
int flag = objDL.UniversityAction_DL(objEWA);
return(flag);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDL = null;
}
}
//Save University
#region SaveData
protected void btnSave_Click(object sender, EventArgs e)
{
BL_University objBL = new BL_University();
EWA_University objEWA = new EWA_University();
try
{
lock (this)
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString);
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from [tblUniversity] ";
cmd.Connection = cn;
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
if (rd[1].ToString() == txtUniversityName.Text)
{
flag = true;
break;
}
}
if (flag == true)
{
msgBox.ShowMessage("Record Already Exist!!!", "Saved", UserControls.MessageBox.MessageStyle.Successfull);
clear();
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Designation Already Exists')", true);
}
else
{
Action("Save");
clear();
}
}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
// Delete
#region [Delete University]
protected void btnDelete_Click(object sender, EventArgs e)
{
BL_University objBL = new BL_University();
EWA_University objEWA = new EWA_University();
try
{
string[] confirmValue = Request.Form["confirm_value"].Split(',');
if (confirmValue[confirmValue.Length - 1] == "Yes")
{
lock (this)
{
Action("Delete");
clear();
}
}
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
