protected void btnSave_Click(object sender, EventArgs e)
        {
            Crime_Case_DetailsObject cbiObject = new Crime_Case_DetailsObject();
            CrimeInformationService cisObj = new CrimeInformationService();

            try
            {
                cbiObject.RefNo = txtRefNo.Text;
                cbiObject.CaseNo = txtCaseNo.Text;
                cbiObject.District = txtDistrict.Text;
                cbiObject.Thana = txtThana.Text;
                cbiObject.Date = Convert.ToDateTime(txtDate.Text);
                cbiObject.CreateBy = User.Identity.Name;
                cbiObject.CreateDate = DateTime.Now;
                cbiObject.LastUpdateBy = User.Identity.Name;
                cbiObject.LastUpdateDate = DateTime.Now;
                if (cisObj.InsertCrimeCaseDetails(cbiObject))
                {
                    Response.Redirect("crime-zone-information.aspx?refno=" + txtRefNo.Text);
                }
            }
            catch (Exception ex)
            {
                ErrorMessage.Text = ex.Message;
            }
        }
        protected void btnSave_Click(object sender, EventArgs e)
        {
            Crime_Remand_InformationObject cbiObject = new Crime_Remand_InformationObject();
            CrimeInformationService cisObj = new CrimeInformationService();

            try
            {
                cbiObject.RefNo = txtRefNo.Text;
                cbiObject.RemandNo = txtRemandNo.Text;
                cbiObject.DateofRemand = Convert.ToDateTime(txtDateofRemand.Text);
                cbiObject.Duration = txtDuration.Text;
                cbiObject.ReasonofRemand = txtReasonofRemand.Text;
                cbiObject.CreateBy = User.Identity.Name;
                cbiObject.CreateDate = DateTime.Now;
                cbiObject.LastUpdateBy = User.Identity.Name;
                cbiObject.LastUpdateDate = DateTime.Now;
                if (cisObj.InsertCrimeRemandInformation(cbiObject))
                {
                    Response.Redirect("crime-arrest-information.aspx?refno=" + txtRefNo.Text);
                }
            }
            catch (Exception ex)
            {
                ErrorMessage.Text = ex.Message;
            }
        }
 protected void btnSave_Click(object sender, EventArgs e)
 {
     Crime_Basic_InformationObject cbiObject = new Crime_Basic_InformationObject();
     CrimeInformationService cisObj = new CrimeInformationService();
     try
     {
         cbiObject.CreminalRef = txtRefNo.Text;
         cbiObject.CriminalStatus = rblCriminalStatus.SelectedValue;
         cbiObject.GangName = txtGangName.Text;
         cbiObject.CrimeType = ddlCrimeType.SelectedValue;
         cbiObject.IllegalArmsPossession = rblIllegalArmsPossession.SelectedValue;
         cbiObject.Remarks = txtRemarks.Text;
         cbiObject.LegalArmsPossession = rbllegalArmsPossession.SelectedValue;
         cbiObject.PriorityListGovt = txtPriorityListGovt.Text;
         cbiObject.CaseDetails = txtCaseDetails.Text;
         cbiObject.LastState = txtLastState.Text;
         cbiObject.CreateBy = User.Identity.Name;
         cbiObject.CreateDate = DateTime.Now;
         cbiObject.LastUpdateBy = User.Identity.Name;
         cbiObject.LastUpdateDate = DateTime.Now;
         if (cisObj.InsertCrimeBasicInformation(cbiObject))
         {
             Response.Redirect("crime-history.aspx?refno=" + txtRefNo.Text);
         }
     }
     catch (Exception ex)
     {
         ErrorMessage.Text = ex.Message;
     }
 }
        protected void btnSave_Click(object sender, EventArgs e)
        {
            Crime_HistoryObject cbiObject = new Crime_HistoryObject();
            CrimeInformationService cisObj = new CrimeInformationService();

            try
            {
                cbiObject.RefNo = txtRefNo.Text;
                cbiObject.CrimeType = ddlCrimeType.SelectedValue;
                cbiObject.Description = txtDescription.Text;
                cbiObject.CrimeCode = txtCrimeCode.Text;
                cbiObject.CrimeDate = Convert.ToDateTime(txtCrimeDate.Text);
                cbiObject.CreateBy = User.Identity.Name;
                cbiObject.CreateDate = DateTime.Now;
                cbiObject.LastUpdateBy = User.Identity.Name;
                cbiObject.LastUpdateDate = DateTime.Now;
                if (cisObj.InsertCrimeHistory(cbiObject))
                {
                    Response.Redirect("crime-case-details.aspx?refno=" + txtRefNo.Text);
                }
            }
            catch (Exception ex)
            {
                ErrorMessage.Text = ex.Message;
            }
        }
        protected void btnSave_Click(object sender, EventArgs e)
        {
            Crime_Arrest_InformationObject cbiObject = new Crime_Arrest_InformationObject();
            CrimeInformationService cisObj = new CrimeInformationService();

            try
            {
                cbiObject.RefNo = txtRefNo.Text;
                cbiObject.District = txtDistrict.Text;
                cbiObject.DateofArrest = Convert.ToDateTime(txtDateofArrest.Text);
                cbiObject.Upozila = txtUpozila.Text;
                cbiObject.ArrestBy = txtArrestBy.Text;
                cbiObject.Disposal = txtDisposal.Text;
                cbiObject.CreateBy = User.Identity.Name;
                cbiObject.CreateDate = DateTime.Now;
                cbiObject.LastUpdateBy = User.Identity.Name;
                cbiObject.LastUpdateDate = DateTime.Now;
                if (cisObj.InsertCrimeArrestInformation(cbiObject))
                {
                    Response.Redirect("crime-criminal-activities.aspx?refno=" + txtRefNo.Text);
                }
            }
            catch (Exception ex)
            {
                ErrorMessage.Text = ex.Message;
            }
        }
        protected void btnSave_Click(object sender, EventArgs e)
        {
            Crime_ZoneObject cbiObject = new Crime_ZoneObject();
            CrimeInformationService cisObj = new CrimeInformationService();

            try
            {
                cbiObject.RefNo = txtRefNo.Text;
                cbiObject.Battalion = txtBattalion.Text;
                cbiObject.District = txtDistrict.Text;
                cbiObject.PoliceStation = txtPoliceStation.Text;
                cbiObject.Village = txtVillage.Text;
                cbiObject.Latitude = txtlatitude.Text;
                cbiObject.Longitude = txtlongitude.Text;
                cbiObject.Remarks = txtRemarks.Text;
                cbiObject.CreateBy = User.Identity.Name;
                cbiObject.CreateDate = DateTime.Now;
                cbiObject.LastUpdateBy = User.Identity.Name;
                cbiObject.LastUpdateDate = DateTime.Now;
                if (cisObj.InsertCrimeZone(cbiObject))
                {
                    Response.Redirect("crime-remand-information.aspx?refno=" + txtRefNo.Text);
                }
            }
            catch (Exception ex)
            {
                ErrorMessage.Text = ex.Message;
            }
        }
        public static string GetData(string crimeType, string fromDate, string todate)
        {
            CrimeInformationService cisObj = new CrimeInformationService();

            try
            {
                DataTable dt = cisObj.SelectCrimeZoneInformation(crimeType, Convert.ToDateTime(fromDate), Convert.ToDateTime(todate));
                return ConvertDataTabletoString(dt);
            }
            catch (Exception ex)
            {

            }
            return crimeType;
        }
        protected void btnSave_Click(object sender, EventArgs e)
        {
            Crime_Criminal_ActivitiesObject cbiObject = new Crime_Criminal_ActivitiesObject();
            CrimeInformationService cisObj = new CrimeInformationService();

            try
            {
                cbiObject.RefNo = txtRefNo.Text;
                cbiObject.previousAcitivity = txtpreviousAcitivity.Text;
                cbiObject.CurrentActivity = txtCurrentActivity.Text;
                cbiObject.CreateBy = User.Identity.Name;
                cbiObject.CreateDate = DateTime.Now;
                cbiObject.LastUpdateBy = User.Identity.Name;
                cbiObject.LastUpdateDate = DateTime.Now;
                if (cisObj.InsertCrimeActivitiesInformation(cbiObject))
                {
                    Response.Redirect("crime-entry-end.aspx?refno=" + txtRefNo.Text);
                }
            }
            catch (Exception ex)
            {
                ErrorMessage.Text = ex.Message;
            }
        }