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