public object Delete(InstituteUpdateParam s) { try { Tbl_Institute_Master objuser = db.Tbl_Institute_Master.Where(r => r.InstituteId == s.InstituteId).FirstOrDefault(); Tbl_Institute_Address_Details add = new Tbl_Institute_Address_Details(); Tbl_Institute_Bank_Details app = new Tbl_Institute_Bank_Details(); Tbl_Institute_Logo_Details doc = new Tbl_Institute_Logo_Details(); if (objuser.Status == 1) { objuser.Status = 0; add.Status = 0; app.Status = 0; } else { objuser.Status = 1; add.Status = 1; app.Status = 1; } db.SaveChanges(); return(new Result() { IsSucess = true, ResultData = "Deactivted" }); } catch (Exception e) { return(new Error() { IsError = true, Message = e.Message }); } }
public object UpdateInstitute(InstituteUpdateParam obj) { try { Tbl_Institute_Master objinst = new Tbl_Institute_Master(); var data = db.Tbl_Institute_Master.Where(r => r.InstituteId == obj.InstituteId).FirstOrDefault(); if (data == null) { return(new Error() { IsError = true, Message = "Institute Not Found" }); } var Info = db.Tbl_Institute_Master.Where(r => r.InstituteName == obj.InstituteName).FirstOrDefault(); if (Info == null) { return(new Error() { IsError = true, Message = "Institute Name Already Exists!" }); } data.AffilationNo = obj.AffilationNo; data.BoardId = obj.BoardId; data.EstablishedYear = obj.EstablishedYear; data.InstituteName = obj.InstituteName; data.InstituteOrganizationName = obj.InstituteOrganizationName; //objinst.InstituteRecognitionNoPrimary = obj.InstituteRecognitionNoPrimary; data.OrganizationAddress = obj.OrganizationAddress; data.OrganizationRegistrationNo = obj.OrganizationRegistrationNo; //objinst.RegistrationCertificateNo = obj.RegistrationCertificateNo; data.SectionId = obj.SectionId; data.UdiseNo = obj.UdiseNo; //data.CreatedId = obj.CreatedId; //data.CreatedOn = System.DateTime.Now.Date; data.ModifiedId = obj.ModifiedId; data.ModifiedOn = null; data.Status = 1; db.SaveChanges(); return(new Result() { IsSucess = true, ResultData = "Updated Institute" }); } catch (Exception ex) { return(new Error { IsError = true, Message = ex.Message }); } }
public object SaveInstitute(InstituteParam obj) { try { Tbl_Institute_Master objinst = new Tbl_Institute_Master(); objinst.AffilationNo = obj.AffilationNo; objinst.BoardId = obj.BoardId; objinst.InstituteName = obj.InstituteName; objinst.EstablishedYear = obj.EstablishedYear; objinst.InstituteOrganizationName = obj.InstituteOrganizationName; //objinst.InstituteRecognitionNoPrimary = obj.InstituteRecognitionNoPrimary; objinst.OrganizationAddress = obj.OrganizationAddress; objinst.OrganizationRegistrationNo = obj.OrganizationRegistrationNo; //objinst.RegistrationCertificateNo = obj.RegistrationCertificateNo; objinst.SectionId = obj.SectionId; objinst.UdiseNo = obj.UdiseNo; objinst.CreatedId = obj.CreatedId; objinst.CreatedOn = System.DateTime.Now.Date; objinst.ModifiedId = obj.ModifiedId; objinst.ModifiedOn = null; objinst.Status = 1; db.Tbl_Institute_Master.Add(objinst); db.SaveChanges(); return(new Result() { IsSucess = true, ResultData = "Created Institute" }); } catch (Exception E) { return(new Error() { IsError = true, Message = E.Message }); } }