//Check Duplicate University
#region [Check Duplicate University]
public int CheckDuplicateUniversity_DL(EntityWebApp.SuperAdmin.EWA_University objEWA)
{
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "CheckData";
prmList[2] = "@UniversityName";
prmList[3] = objEWA.UniversityName;
DataSet dsData = ObjHelper.FillControl(prmList, "SP_University");
if (dsData.Tables[0].Rows.Count > 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception)
{
//GeneralErr(exp.Message.ToString());
throw;
//return 1;
}
}
//To Perform Insert,Update,Delete and Search Actions On University Table
#region [Perform Actions On University]
public int UniversityAction_DL(EntityWebApp.SuperAdmin.EWA_University objEWA)
{
try
{
cmd = new SqlCommand("SP_University", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", objEWA.Action);
cmd.Parameters.AddWithValue("@UniversityId", objEWA.UniversityId);
cmd.Parameters.AddWithValue("@UniversityName", objEWA.UniversityName);
cmd.Parameters.AddWithValue("@Address", objEWA.Address);
cmd.Parameters.AddWithValue("@Country", objEWA.Country);
cmd.Parameters.AddWithValue("@State", objEWA.State);
cmd.Parameters.AddWithValue("@City", objEWA.City);
cmd.Parameters.AddWithValue("@PinCode", objEWA.PinCode);
cmd.Parameters.AddWithValue("@Email", objEWA.Email);
cmd.Parameters.AddWithValue("@Contact1", objEWA.Contact);
// cmd.Parameters.AddWithValue("@ContactNo2", objEWA.Contact2);
cmd.Parameters.AddWithValue("@FaxNo1", objEWA.FaxNo);
//cmd.Parameters.AddWithValue("@FaxNo2", objEWA.FaxNo2);
cmd.Parameters.AddWithValue("@Logo", objEWA.Logo);
con.Open();
int flag = cmd.ExecuteNonQuery();
con.Close();
return(flag);
}
catch (Exception ex)
{
int err = ((System.Data.SqlClient.SqlException)(ex)).Number;
if (err == 547 && objEWA.Action == "Delete")
{
throw new SystemException("Record is in use !!!");
}
else
{
throw ex;
}
}
finally
{
con.Close();
cmd.Dispose();
}
}
