protected void btn_update_Click(object sender, EventArgs e)
        {
            try
            {
                using (var db = new THFinanceEntities())
                {
                    int           id  = Convert.ToInt32(lbl_id.Text);
                    tbl_Guarantor tbl = (from s in db.tbl_Guarantor
                                         where s.GuarantorId.Equals(id)
                                         select s).SingleOrDefault();
                    tbl.GuarantorAddress     = txt_guaranteeaddresseee.Text;
                    tbl.GuarantorborrowerId  = Convert.ToInt32(ddl_borrwer.SelectedValue);
                    tbl.GuarantorDesignation = txt_guaranteedesignation.Text;
                    tbl.GuarantorFatherName  = txt_guaranteefathername.Text;
                    tbl.GuarantorName        = txt_guaranteename.Text;
                    tbl.GuarantorPhone       = txt_guaranteephone.Text;
                    Stream fs  = txt_guaranteeprooffile.PostedFile.InputStream;
                    Stream fs2 = txt_guaranteephoto.PostedFile.InputStream;

                    BinaryReader br     = new BinaryReader(fs);
                    BinaryReader br2    = new BinaryReader(fs2);
                    Byte[]       bytes  = br.ReadBytes((Int32)fs.Length);
                    Byte[]       bytes2 = br2.ReadBytes((Int32)fs.Length);
                    tbl.Guarantorphoto     = bytes2;
                    tbl.GuarantorProof     = bytes;
                    tbl.GuarantorProoftype = txt_guaranteeproof.Value;
                    db.SaveChanges();
                    clearfields();
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
        protected void btn_login_Click(object sender, EventArgs e)
        {
            try
            {
                using (THFinanceEntities context = new THFinanceEntities())
                {
                    tbl_Guarantor tbl = new tbl_Guarantor();

                    tbl.GuarantorName       = txt_guaranteename.Text;
                    tbl.GuarantorFatherName = txt_guaranteefathername.Text;
                    tbl.GuarantorborrowerId = Convert.ToInt32(ddl_borrwer.SelectedValue);
                    Stream fs  = txt_guaranteeprooffile.PostedFile.InputStream;
                    Stream fs2 = txt_guaranteephoto.PostedFile.InputStream;

                    BinaryReader br     = new BinaryReader(fs);
                    BinaryReader br2    = new BinaryReader(fs2);
                    Byte[]       bytes  = br.ReadBytes((Int32)fs.Length);
                    Byte[]       bytes2 = br2.ReadBytes((Int32)fs.Length);
                    tbl.GuarantorAddress = txt_guaranteeaddresseee.Text;
                    tbl.GuarantorPhone   = txt_guaranteephone.Text;
                    tbl.GuarantorProof   = bytes;
                    //txt_guaranteeprooffile.PostedFile.SaveAs(Server.MapPath("~/Uploads") + tbl.GuarantorProof);
                    tbl.GuarantorProoftype = txt_guaranteeproof.Value;
                    tbl.G_createdBy        = Convert.ToInt32(Session["UserID"]);
                    tbl.G_createdDate      = DateTime.Now;
                    tbl.Guarantorphoto     = bytes2;
                    txt_guaranteephoto.PostedFile.SaveAs(Server.MapPath("~/Uploads") + tbl.Guarantorphoto);
                    // tbl.G_modifiedBy = 1;
                    // tbl.G_modifiedDate = null;
                    context.tbl_Guarantor.Add(tbl);
                    context.SaveChanges();
                    Response.Write("<script>alert('Sucessfully Saved')</script>");
                    clearfields();
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }