Пример #1
0
        public EntityInsuranceCom GetInsuranceById(int Id)
        {
            EntityInsuranceCom obj = null;

            try
            {
                obj = (from tbl in objData.tblInsuranceComMasters
                       where tbl.PKId == Id
                       select new EntityInsuranceCom
                {
                    Address = tbl.Address,
                    City = tbl.City,
                    ContactEmail = tbl.ContactEmailID,
                    ContactNo = tbl.ContactNo,
                    ContactPerson = tbl.ContactPerson,
                    ContactPhNo = tbl.ContactPhNo,
                    Country = tbl.ContactPhNo,
                    EmailID = tbl.EmailID,
                    FaxNumber = tbl.FaxNumber,
                    InsuranceCode = tbl.InsuranceCode,
                    InsuranceDesc = tbl.InsuranceDesc,
                    MobileNo = tbl.MobileNo,
                    Notes = tbl.Notes,
                    PostalCode = tbl.PostalCode,
                    State = tbl.State
                }).FirstOrDefault();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(obj);
        }
Пример #2
0
        public int UpdateInsurance(EntityInsuranceCom entInsurance)
        {
            int cnt = 0;

            try
            {
                List <SqlParameter> lstParam = new List <SqlParameter>();
                Commons.ADDParameter(ref lstParam, "@InsuranceCode", DbType.String, entInsurance.InsuranceCode);
                Commons.ADDParameter(ref lstParam, "@InsuranceDesc", DbType.String, entInsurance.InsuranceDesc);
                Commons.ADDParameter(ref lstParam, "@Address", DbType.String, entInsurance.Address);
                Commons.ADDParameter(ref lstParam, "@Country", DbType.String, entInsurance.Country);
                Commons.ADDParameter(ref lstParam, "@State", DbType.String, entInsurance.State);
                Commons.ADDParameter(ref lstParam, "@City", DbType.String, entInsurance.City);
                Commons.ADDParameter(ref lstParam, "@EmailID", DbType.String, entInsurance.EmailID);
                Commons.ADDParameter(ref lstParam, "@ContactNo", DbType.String, entInsurance.ContactNo);
                Commons.ADDParameter(ref lstParam, "@PostalCode", DbType.String, entInsurance.PostalCode);
                Commons.ADDParameter(ref lstParam, "@ContactPerson", DbType.String, entInsurance.ContactPerson);
                Commons.ADDParameter(ref lstParam, "@ContactPhNo", DbType.String, entInsurance.ContactPhNo);
                Commons.ADDParameter(ref lstParam, "@MobileNo", DbType.String, entInsurance.MobileNo);
                Commons.ADDParameter(ref lstParam, "@ContactEmailID", DbType.String, entInsurance.ContactEmail);
                Commons.ADDParameter(ref lstParam, "@Notes", DbType.String, entInsurance.Notes);
                Commons.ADDParameter(ref lstParam, "@ChangeBy", DbType.String, entInsurance.ChangeBy);
                cnt = mobjDataAcces.ExecuteQuery("sp_UpdateInsurance", lstParam);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(cnt);
        }
 protected void btnUpdate_Click(object sender, EventArgs e)
 {
     try
     {
         ImageButton        imgEdit = (ImageButton)sender;
         GridViewRow        cnt     = (GridViewRow)imgEdit.NamingContainer;
         int                Id      = Convert.ToInt32(dgvInsurance.DataKeys[cnt.RowIndex].Value);
         EntityInsuranceCom obj     = mobjInsuranceBLL.GetInsuranceById(Id);
         if (obj != null)
         {
             txtAddress.Text       = obj.Address;
             txtCity.Text          = obj.City;
             txtCountry.Text       = obj.Country;
             txtState.Text         = obj.State;
             txtContactEmail.Text  = obj.ContactEmail;
             txtContactMobNo.Text  = obj.ContactNo;
             txtContactPerson.Text = obj.ContactPerson;
             txtContactPhNo.Text   = obj.ContactPhNo;
             txtEmailID.Text       = obj.EmailID;
             txtFaxNo.Text         = obj.FaxNumber;
             txtInsuranceCode.Text = obj.InsuranceCode;
             txtInsuranceDesc.Text = obj.InsuranceDesc;
             txtNotes.Text         = obj.Notes;
             txtPhNo.Text          = obj.ContactPhNo;
             txtPostalCode.Text    = obj.PostalCode;
         }
         BtnSave.Visible   = false;
         btnUpdate.Visible = true;
         ViewData.SetActiveView(View2);
     }
     catch (Exception ex)
     {
         lblMessage.Text = ex.Message;
     }
 }
        protected void BtnSave_Click(object sender, EventArgs e)
        {
            int lintcnt = 0;

            try
            {
                EntityInsuranceCom entInsurance = new EntityInsuranceCom();
                if (string.IsNullOrEmpty(txtInsuranceCode.Text.Trim()))
                {
                    lblMsg.Text = "Please Enter Insurance Code";
                }
                else
                {
                    if (string.IsNullOrEmpty(txtInsuranceDesc.Text.Trim()))
                    {
                        lblMsg.Text = "Please Enter Insurance Description";
                    }
                    else
                    {
                        entInsurance.InsuranceCode = txtInsuranceCode.Text.Trim();
                        entInsurance.InsuranceDesc = txtInsuranceDesc.Text.Trim();
                        entInsurance.Address       = txtAddress.Text.Trim();
                        entInsurance.Country       = txtCountry.Text;
                        entInsurance.State         = txtState.Text;
                        entInsurance.City          = txtCity.Text;
                        entInsurance.EmailID       = txtEmailID.Text.Trim();
                        entInsurance.ContactNo     = txtPhNo.Text.Trim();
                        entInsurance.PostalCode    = txtPostalCode.Text.Trim();
                        entInsurance.FaxNumber     = txtFaxNo.Text.Trim();
                        entInsurance.ContactPerson = txtContactPerson.Text.Trim();
                        entInsurance.ContactPhNo   = txtContactPhNo.Text.Trim();
                        entInsurance.MobileNo      = txtContactMobNo.Text.Trim();
                        entInsurance.ContactEmail  = txtContactEmail.Text.Trim();
                        entInsurance.Notes         = txtNotes.Text.Trim();
                        entInsurance.EntryBy       = SessionWrapper.UserName;
                        lintcnt = mobjInsuranceBLL.InsertInsurance(entInsurance);

                        if (lintcnt > 0)
                        {
                            ClearAll();
                            GetInsurance();
                            ViewData.SetActiveView(View1);
                            lblMessage.Text = "Record Inserted Successfully";
                        }
                        else
                        {
                            lblMessage.Text = "Record Not Inserted";
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                lblMsg.Text = ex.Message;
            }
        }
Пример #5
0
        public DataTable GetAllState(EntityInsuranceCom entInsurance)
        {
            DataTable ldt = new DataTable();

            try
            {
                List <SqlParameter> lstParam = new List <SqlParameter>();
                Commons.ADDParameter(ref lstParam, "@CountryId", DbType.Int32, entInsurance.Country);
                ldt = mobjDataAcces.GetDataTable("sp_GetStateForInsurance", lstParam);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(ldt);
        }
Пример #6
0
        public int DeleteInsurance(EntityInsuranceCom entInsurance)
        {
            int cnt = 0;

            try
            {
                List <SqlParameter> lstParam = new List <SqlParameter>();
                Commons.ADDParameter(ref lstParam, "@InsuranceCode", DbType.String, entInsurance.InsuranceCode);
                cnt = mobjDataAcces.ExecuteQuery("sp_DeleteInsurance", lstParam);
            }
            catch (Exception ex)
            {
                Commons.FileLog("InsuranceComBLL - DeleteInsurance(EntityInsurance entInsurance)", ex);
            }
            return(cnt);
        }
        protected void BtnEdit_Click(object sender, EventArgs e)
        {
            int lintCnt = 0;

            try
            {
                EntityInsuranceCom entInsurance = new EntityInsuranceCom();
                entInsurance.InsuranceCode = txtInsuranceCode.Text;
                entInsurance.InsuranceDesc = txtInsuranceDesc.Text;
                entInsurance.Address       = txtAddress.Text;
                entInsurance.Country       = txtCountry.Text;
                entInsurance.State         = txtState.Text;
                entInsurance.City          = txtCity.Text;
                entInsurance.EmailID       = txtEmailID.Text;
                entInsurance.ContactNo     = txtPhNo.Text;
                entInsurance.PostalCode    = txtPostalCode.Text;
                entInsurance.FaxNumber     = txtFaxNo.Text;
                entInsurance.ContactPerson = txtContactPerson.Text;
                entInsurance.ContactPhNo   = txtContactPhNo.Text;
                entInsurance.MobileNo      = txtContactMobNo.Text;
                entInsurance.ContactEmail  = txtContactEmail.Text;
                entInsurance.Notes         = txtNotes.Text;
                entInsurance.ChangeBy      = SessionWrapper.UserName;
                lintCnt = mobjInsuranceBLL.UpdateInsurance(entInsurance);

                if (lintCnt > 0)
                {
                    GetInsurance();
                    lblMessage.Text = "Record Updated Successfully";
                    BtnClose_Click(sender, e);
                    ViewData.SetActiveView(View1);
                }
                else
                {
                    lblMessage.Text = "Record Not Updated";
                }
            }
            catch (Exception ex)
            {
                lblMsg.Text = ex.Message;
            }
        }