public bool DeleteCourseMaster(int?id, CourseMaster courseMaster)
{
try
{
var obj = JsonConvert.SerializeObject
(new CourseMaster
{
CourseId = courseMaster.CourseId,
UserId = courseMaster.UserId,
TokenId = courseMaster.TokenId
});
var CourseObj = obj.ToString();
var JsonObj = db.RemoveCourse(id, CourseObj);
return(true);
//var courseMaster = db.CourseMasters.Where(x => x.CourseId == id).FirstOrDefault();
//if (courseMaster == null) return false;
//db.Entry(courseMaster).State = System.Data.Entity.EntityState.Deleted;
//db.SaveChanges();
//return true;
}
catch (Exception ex)
{
Console.WriteLine("NotImplementedException", ex);
return(false);
}
}
protected void btnAddCourse_Click(object sender, EventArgs e)
{
System.Threading.Thread.Sleep(3000);
obj = new CourseMaster();
obj.Name = txtName.Text;
obj.Description = txtDescription.Text;
//obj.IsVisible = chkVisible.Checked;
obj.CreatedBy = 1;
obj.UpdatedBy = 1;
obj.CourseID = Convert.ToInt16(lblCourseID.Text);
if (lblCourseID.Text.Equals("-1"))
{
obj1 = new CourseMasterDataManager();
obj1.AddCourseDetail(obj);
msgbox("Course Added successfully!!!");
}
else
{
obj1 = new CourseMasterDataManager();
obj1.UpdateCourseDetail(obj);
msgbox("Course updated successfully!!!");
}
Clear();
bind();
}
public JsonResponse <CourseMaster> GetCourseDetails(int id)
{
JsonResponse <CourseMaster> response = new JsonResponse <CourseMaster>();
try
{
CourseMaster C = _context.CourseMasters.Where(c => c.IsDeleted == 0 && c.ID == id).FirstOrDefault();
if (C != null)
{
C.CourseCurriculums = _context.CourseCurriculums.Where(x => x.CourseMasterID == id).ToList();
C.SubCourses = _context.SubCourses.Where(x => x.CourseMasterID == id).ToList();
response.StatusCode = "200";
response.IsSuccess = true;
response.Message = "Data collected.";
}
else
{
response.StatusCode = "200";
response.IsSuccess = true;
response.Message = "No data available.";
}
response.SingleResult = C;
}
catch (Exception ex)
{
response.StatusCode = "500";
response.IsSuccess = false;
response.Message = ex.Message;
}
return(response);
}
private void bindTextboxes(string strCourseId)
{
try
{
if (strCourseId != null)
{
int iCourseId = Convert.ToInt32(strCourseId);
CourseMaster objEditCourse = db.CourseMasters.Where(aa => aa.C_AYN == "Y" && aa.C_ID == iCourseId).FirstOrDefault();
if (objEditCourse != null)
{
txtCourseName.Text = objEditCourse.C_NAME;
txtDuration.Text = objEditCourse.C_DURATION;
txtFee.Text = objEditCourse.C_FEE.ToString();
txtStartDate.Text = objEditCourse.C_STARTDATE.ToString();
txtEndDate.Text = objEditCourse.C_ENDDATE.ToString();
Session["CourseId"] = null;
}
}
}
catch (Exception ee)
{
}
}
public List <SelectListItem> GetCourseListItem()
{
CourseBL objUserBL = new CourseBL();
List <SelectListItem> lstSelectItem = new List <SelectListItem>();
try
{
CourseMaster obj = new CourseMaster();
List <CourseMaster> lstUserType = objUserBL.CRUDCourses(obj, "L");
if (lstUserType != null)
{
lstSelectItem.Add(new SelectListItem {
Text = "Select Course", Value = ""
});
foreach (var u in lstUserType)
{
lstSelectItem.Add(new SelectListItem {
Text = Convert.ToString(u.CourseName), Value = Convert.ToString(u.CourseId)
});
}
}
}
catch (Exception)
{
throw;
}
return(lstSelectItem);
}
public bool InsUpdCourseMaster(int?id, CourseMaster courseMaster)
{
try
{
var obj = JsonConvert.SerializeObject
(new CourseMaster
{
CourseId = courseMaster.CourseId,
CourseCode = courseMaster.CourseCode,
CourseName = courseMaster.CourseName,
CourseGroup = courseMaster.CourseGroup,
CourseType = courseMaster.CourseType,
SKS = courseMaster.SKS,
UserId = courseMaster.UserId,
TokenId = courseMaster.TokenId,
});
var CourseObj = obj.ToString();
var JsonObj = db.UpdateCourse(id, CourseObj);
return(true);
//db.CourseMasters.Add(courseMaster);
//db.SaveChanges();
//return true;
}
catch (Exception ex)
{
Console.WriteLine("NotImplementedException", ex);
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtCourseId.Text.Trim().Length > 0 && txtCourseId.Text != null)
{
int iCouserId = Convert.ToInt32(txtCourseId.Text.Trim());
CourseMaster objEditCourse = db.CourseMasters.Where(aa => aa.C_AYN == "Y" && aa.C_ID == iCouserId).SingleOrDefault();
if (objEditCourse != null)
{
objEditCourse.C_NAME = txtCourseName.Text.Trim();
objEditCourse.C_DURATION = txtDuration.Text.Trim();
objEditCourse.C_FEE = Convert.ToInt32(txtFee.Text.Trim());
objEditCourse.C_STARTDATE = Convert.ToDateTime(txtStartDate.Text.Trim());
objEditCourse.C_ENDDATE = Convert.ToDateTime(txtEndDate.Text.Trim());
objEditCourse.MDATE = DateTime.Now.ToString("yyyyMMddHHmmss");
objEditCourse.MUSER = "******";
db.SaveChanges();
Response.Redirect("~/Admin/CourseList.aspx");
}
}
else
{
CourseMaster objCheckCourse = db.CourseMasters.Where(aa => aa.C_AYN == "Y" && aa.C_NAME == txtCourseName.Text.Trim()).FirstOrDefault();
if (objCheckCourse != null)
{
lblErrMsg.Text = "Course name already exits, Please try another course name";
}
else
{
CourseMaster objNewCourse = new CourseMaster();
objNewCourse.C_NAME = txtCourseName.Text.Trim();
objNewCourse.C_DURATION = txtDuration.Text.Trim();
objNewCourse.C_FEE = Convert.ToInt32(txtFee.Text.Trim());
objNewCourse.C_STARTDATE = Convert.ToDateTime(txtStartDate.Text.Trim());
objNewCourse.C_ENDDATE = Convert.ToDateTime(txtEndDate.Text.Trim());
objNewCourse.C_AYN = "Y";
objNewCourse.CDATE = DateTime.Now.ToString("yyyyMMddHHmmss");
objNewCourse.CUSER = "******";
db.CourseMasters.Add(objNewCourse);
db.SaveChanges();
Response.Redirect("~/Admin/CourseList.aspx");
}
}
}
catch (Exception ee)
{
}
}
public ActionResult AddCourse(int?id)
{
CourseMaster course = new CourseMaster();
course.CourseId = id ?? 0;
CourseMaster objCourseDetails = objCourseBL.CRUDCourses(course, "S").FirstOrDefault();
return(View(objCourseDetails));
}
public IHttpActionResult Delete(CourseMaster courseMaster)
{
var isDeleted = courseMasterService.DeleteCourseMaster(courseMaster.UniversityId, courseMaster);
if (isDeleted == true)
{
return(Ok());
}
return(BadRequest());
}
public IHttpActionResult Save(CourseMaster courseMaster)
{
var isUpdate = courseMasterService.InsUpdCourseMaster(courseMaster.UniversityId, courseMaster);
if (isUpdate == true)
{
return(Ok());
}
return(BadRequest());
}
public static string[] GetCompletionListCourse(string prefixText, int count, string contextKey)
{
CourseMaster objCourse = new CourseMaster();
DataTable dt = new DataView(objCourse.GetCourseMaster(HttpContext.Current.Session["CompId"].ToString()), "Course like '" + prefixText.ToString() + "%'", "", DataViewRowState.CurrentRows).ToTable();
string[] txt = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
txt[i] = dt.Rows[i]["Course"].ToString();
}
return(txt);
}
public async Task <IActionResult> CourseMasterUpdate([FromBody] CourseMaster courseMaster)
{
try
{
courseMaster.ModifiedBy = "Admin";
courseMaster.ModifiedDate = DateTime.Now;
db.Entry(courseMaster).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
return(Ok(courseMaster));
}
catch (Exception ex)
{
return(BadRequest());
}
}
public JsonResult DeleteCourse(int ID)
{
try
{
CourseMaster course = new CourseMaster();
course.CourseId = ID;
if (course.CourseId > 0)
{
objCourseBL.CRUDCourses(course, "D");
TempData["SuccessMessage"] = "You have removed one course successfully";
}
}
catch (Exception ex)
{ }
return(Json(new { Success = "Success" }, JsonRequestBehavior.AllowGet));
}
public JsonResponse <CourseMasterDTO> GetCourseDetails(int id)
{
JsonResponse <CourseMasterDTO> response = new JsonResponse <CourseMasterDTO>();
var config = new MapperConfiguration(map =>
{
map.CreateMap <CourseMaster, CourseMasterDTO>();
map.CreateMap <CourseMasterDTO, CourseMaster>();
map.CreateMap <SubCourse, SubCourseDTO>();
map.CreateMap <SubCourseDTO, SubCourse>();
map.CreateMap <CourseCurriculum, CourseCurriculumDTO>();
map.CreateMap <CourseCurriculumDTO, CourseCurriculum>();
});
try
{
CourseMaster Course = _context.CourseMasters.Where(c => c.IsDeleted == 0 && c.ID == id).FirstOrDefault();
IMapper iMapper = config.CreateMapper();
CourseMasterDTO C = iMapper.Map <CourseMasterDTO>(Course);
if (C != null)
{
C.CourseCurriculum = iMapper.Map <List <CourseCurriculumDTO> >(_context.CourseCurriculums.Where(x => x.CourseMasterID == id).ToList());
C.SubCourses = iMapper.Map <List <SubCourseDTO> >(_context.SubCourses.Where(x => x.CourseMasterID == id).ToList());
response.StatusCode = "200";
response.IsSuccess = true;
response.Message = "Data collected.";
}
else
{
response.StatusCode = "200";
response.IsSuccess = true;
response.Message = "No data available.";
}
response.SingleResult = C;
}
catch (Exception ex)
{
response.StatusCode = "500";
response.IsSuccess = false;
response.Message = ex.Message;
}
return(response);
}
public List <CourseMaster> CRUDCourses(CourseMaster objCourse, string action)
{
List <CourseMaster> objCourseDetails = new List <CourseMaster>();
try
{
DataTable dtResponse = objUserDA.CRUDCourses(objCourse, action);
if (dtResponse != null && dtResponse.Rows.Count > 0)
{
objCourseDetails = dtResponse.ConvertToListOf <CourseMaster>(); // ExtensionMethods.ConvertToListOf<CourseMaster>(dtResponse);
}
}
catch (Exception ex)
{
throw;
}
return(objCourseDetails);
}
public async Task <IActionResult> CourseMasterCreate([FromBody] CourseMaster courseMaster)
{
try
{
//CourseMaster.EnquiryID = 0;
courseMaster.CreatedBy = "Admin";
courseMaster.CreatedDate = DateTime.Now;
courseMaster.ModifiedBy = "Admin";
courseMaster.ModifiedDate = DateTime.Now;
courseMaster.Active = true;
db.courseMasters.Add(courseMaster);
db.SaveChanges();
return(Ok(courseMaster));
}
catch (Exception ex)
{
return(BadRequest());
}
}
protected void btnEnroll_Click(object sender, EventArgs e)
{
try
{
objUser = (User)Session["LoginUser"];
StudentMaster objSM = db.StudentMasters.Where(aa => aa.S_AYN == "Y" && aa.S_USERNAME == objUser.U_USERNAME).FirstOrDefault();
foreach (GridViewRow row in gvCourses.Rows)
{
Label lblCourseId = (Label)row.FindControl("lblCourseId");
CheckBox cbEnroll = (CheckBox)row.FindControl("chkRow");
if (cbEnroll.Checked)
{
int iCourseId = Convert.ToInt32(lblCourseId.Text);
CourseMaster objCouseMaster = db.CourseMasters.Where(aa => aa.C_ID == iCourseId && aa.C_AYN == "Y").FirstOrDefault();
StudentEnrollCourseTran objSMCEnroll = new StudentEnrollCourseTran();
objSMCEnroll.SEC_COURSE_ID = objCouseMaster.C_ID;
objSMCEnroll.SEC_COURSE_NAME = objCouseMaster.C_NAME;
objSMCEnroll.SEC_COURSE_PRICE = objCouseMaster.C_FEE;
objSMCEnroll.SEC_STUDENT_ID = objSM.S_ID;
objSMCEnroll.SEC_STUDENT_NAME = objSM.S_NAME;
objSMCEnroll.SEC_ENROLLBY = objUser.U_USERNAME;
objSMCEnroll.SEC_ENROLLDATE = DateTime.Now;
objSMCEnroll.CDATE = DateTime.Now.ToString("yyyyMMddHHmmss");
objSMCEnroll.CUSER = objUser.U_USERNAME;
objSMCEnroll.SEC_AYN = "Y";
db.StudentEnrollCourseTrans.Add(objSMCEnroll);
}
}
db.SaveChanges();
Response.Redirect("~/Student/StudentsCoursesView.aspx");
}
catch (Exception ee)
{
}
}
public void UpdateCourseDetail(CourseMaster obj)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@CourseID", obj.CourseID),
new SqlParameter("@Name", obj.Name),
new SqlParameter("@Description", obj.Description),
//new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0),
new SqlParameter("@CreatedBy", obj.CreatedBy),
new SqlParameter("@UpdatedBy", obj.UpdatedBy)
};
DBOperate.ExecuteProcedureWithOutReturn("usp_UpdateCourse", parameter);
}
catch
{
throw;
}
}
public DataTable CRUDCourses(CourseMaster objCourse, string action)
{
DataTable dtResult = new DataTable();
try
{
SqlParameter objSqlParameter = new SqlParameter("CourseId", objCourse.CourseId);
SqlParameter objSqlParameter1 = new SqlParameter("CourseName", objCourse.CourseName);
SqlParameter objSqlParameter2 = new SqlParameter("Description", objCourse.Description);
SqlParameter objSqlParameter3 = new SqlParameter("Eligibility", objCourse.Eligibility);
SqlParameter objSqlParameter4 = new SqlParameter("LoggedInUser", objCourse.LoggedInUser);
SqlParameter objSqlParameter5 = new SqlParameter("Action", action);
List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5 });
dtResult = DBCommon.ExecuteDataAdapterDataTable("CRUDCourses", lstSqlParams);
}
catch (Exception ex)
{
throw;
}
return(dtResult);
}
// GET api/<controller>/5
public ActionResult AddCourse(CourseMaster course)
{
try
{
course.LoggedInUser = long.Parse("0" + Request.Cookies["UserId"].Value);
CourseMaster objCourseDetails = objCourseBL.CRUDCourses(course, (course.CourseId > 0 ? "U" : "I")).FirstOrDefault();
if (objCourseDetails.CRUDStatus == "success" || objCourseDetails.CourseId > 0)
{
TempData["SuccessMessage"] = "You have " + (course.CourseId > 0 ? "updated" : "added") + " one course successfully";
return(RedirectToAction("Course", "Fees"));
}
else
{
TempData["ErrorMessage"] = objCourseDetails.CRUDStatus;
return(RedirectToAction("Course", "Fees"));
}
}
catch (Exception ex)
{
TempData["ErrorMessage"] = ex.Message;
return(RedirectToAction("Course", "Fees"));
}
}
protected void gvCourses_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
GridViewRow row = (GridViewRow)gvCourses.Rows[e.RowIndex];
Label lblCourseId = (Label)row.FindControl("lblCourseId");
int iCourseId = Convert.ToInt32(lblCourseId);
CourseMaster objDeleteCourse = db.CourseMasters.Where(aa => aa.C_AYN == "Y" && aa.C_ID == iCourseId).SingleOrDefault();
if (objDeleteCourse != null)
{
objDeleteCourse.C_AYN = "N";
objDeleteCourse.MDATE = DateTime.Now.ToString("yyyyMMddHHmmss");
objDeleteCourse.MUSER = "******";
db.SaveChanges();
LoadAllCourses();
}
}
catch (Exception ee)
{
}
}
// GET api/<controller>
public ActionResult Course(CourseMaster course)
{
List <CourseMaster> userList = objCourseBL.CRUDCourses(course, "L");
return(View(userList));
}
