public int dalcrud1(bgcschedule bgc)
{
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
con.Open();
SqlCommand cmd = new SqlCommand("updatecandidatebgc", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@fromdate", bgc.frmdate);
cmd.Parameters.AddWithValue("@todate", bgc.todate);
cmd.Parameters.AddWithValue("@adminid", bgc.adminid);
return(cmd.ExecuteNonQuery());
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(-2);
}
}
public int balcrud1(bgcschedule bgc)
{
DateTime today = DateTime.Today;
int flag = -1;
try
{
if (Convert.ToDateTime(bgc.frmdate) >= today)
{
if (Convert.ToDateTime(bgc.todate) >= Convert.ToDateTime(bgc.frmdate))
{
flag = 1;
}
}
}
catch (Exception e)
{
flag = -2;
}
if (flag == 1)
{
BgcScheduleDAL dc = new BgcScheduleDAL();
int i = dc.dalcrud1(bgc);
if (i >= 1)
{
flag = i;
}
else if (i == 0)
{
flag = 0;
}
else if (i == -1)
{
flag = -1;
}
else if (i == -2)
{
flag = -2;
}
}
return(flag);
}
