public bool DeleteSubjectMaster(int?id, SubjectMaster subjectMaster) { try { var obj = JsonConvert.SerializeObject (new SubjectMaster { SubjectId = subjectMaster.SubjectId, UserId = subjectMaster.UserId, TokenId = subjectMaster.TokenId, }); var SubjObj = obj.ToString(); var JsonObj = db.RemoveSubject(id, SubjObj); return(true); } catch (Exception ex) { Console.WriteLine("NotImplementedException", ex); return(false); } throw new NotImplementedException(); }
public List <SubjectMaster> GetSubjects() { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InstituteSystem"].ConnectionString); SqlCommand comm = new SqlCommand("ReadSubject", conn); List <SubjectMaster> subjects = new List <SubjectMaster>(); comm.CommandType = CommandType.StoredProcedure; try { conn.Open(); comm.ExecuteNonQuery(); SqlDataReader dataReader = comm.ExecuteReader(); while (dataReader.Read()) { SubjectMaster subjectMaster = new SubjectMaster(); subjectMaster.SubjectId = dataReader.GetInt32(0); subjectMaster.Subject = dataReader.GetString(1); subjects.Add(subjectMaster); } } catch (Exception e) { } finally { conn.Close(); } return(subjects); }
public bool InsUpdSubjectMaster(int?id, SubjectMaster subjectMaster) { try { var obj = JsonConvert.SerializeObject (new SubjectMaster { SubjectId = subjectMaster.SubjectId, SubjectName = subjectMaster.SubjectName, SubjectCode = subjectMaster.SubjectCode, SKS = subjectMaster.SKS, UserId = subjectMaster.UserId, TokenId = subjectMaster.TokenId, }); var SubjObj = obj.ToString(); var JsonObj = db.UpdateSubject(id, SubjObj); return(true); //db.Entry(subjectMaster).State = System.Data.Entity.EntityState.Modified; //db.SaveChanges(); //return true; } catch (Exception ex) { Console.WriteLine("NotImplementedException", ex); return(false); } throw new NotImplementedException(); }
protected void btnAddSubject_Click(object sender, EventArgs e) { obj = new SubjectMaster(); obj.Name = txtName.Text; obj.Description = txtDescription.Text; obj.SubCourseID = Convert.ToInt16(ddlSubCourse.SelectedValue); //obj.IsVisible = chkVisible.Checked; obj.CreatedBy = 1; obj.UpdatedBy = 1; obj.SubjectID = Convert.ToInt16(lblSubjectID.Text); if (lblSubjectID.Text.Equals("-1")) { obj1 = new SubjectMasterDataManager(); obj1.AddSubjectDetail(obj); msgbox("Subject Added successfully!!!"); } else { obj1 = new SubjectMasterDataManager(); obj1.UpdateSubjectDetail(obj); msgbox("Subject updated successfully!!!"); } Clear(); BindDropdown(); bind(ddlSubCourse.SelectedValue); }
public ActionResult DeleteSubject(SubjectMaster subjectMaster) { SubjectService delete = new SubjectService(); delete.DeleteSubject(subjectMaster.SubjectId); return(RedirectToAction("AllSubjects")); }
public ActionResult SubjectList(SubjectMaster subjectMaster) { SubjectService add = new SubjectService(); add.AddSubject(subjectMaster); return(RedirectToAction("AllSubjects")); }
public bool UpdateSubjectMaster(SubjectMaster subjectMaster) { bool returnvalue = false; DynamicParameters param = new DynamicParameters(); param.Add("@SubjectId", subjectMaster.SubjectId); param.Add("@SubjectCode", subjectMaster.SubjectCode); param.Add("@SubjectName", subjectMaster.SubjectName); param.Add("@SKS", subjectMaster.SKS); param.Add("@UniversityId", subjectMaster.UniversityId); param.Add("active", 1); param.Add("@lastupdateddt", DateTime.UtcNow); param.Add("@lastupdatedby", 1); param.Add("@TheoriticalSKS", subjectMaster.TheoriticalSKS); param.Add("@PracticalSKS", subjectMaster.PracticalSKS); param.Add("@CourseType", subjectMaster.CourseType); param.Add("@Semester", subjectMaster.Semester); param.Add("@PreRequisteCourse", subjectMaster.PreRequisteCourse); param.Add("@Teacher1", subjectMaster.Teacher1); param.Add("@Teacher2", subjectMaster.Teacher2); param.Add("@Teacher3", subjectMaster.Teacher3); param.Add("@TotalPeriods", subjectMaster.TotalPeriods); _db.Open(); var val = _db.Execute("YSP_UpdateSubjectMaster", param, commandType: CommandType.StoredProcedure); if (val > 0) { returnvalue = true; } _db.Close(); return(returnvalue); }
public IHttpActionResult Delete(SubjectMaster subjectMaster) { var isDeleted = subjectMasterService.DeleteSubjectMaster(subjectMaster.UniversityId, subjectMaster); if (isDeleted == true) { return(Ok()); } return(BadRequest()); }
public IHttpActionResult UpdateSubjectMaster(SubjectMaster subjectMaster) { var isupdate = _subjectMasterRepository.UpdateSubjectMaster(subjectMaster); if (isupdate == true) { return(Ok(isupdate)); } return(BadRequest()); }
public IHttpActionResult Save(SubjectMaster subjectMaster) { var isUpdate = subjectMasterService.InsUpdSubjectMaster(subjectMaster.UniversityId, subjectMaster); if (isUpdate == true) { return(Ok(subjectMasterService.GetSubject())); } return(BadRequest()); }
public IHttpActionResult Save(SubjectMaster subjectMaster) { if (!ModelState.IsValid) { return(BadRequest()); } var isUpdate = subjectMasterService.InsUpdSubjectMaster(subjectMaster.UniversityId, subjectMaster); if (isUpdate == true) { return(Ok(subjectMaster.SubjectId)); } return(BadRequest()); }
public void AddSubjectDetail(SubjectMaster obj) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@SubCourseID", obj.SubCourseID), new SqlParameter("@Name", obj.Name), // new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0), new SqlParameter("@Description", obj.Description), new SqlParameter("@CreatedBy", obj.CreatedBy), new SqlParameter("@UpdatedBy", obj.UpdatedBy) }; DBOperate.ExecuteProcedureWithOutReturn("usp_AddSubject", parameter); } catch { throw; } }
public void AddSubject(SubjectMaster subjectMaster) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InstituteSystem"].ConnectionString); SqlCommand comm = new SqlCommand("AddSubject", conn); comm.CommandType = CommandType.StoredProcedure; comm.Parameters.Add(new SqlParameter("@subjectName", SqlDbType.VarChar)); comm.Parameters["@subjectName"].Value = subjectMaster.Subject; try { conn.Open(); comm.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine(e); } finally { conn.Close(); } }
public ActionResult AddSubject(SubjectMaster objsubect) { try { objDataContext.subjectMasters.Add(objsubect); objDataContext.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } ViewBag.Message = "Subject Added"; return(View()); }
public int AddSubject(SubjectMaster _master, string Otype) { DALCommon dal = new DALCommon(ConStr); return(dal.AddSubject(_master, Otype)); }