//To CheckDuplicate Sport
#region [Check Duplicate Sport]
public int CheckDuplicateSport_DL(EWA_SportMaster objEWA)
{
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "CheckData";
prmList[2] = "@SportName";
prmList[3] = objEWA.SportName;
DataSet dsData = ObjHelper.FillControl(prmList, "SP_SportMaster");
if (dsData.Tables[0].Rows.Count > 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception exp)
{
throw exp;
}
}
//Check Duplicate for sport
#region [Check Duplicate sport]
public int CheckDuplicateSport_BL(EWA_SportMaster objEWA)
{
try
{
DL_SportMaster objDL = new DL_SportMaster();
int i = objDL.CheckDuplicateSport_DL(objEWA);
return(i);
}
catch (Exception)
{
throw;
}
}
//ActionPerformed For Sport
#region [ActionPerformed For Department]
public int SportAction_BL(EWA_SportMaster objEWA)
{
// DL_Documents objDL = new DL_Documents();
try
{
DL_SportMaster objDL = new DL_SportMaster();
int flag = objDL.SportAction_DL(objEWA);
return(flag);
}
catch (Exception)
{
throw;
}
}
//Check Existing Data
#region [Check Data]
private int CheckData()
{
int i = 0;
try
{
EWA_SportMaster objEWA = new EWA_SportMaster();
objEWA.SportName = txtSportName.Text.Trim();
i = objBL.CheckDuplicateSport_BL(objEWA);
return(i);
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
return(i);
}
//To Perform Insert,Update,Delete and Search Actions On Document Table
#region [Perform Actions On Sport]
public int SportAction_DL(EWA_SportMaster objEWA)
{
try
{
cmd = new SqlCommand("SP_SportMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", objEWA.Action);
cmd.Parameters.AddWithValue("@SportId", objEWA.SportId);
cmd.Parameters.AddWithValue("@SportName", objEWA.SportName);
cmd.Parameters.AddWithValue("@UserId", objEWA.UserId);
cmd.Parameters.AddWithValue("@IsActive", objEWA.IsActive);
con.Open();
int flag = cmd.ExecuteNonQuery();
con.Close();
cmd.Dispose();
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();
}
}
