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)); }