public object DeleteAchievementDetails(SchoolAchievementDetailsParam Pobj) { try { TblSchoolAchievementDetail result = db.TblSchoolAchievementDetails.Where(r => r.AchievementDID == Pobj.AchievementDID).FirstOrDefault(); if (result.Status == 1) { result.Status = 0; } else { result.Status = 1; } db.SaveChanges(); return(new Result { IsSucess = true, ResultData = "Achievement Details Updated Successfully!" }); } catch (Exception ex) { return(new Error { IsError = true, Message = ex.Message }); } }
public object GetSingleAchievementDetails(SchoolAchievementDetailsParam Pobj) { try { var result = db.ViewSchoolAchievementDetails.Where(r => r.AchievementDID == Pobj.AchievementDID).FirstOrDefault(); return(result); } catch (Exception ex) { return(new Error { IsError = true, Message = ex.Message }); } }
public object DeleteAchievementDetails([FromBody] SchoolAchievementDetailsParam Pobj) { try { SchoolAchievementDetailsBL ObjBL = new SchoolAchievementDetailsBL(); var result = ObjBL.DeleteAchievementDetails(Pobj); return(result); } catch (Exception ex) { return(new Error { IsError = true, Message = ex.Message }); } }
public object SaveAchievementDetails(SchoolAchievementDetailsParam Pobj) { try { var AchievementData = db.TblSchoolAchievementDetails.Where(r => r.Achievement == Pobj.Achievement && r.AchievementTypeID == Pobj.AchievementTypeID).FirstOrDefault(); if (AchievementData != null) { return(new Error() { IsError = true, Message = "Achievement Details Already Exists!" }); } TblSchoolAchievementDetail objAchievementDetails = new TblSchoolAchievementDetail(); objAchievementDetails.Achievement = Pobj.Achievement; objAchievementDetails.AchievementTypeID = Pobj.AchievementTypeID; objAchievementDetails.Date = Pobj.Date; objAchievementDetails.CreatedBy = Pobj.CreatedBy; objAchievementDetails.CreatedDate = DateTime.Now; objAchievementDetails.Status = 1; db.TblSchoolAchievementDetails.Add(objAchievementDetails); db.SaveChanges(); msg = "Achievement Details Saved Successfully"; return(new Result() { IsSucess = true, ResultData = msg }); } catch (Exception ex) { return(new Error { IsError = true, Message = ex.Message }); } }
public object UpdateAchievementDetails(SchoolAchievementDetailsParam Pobj) { try { msg = ""; var result = db.TblSchoolAchievementDetails.Where(r => r.Achievement == Pobj.Achievement && r.AchievementTypeID == Pobj.AchievementTypeID).FirstOrDefault(); if (result != null) { return(new Error { IsError = true, Message = "Achievement Details Already Exists!" }); } else { TblSchoolAchievementDetail objTbl = db.TblSchoolAchievementDetails.Where(r => r.AchievementDID == Pobj.AchievementDID).FirstOrDefault(); objTbl.AchievementDID = Pobj.AchievementDID; objTbl.AchievementTypeID = Pobj.AchievementTypeID; objTbl.Achievement = Pobj.Achievement; objTbl.Date = Pobj.Date; objTbl.ModifiedBy = Pobj.ModifiedBy; objTbl.ModifiedDate = DateTime.Now; db.SaveChanges(); msg = "Achievement Details Updated Successfully!"; } } catch (Exception ex) { return(new Error { IsError = true, Message = ex.Message }); } return(new Result { IsSucess = true, ResultData = msg }); }