public bool UpdateAcademicClass(ACD_Class aclass)
{
string sql = " Update ACD_Class set ClassName=@ClassName, ClassCode=@ClassCode, " +
" OrganizationId=@OrganizationId, " +
" EnteredBy=@EnteredBy, EnteredDate=@EnteredDate,LastUpdatedBy=@LastUpdatedBy, " +
" LastUpdatedDate=@LastUpdatedDate, IsDeleted=0, DeletedBy=0, DeletedDate=null" +
" where ClassId=@ClassId";
using (var db = DbHelper.GetDBConnection())
{
using (var trsn = new TransactionScope())
{
//db.Execute(sql);
var lst = db.Execute(sql, aclass);
trsn.Complete();
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
//public ACD_Class GetAcademicClassById(int classId)
//{
// string sql = " Select * from ACD_Class where ClassId=" + classId;
// using (var db = DbHelper.GetDBConnection())
// {
// var lst = db.Query<ACD_Class>(sql).SingleOrDefault();
// db.Close();
// return lst;
// }
//}
public bool InsertAcademicClass(ACD_Class aclass)
{
string sql = " Insert into ACD_Class (ClassName, ClassCode,OrganizationId, EnteredBy, EnteredDate," +
" LastUpdatedBy, LastUpdatedDate, IsDeleted, DeletedBy, DeletedDate) " +
" values " +
"(@ClassName, @ClassCode,@OrganizationId, @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, aclass);
trsn.Complete();
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
// GET: AcademicClass/Details/5
public ActionResult Details(int?id)
{
if (id == null || id == 0)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ACD_Class aCD_Class = db.GetAcademicClassById((int)id);
if (aCD_Class == null)
{
return(HttpNotFound());
}
ViewBag.OrganizationId = new SelectList(ddl.GetOrganizationList(), "Id", "Name", aCD_Class.OrganizationId);
return(View(aCD_Class));
}
public ActionResult Edit(FormCollection frm)
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
ACD_Class aCD_Class = db.GetAcademicClassById(Convert.ToInt32(frm["ClassId"]));
aCD_Class.ClassCode = frm["ClassCode"];
aCD_Class.ClassName = frm["ClassName"];
aCD_Class.OrganizationId = orgid;// Convert.ToInt32(frm["OrganizationId"]);
aCD_Class.LastUpdatedBy = (User as CustomPrincipal).UserId;
aCD_Class.LastUpdatedDate = DateTime.Now;
if (ModelState.IsValid)
{
db.UpdateAcademicClass(aCD_Class);
return(RedirectToAction("Index"));
}
ViewBag.OrganizationId = new SelectList(ddl.GetOrganizationList(), "Id", "Name", aCD_Class.OrganizationId);
return(View(aCD_Class));
}
public ActionResult Create(FormCollection frm)
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
string fclassname = frm["ClassName"];
string fclasscode = frm["ClassCode"];
string cn = null, cb = null;
int isdelete = 0;
ACD_Class classNameBatch = db.GetClassNameCode(fclassname, fclasscode, isdelete);
ACD_Class aCD_Class = new ACD_Class();
if (classNameBatch == null)
{
aCD_Class.ClassCode = frm["ClassCode"];
aCD_Class.ClassName = frm["ClassName"];
aCD_Class.OrganizationId = orgid;// Convert.ToInt32(frm["OrganizationId"]);
aCD_Class.EnteredBy = (User as CustomPrincipal).UserId;
aCD_Class.EnteredDate = DateTime.Now;
if (ModelState.IsValid)
{
db.InsertAcademicClass(aCD_Class);
return(RedirectToAction("Index"));
}
}
else
{
if (classNameBatch.IsDeleted == false)
{
cn = classNameBatch.ClassName;
cb = classNameBatch.ClassCode;
if (cn == fclassname)
{
ViewBag.CNMsg = "Already Exist..";
}
if (cb == fclasscode)
{
ViewBag.CBMsg = "Already Exist..";
}
else
{
aCD_Class.ClassCode = frm["ClassCode"];
aCD_Class.ClassName = frm["ClassName"];
aCD_Class.OrganizationId = orgid;// Convert.ToInt32(frm["OrganizationId"]);
aCD_Class.EnteredBy = (User as CustomPrincipal).UserId;
aCD_Class.EnteredDate = DateTime.Now;
if (ModelState.IsValid)
{
db.InsertAcademicClass(aCD_Class);
return(RedirectToAction("Index"));
}
}
}
else
{
aCD_Class.ClassCode = frm["ClassCode"];
aCD_Class.ClassName = frm["ClassName"];
aCD_Class.OrganizationId = orgid;// Convert.ToInt32(frm["OrganizationId"]);
aCD_Class.EnteredBy = (User as CustomPrincipal).UserId;
aCD_Class.EnteredDate = DateTime.Now;
if (ModelState.IsValid)
{
db.InsertAcademicClass(aCD_Class);
return(RedirectToAction("Index"));
}
}
}
ViewBag.OrganizationId = new SelectList(ddl.GetOrganizationList(), "Id", "Name", aCD_Class.OrganizationId);
return(View(aCD_Class));
}
