public BatchQuizMap EditBatchQuizMapping(BatchQuizMap obj)
{
using (var db = ObjectFactory.CreateDbContext(commonService.GetCompanyDbFilePath(this.company)))
{
obj = db.GetQueryData <BatchQuizMap>(SQL.UpdateBatchQuizMap + "; " + SQL.SelectBatchQuizMapByID, obj).FirstOrDefault();
}
return(obj);
}
public ActionResult edit(BatchQuizMap obj)
{
obj.CompanyID = this.Company.ToLower();
obj.ModificationDate = Utility.GetCurrentDateInt();
obj.ModificationTime = Utility.GetCurrentTimeInt();
obj.ModifiedBy = LoggedUserID;
_db.EditBatchQuizMapping(obj);
return(RedirectToAction("index"));
}
public BatchQuizMap GetBatchQuizMapping(string id)
{
var data = new BatchQuizMap();
using (var db = ObjectFactory.CreateDbContext(commonService.GetCompanyDbFilePath(this.company)))
{
data = db.GetQueryData <BatchQuizMap>(SQL.SelectBatchQuizMapByID, new { ID = id }).FirstOrDefault();
}
return(data);
}
public ActionResult add(BatchQuizMap obj)
{
obj.ID = Guid.NewGuid().ToString().ToLower();
obj.CompanyID = this.Company.ToLower();
obj.CreatedBy = LoggedUserID;
obj.CreationDate = Utility.GetCurrentDateInt();
obj.CreationTime = Utility.GetCurrentTimeInt();
obj.ModificationDate = Utility.GetCurrentDateInt();
obj.ModificationTime = Utility.GetCurrentTimeInt();
obj.ModifiedBy = LoggedUserID;
_db.AddBatchQuizMapping(obj);
return(RedirectToAction("index"));
}
