//Bind Student Data
#region [Bind Student Data]
public DataSet DL_BindStudentData(EWA_BatchAllotment objEWABatch)
{
DataSet ds = new DataSet();
try
{
// DateTime dt = DateTime.Parse(objEWA.FromDate);
prmList = new string[12];
prmList[0] = "@Action";
prmList[1] = "FetchStudentData";
prmList[2] = "@OrgId";
prmList[3] = Convert.ToString(objEWABatch.OrgId);
prmList[4] = "@AcademicYearId";
prmList[5] = Convert.ToString(objEWABatch.AcademicYearId);
prmList[6] = "@CourseId";
prmList[7] = Convert.ToString(objEWABatch.CourseId);
prmList[8] = "@BranchId";
prmList[9] = Convert.ToString(objEWABatch.BranchId);
prmList[10] = "@ClassId";
prmList[11] = Convert.ToString(objEWABatch.ClassId);
ds = ObjHelper.FillControl(prmList, "SP_BatchAllotment");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
}
return(ds);
}
catch (Exception)
{
//GeneralErr(exp.Message.ToString());
throw;
}
}
//Set Division
#region [Set Division]
public int DL_SetDivision(EWA_BatchAllotment objEWABatch, DataTable StudentDataTable)
{
try
{
cmd = new SqlCommand("SP_BatchAllotment", con);
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", objEWABatch.Action);
cmd.Parameters.AddWithValue("@DivisionId", objEWABatch.DivisionId);
SqlParameter tblvaluetype = cmd.Parameters.AddWithValue("@StudentDataTable", StudentDataTable); //Passing table value parameter
tblvaluetype.SqlDbType = SqlDbType.Structured;
int flag = cmd.ExecuteNonQuery();
con.Close();
return(flag);
}
catch (Exception)
{
throw;
}
}