public bool InsertAcademicClassSection(ACD_ClassSection classSection)
{
string sql = " Insert into ACD_ClassSection (BatchId,ClassId,SectionId,StartDate,StartDateBS,EnteredBy, EnteredDate,LastUpdatedBy,LastUpdatedDate,IsDeleted,DeletedBy,DeletedDate) " +
" values " +
"(@BatchId,@ClassId,@SectionId,@StartDate,@StartDateBS,@EnteredBy, @EnteredDate,0,null,0,0,null)";
using (var db = DbHelper.GetDBConnection())
{
using (var trsn = new TransactionScope())
{
//db.Execute(sql);
var lst = db.Execute(sql, classSection);
trsn.Complete();
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
// GET: AcademicClassSection/Edit/5
public ActionResult Edit(int?id)
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
if (id == null || id == 0)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ACD_ClassSection obj = db.GetAcademicClassSectionById((int)id);
if (obj == null)
{
return(HttpNotFound());
}
ViewBag.ClassId = new SelectList(ddl.GetClassList(orgid), "Id", "Name", obj.ClassId);
ViewBag.SectionId = new SelectList(ddl.GetSectionList(orgid), "Id", "Name", obj.SectionId);
ViewBag.BatchId = new SelectList(ddl.GetBatchList(orgid), "Id", "Name", obj.BatchId);
return(View(obj));
}
public ActionResult Edit(FormCollection frm)
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
ACD_ClassSection obj = db.GetAcademicClassSectionById(Convert.ToInt32(frm["ClassSectionId"]));
obj.BatchId = Convert.ToInt32(frm["BatchId"]);
obj.ClassId = Convert.ToInt32(frm["ClassId"]);
obj.SectionId = Convert.ToInt32(frm["SectionId"]);
obj.StartDate = DateTime.ParseExact(frm["StartDate"], "yyyy-MM-dd", null);
obj.StartDateBS = frm["StartDateBS"];
obj.LastUpdatedBy = (User as CustomPrincipal).UserId;
obj.LastUpdatedDate = DateTime.Now;
if (ModelState.IsValid)
{
db.UpdateAcademicClassSection(obj);
return(RedirectToAction("Index"));
}
ViewBag.ClassId = new SelectList(ddl.GetClassList(orgid), "Id", "Name", obj.ClassId);
ViewBag.SectionId = new SelectList(ddl.GetSectionList(orgid), "Id", "Name", obj.SectionId);
ViewBag.BatchId = new SelectList(ddl.GetBatchList(orgid), "Id", "Name", obj.BatchId);
return(View(obj));
}
public bool UpdateAcademicStudentClassSection(ACD_ClassSection classSection)
{
string sql = " Update ACD_StudentClassSection set StudentId=@StudentId,ClassId=@ClassId,SectionId=@SectionId,AcademicYear=@AcademicYear,AssignedDate=@AssignedDate,AssignedDateBS=@AssignedDateBS,LastUpdatedBy=@LastUpdatedBy,LastUpdatedDate=@LastUpdatedDate" +
" where StudentClassSectionId=@StudentClassSectionId";
using (var db = DbHelper.GetDBConnection())
{
using (var trsn = new TransactionScope())
{
//db.Execute(sql);
var lst = db.Execute(sql, classSection);
trsn.Complete();
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
