public object UpdateInstituteBank(InstituteBankUpdateParam obj) { try { var data = db.Tbl_Institute_Bank_Details.Where(r => r.InstituteId == obj.InstituteId).FirstOrDefault(); Tbl_Institute_Bank_Details objinst = new Tbl_Institute_Bank_Details(); data.InstituteId = data.InstituteId; data.BankName = obj.BankName; data.AccountNumber = obj.AccountNumber; data.IndexNo = obj.IndexNo; data.PanNo = obj.PanNo; data.TanNo = obj.TanNo; data.Gstin = obj.Gstin; data.Ifsc = obj.Ifsc; data.Micr = obj.Micr; //objinst.CreatedId = obj.CreatedId; //objinst.CreatedOn = System.DateTime.Now.Date; data.ModifiedOn = System.DateTime.Now.Date; data.ModifiedId = 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 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 SaveBankInstitute(InstituteBankParam obj) { try { var data = db.Tbl_Institute_Master.OrderByDescending(r => r.InstituteId).FirstOrDefault(); Tbl_Institute_Bank_Details objinst = new Tbl_Institute_Bank_Details(); objinst.InstituteId = data.InstituteId; objinst.BankName = obj.BankName; objinst.AccountNumber = obj.AccountNumber; objinst.IndexNo = obj.IndexNo; objinst.PanNo = obj.PanNo; objinst.TanNo = obj.TanNo; objinst.Gstin = obj.Gstin; objinst.Ifsc = obj.Ifsc; objinst.Micr = obj.Micr; objinst.CreatedId = obj.CreatedId; objinst.CreatedOn = System.DateTime.Now.Date; objinst.ModifiedOn = System.DateTime.Now.Date; objinst.ModifiedId = null; objinst.Status = 1; db.Tbl_Institute_Bank_Details.Add(objinst); db.SaveChanges(); return(new Result() { IsSucess = true, ResultData = "Created Institute" }); } catch (Exception E) { return(new Error() { IsError = true, Message = E.Message }); } }