public ActionResult AddCurriculumToDB(string jsonData, string title, string CId)
{
try
{
TblUser sessionUser = (TblUser)Session["UserSession"];
tblCurriculum objCurriculum = new tblCurriculum();
objCurriculum.CreatedBy = sessionUser.UserId;
objCurriculum.TenantId = sessionUser.TenantId;
objCurriculum.CurriculumTitle = title;
if (Convert.ToInt32(CId) > 0)
{
objCurriculum.CurriculumId = Convert.ToInt32(CId);
}
JavaScriptSerializer json_serializer = new JavaScriptSerializer();
json_serializer.MaxJsonLength = int.MaxValue;
object[] objData = null;
if (!string.IsNullOrEmpty(jsonData))
{
objData = (object[])json_serializer.DeserializeObject(jsonData);
}
var result = cc.AddCurriculumToDB(objData, objCurriculum);
}
catch (Exception ex)
{
newException.AddException(ex);
}
return(Json("OK", JsonRequestBehavior.AllowGet));
}
// PUT api/values/5
public HttpResponseMessage Put(int id, tblCurriculum curriculumDetails)
{
try
{
var curriculum = unitOfWork.CurriculumRepository.GetByID(id);
curriculum.CurriculumID = curriculumDetails.CurriculumID;
curriculum.CurriculumTitle = curriculumDetails.CurriculumTitle;
curriculum.SchoolID = curriculumDetails.SchoolID;
unitOfWork.CurriculumRepository.Update(curriculum);
unitOfWork.Save();
return(Request.CreateResponse <tblCurriculum>(HttpStatusCode.OK, curriculum));
}
catch
{
return(Request.CreateResponse <tblCurriculum>(HttpStatusCode.NotFound, null));
}
}
public int AddCurriculumToDB(object[] objData, tblCurriculum obj)
{
int CurriculumId = 0;
if (obj.CurriculumId == 0)
{
db.parameters.Clear();
db.AddParameter("@CurriculumTitle", SqlDbType.NText, obj.CurriculumTitle);
db.AddParameter("@CreatedBy", SqlDbType.Int, obj.CreatedBy);
db.AddParameter("@tenantId", SqlDbType.Int, obj.TenantId);
db.AddParameter("@CurriculumId", SqlDbType.Int, ParameterDirection.Output);
CurriculumId = db.ExecuteQuery("sp_CurriculumAdd");
if (Convert.ToInt32(db.parameters[3].Value) > 0)
{
CurriculumId = Convert.ToInt32(db.parameters[3].Value);
}
}
else
{
db.parameters.Clear();
db.AddParameter("@CurriculumId", SqlDbType.Int, obj.CurriculumId);
db.AddParameter("@CurriculumTitle", SqlDbType.NText, obj.CurriculumTitle);
db.AddParameter("@status", SqlDbType.Int, ParameterDirection.Output);
var status = db.ExecuteQuery("sp_CurriculumEdit");
if (Convert.ToInt32(db.parameters[2].Value) > 0)
{
db.parameters.Clear();
db.AddParameter("@CurriculumId", SqlDbType.Int, obj.CurriculumId);
db.AddParameter("@status", SqlDbType.Int, ParameterDirection.Output);
status = db.ExecuteQuery("sp_CurriculumDeleteActivity");
if (Convert.ToInt32(db.parameters[1].Value) > 0)
{
}
}
CurriculumId = obj.CurriculumId;
}
if (CurriculumId > 0)
{
if (objData != null)
{
foreach (Dictionary <string, object> item in objData)
{
db.parameters.Clear();
db.AddParameter("@ActivityId", SqlDbType.Int, Convert.ToInt32(item["activityId"]));
db.AddParameter("@CurriculumId", SqlDbType.Int, CurriculumId);
db.AddParameter("@ActivityType", SqlDbType.NText, Convert.ToString(item["activityType"]));
db.AddParameter("@ActivityOrder", SqlDbType.Int, Convert.ToInt32(item["index"]));
db.AddParameter("@result", SqlDbType.Int, ParameterDirection.Output);
var index = db.ExecuteQuery("sp_CurriculumAddActivity");
}
}
}
if (obj.CurriculumId > 0)
{
var DS = GetAssignedCurriculumUsers(obj.CurriculumId);
if (DS != null)
{
if (DS.Count > 0)
{
db.parameters.Clear();
db.AddParameter("@CurriculumId", SqlDbType.Int, Convert.ToInt32(obj.CurriculumId));
db.AddParameter("@status", SqlDbType.Int, ParameterDirection.Output);
var isDelete = db.ExecuteQuery("sp_CurriculumDeleteAssignedUsers");
if (Convert.ToInt32(db.parameters[1].Value) > 0)
{
isDelete = 1;
}
foreach (var item in DS)
{
db.parameters.Clear();
db.AddParameter("@CurriculumId", SqlDbType.Int, Convert.ToInt32(obj.CurriculumId));
db.AddParameter("@UserId", SqlDbType.Int, Convert.ToInt32(item.UserId));
db.AddParameter("@DueDate", SqlDbType.DateTime, Convert.ToDateTime(item.DueDate));
db.AddParameter("@result", SqlDbType.Int, ParameterDirection.Output);
var result = db.ExecuteQuery("sp_CurriculumAssign");
if (Convert.ToInt32(db.parameters[3].Value) > 0)
{
CurriculumId = 1;
}
}
}
}
}
return(CurriculumId);
}
public void UpdatetblCurriculum(tblCurriculum tblCurriculum)
{
context.Entry(tblCurriculum).State = System.Data.Entity.EntityState.Modified;
}
public void DeletetblCurriculum(int tblCurriculumid)
{
tblCurriculum tblCurriculum = context.tblCurriculum.Find(tblCurriculumid);
context.tblCurriculum.Remove(tblCurriculum);
}
public void InserttblCurriculum(tblCurriculum tblCurriculum)
{
context.tblCurriculum.Add(tblCurriculum);
}
public ActionResult AddCurriculum()
{
tblCurriculum objCurriculum = new tblCurriculum();
return(View(objCurriculum));
}
