//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(); } }