public Form27CDTO GetForm27CDetailsByCustId(int CustId)
        {
            Form27CDTO Form27CDetails = new Form27CDTO();
            AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<form27c>>()
                .GetSingle(item => item.Cust_Id == CustId), Form27CDetails);

            return Form27CDetails;
        }
        public int UpdateForm27C(Form27CDTO Form27CDetails)
        {
            form27c form27cEntity = new form27c();
            form27c_history form27chistoryEntity = new form27c_history();
            int form27cid;
            using (TransactionScope transactionScope = new TransactionScope())
            {
                AutoMapper.Mapper.Map(Form27CDetails, form27cEntity);
                ESalesUnityContainer.Container.Resolve<IGenericRepository<form27c>>().Update(form27cEntity);
                form27cid = Form27CDetails.Form27C_Id;

                //Form27CDetails.Form27C_Id = 0;
                //AutoMapper.Mapper.Map(Form27CDetails, form27chistoryEntity);
                //ESalesUnityContainer.Container.Resolve<IGenericRepository<form27c_history>>().Save(form27chistoryEntity);
                transactionScope.Complete();
            }
            return form27cid;
        }
        public int SaveForm27C(Form27CDTO form27CDetails)
        {
            form27c form27CEntity = new form27c();
            form27c_history form27C_historyEntity = new form27c_history();
            using (TransactionScope transactionScope = new TransactionScope())
            {
                AutoMapper.Mapper.Map(form27CDetails, form27CEntity);
                if (form27CDetails.Form27C_Id == 0)
                {
                    ESalesUnityContainer.Container.Resolve<IGenericRepository<form27c>>().Save(form27CEntity);
                }

                AutoMapper.Mapper.Map(form27CDetails, form27C_historyEntity);
                if (form27CDetails.Form27C_Id == 0)
                {
                    ESalesUnityContainer.Container.Resolve<IGenericRepository<form27c_history>>().Save(form27C_historyEntity);
                }
                transactionScope.Complete();
            }
            return form27CEntity.Form27C_Id;
        }
    private void AcceptSave()
    {        
        if (Page.IsValid)
        {
            if (chkSignValid.Checked)
            {
                string customerID = ViewState[Globals.StateMgmtVariables.CUSTOMERID].ToString();

                AffidavitDetailsDTO affidavitDetails = ESalesUnityContainer.Container.Resolve<IAffidavitDetails>()
                .GetAffidavitDetailsByCustId(Convert.ToInt32(customerID));

               Form27PeriodTypeDTO form27PeriodTypeDetails = ESalesUnityContainer.Container.Resolve<IForm27CService>()
               .GetForm27PeriodType();

                if (affidavitDetails.AffidavitExpiryDate >= DateTime.Now)
                {                    
                    Form27CDTO form27CDetails = new Form27CDTO();
                    form27CDetails.ReceivedDate = Convert.ToDateTime(txtReceivedDate.Text);
                    form27CDetails.CreatedBy = GetCurrentUserId();
                    form27CDetails.CreatedDate = DateTime.Now;
                    form27CDetails.Cust_Id = Convert.ToInt32(customerID);
                    form27CDetails.ValidMonth = ddlMonth.SelectedItem.Text;
                    form27CDetails.ValidYear = DateTime.Now.Year.ToString();
                    form27CDetails.CurrentMonth = Convert.ToInt32(ddlMonth.SelectedValue);
                    form27CDetails.PeriodType = form27PeriodTypeDetails.PeriodTypeId;


                    int result = ESalesUnityContainer.Container.Resolve<IForm27CService>().SaveForm27C(form27CDetails);

                    if (result > 0)
                    {
                        //string englishMessage = "Hamen aapke Code " + txtCustomerCode.Text.Trim() + " mein " + DateTime.Now.ToString("y") + " ka Form 27C prapt hua hai. Aap apne unit mein prayog ke liye Tailings ki bookings karen";
                        //string mobileNo = ViewState[Globals.StateMgmtVariables.MOBILENO].ToString();
                        //SmsUtility.SendSMSForBookings(mobileNo, englishMessage + " .DCA Ghato");
                        ucMessageBox.ShowMessage("Form 27C Saved Successfully.");
                    }
                    else
                    {
                        ucMessageBox.ShowMessage("Form 27C Not Saved.");
                    }
                    
                }
                else
                {
                    ucMessageBox.ShowMessage("Please submit Affidavit for the current year.");
                }
            }
            else
            {
                ucMessageBox.ShowMessage("Please verify signature.");
            }
        }
    }