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