Esempio n. 1
0
        public Autorizacionusuario validarcorreo(string correo)
        {
            SqlManager objSql = new SqlManager();

            Parameter           param = new Parameter();
            Autorizacionusuario lista = new Autorizacionusuario();

            param.Add("@correo", correo);


            try
            {
                lista = objSql.getStatement <Autorizacionusuario>("USP_validar_correo_autorizacion_create", param)[0];
                return(lista);
            }
            catch (Exception ex)
            {
                throw ex;
                //afilogDAO.Save(0, 0, "Autorizacionusuario validarcorreo", "validarcorreo", ex);
            }        //Rutina de Guardado en Log
        }
Esempio n. 2
0
        public Autorizacionusuario GetUsuarioAutorizacion(Int32 idautorizacionusuario)
        {
            try
            {
                SqlManager objSql = new SqlManager();
                Parameter  param  = new Parameter();
                List <Autorizacionusuario> lista = new List <Autorizacionusuario>();
                param.Add("@idautorizacionusuario", idautorizacionusuario);

                lista = objSql.getStatement <Autorizacionusuario>("USP_obtener_autorizacionusuario", param);
                if (lista == null || lista.Count == 0)
                {
                    return(new Autorizacionusuario());
                }
                return(lista[0]);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 3
0
        /// <summary>
        /// Add a parameter with a given nanme and tuple value.
        /// </summary>
        /// <param name="name">The name of the parameter</param>
        /// <param name="tuples">The value of the parameter as a list of tuples of (name,FHIR datatype or Resource)</param>
        /// <returns>this (Parameters), so you can chain AddParameter calls</returns>
        public Parameters Add(string name, IEnumerable <Tuple <string, Base> > tuples)
        {
            if (name == null)
            {
                throw new ArgumentNullException("name");
            }
            if (tuples == null)
            {
                throw new ArgumentNullException("tuples");
            }

            var newParam = new ParameterComponent()
            {
                Name = name
            };

            foreach (var tuple in tuples)
            {
                var newPart = new ParameterComponent()
                {
                    Name = tuple.Item1
                };
                newParam.Part.Add(newPart);

                if (tuple.Item2 is Element)
                {
                    newPart.Value = (Element)tuple.Item2;
                }
                else
                {
                    //TODO: Due to an error in the jan2015 version of DSTU2, this is not yet possible
                    //newPart.Resource = (Resource)tuple.Item2;
                    throw Error.NotImplemented("Jan 2015 DSTU2 does not support resource values for tuples parameters");
                }
            }

            Parameter.Add(newParam);

            return(this);
        }
Esempio n. 4
0
        private void GetControlInfo()
        {
            HttpWebRequest req = (HttpWebRequest)WebRequest.Create(Url);

            req.AutomaticDecompression = DecompressionMethods.GZip | DecompressionMethods.Deflate;

            using (HttpWebResponse response = (HttpWebResponse)req.GetResponse())
                using (Stream stream = response.GetResponseStream())
                    using (StreamReader reader = new StreamReader(stream))
                    {
                        string command = reader.ReadToEnd();

                        var commandExists = LastCommands.Any(c => c == command);
                        if (!commandExists)
                        {
                            LastCommands.Add(command);
                            Console.WriteLine(command);
                        }


                        var parameter = command.Split(',');
                        foreach (var para in parameter)
                        {
                            var parameterKey   = para.Split('=')[0];
                            var parameterValue = para.Split('=')[1];

                            if (!Parameter.Keys.Contains(parameterKey))
                            {
                                Parameter.Add(parameterKey, new List <string>());
                            }

                            var valueList = Parameter[parameterKey];
                            if (valueList.Count == 0 || valueList.Last() != parameterValue)
                            {
                                Parameter[parameterKey].Add(parameterValue);
                                Console.WriteLine(para);
                            }
                        }
                    }
        }
 public DataSet INSERT(object classObject)
 {
     ds.Clear();
     Parameter.Clear();
     try
     {
         Parameter.Add("@SubExpences_ID", ((BL_EXPENCESTRANSACTION)classObject).SubExpences_ID.ToString().Trim());
         Parameter.Add("@TransactionModeId", ((BL_EXPENCESTRANSACTION)classObject).TransactionModeId.ToString().Trim());
         Parameter.Add("@Transaction_No", ((BL_EXPENCESTRANSACTION)classObject).TransationNo.ToString().Trim());
         Parameter.Add("@Tran_Date", (((BL_EXPENCESTRANSACTION)classObject).Tras_Date.ToString().Trim()));
         Parameter.Add("@Discription", ((BL_EXPENCESTRANSACTION)classObject).Discription.ToString().Trim());
         Parameter.Add("@Amount", ((BL_EXPENCESTRANSACTION)classObject).Amount.ToString().Trim());
         Parameter.Add("@Type", ((BL_EXPENCESTRANSACTION)classObject).Type.ToString().Trim());
         Parameter.Add("@InvoiceNo", ((BL_EXPENCESTRANSACTION)classObject).InvoiceNo.ToString().Trim());
         Parameter.Add("@flag", "A");
         ds = blFill_Para_Name(Parameter, "SP_Expences_Transaction");
     }
     catch (Exception err)
     {
         err.GetBaseException();
     } return(ds);
 }
Esempio n. 6
0
        public Transportistas seleccionartransportista(int numerador)
        {
            try
            {
                SqlManager objSql = new SqlManager();
                Parameter  param  = new Parameter();
                param.Add("@numerador", numerador);


                Transportistas lista = objSql.getStatement <Transportistas>("USP_ListaTransportistas_Lst", param)[0];

                param = null;
                objSql.Dispose();
                objSql = null;

                return(lista);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 7
0
        public List <Reglamentos> ExtraerReglamento(int idReglamento)
        {
            SqlManager         objSql = new SqlManager(ConfigurationManager.AppSettings["ASOCEM"].ToString());
            List <Reglamentos> lista  = new List <Reglamentos>();

            try
            {
                Parameter param = new Parameter();
                param.Add("@idReglamento", idReglamento);

                lista = objSql.getStatement <Reglamentos>("USP_Reglamento_lst", param);
                if (lista.Count != 0)
                {
                    return(lista);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            return(lista);
        }
        public Autorizacionusuario LoginByCorreo(String Correo)
        {
            try
            {
                Autorizacionusuario logeo  = new Autorizacionusuario();
                SqlManager          objSql = new SqlManager();
                Parameter           param  = new Parameter();
                param.Add("@Correo", Correo);

                List <Autorizacionusuario> list = objSql.getStatement <Autorizacionusuario>("USP_Usuario_LoginByCorreo", param);
                if (list.Count > 0)
                {
                    logeo = list.First();
                }
                return(logeo);
            }
            catch (Exception ex)
            {
                //afilogDAO.Save(0, 0, "Autorizacionusuario login", "LoginByCorreo", ex);
                throw new Exception(ex.Message);
            }
        }
        public DataSet UPDATE(object classObject)
        {
            try
            {
                Query = "update Tbl_VotersMaster set TMvoters=@TMvoters,TFvoters=@TFvoters,Tvoters=@Tvoters,TSHvoters=@TSHvoters where plno=@PLNo and acno=@Acno and psno=@PSNo and subno=@Subno";
                Parameter.Clear();
                Parameter.Add("@TMvoters", ((BL_VOTERMASTER)classObject).TMVoters.ToString());
                Parameter.Add("@TFvoters", ((BL_VOTERMASTER)classObject).TFVoters.ToString());
                Parameter.Add("@Tvoters", ((BL_VOTERMASTER)classObject).TVoters.ToString());
                Parameter.Add("@TSHvoters", ((BL_VOTERMASTER)classObject).TSHVoters.ToString());
                Parameter.Add("@PLNo", ((BL_VOTERMASTER)classObject).PlNo.ToString());
                Parameter.Add("@Acno", ((BL_VOTERMASTER)classObject).AcNo.ToString());
                Parameter.Add("@PSNo", ((BL_VOTERMASTER)classObject).PsNo.ToString());
                Parameter.Add("@Subno", ((BL_VOTERMASTER)classObject).PsSubno.ToString());

                ExecuteNonQuery(Parameter, Query);
            }
            catch (Exception ex)
            {
            }
            return(SELECT(classObject));
        }
Esempio n. 10
0
        public DataSet UPDATE(object classObject)
        {
            try
            {
                # region Update Polling Detils
                Query = @"update Tbl_PollingDetails set TMVoting=@MaleVoting,TFVoting=@FemaleVoting,TSHVoting=@TSHVoting,TVoting=@TotalVoting,EpicVoting=@EpicVoting,OtherVoting=@OtherDocVoting,PMVoting=@PhotoVoting,F17a=@Column17a,MocPoll=@MockPollAgents,CHVoting=@TenderVoting,Flag='Y',ChallVoter=@ChallangedVoting,CpollProcess=@ComplaintPoll,ActionPoll=@ActionPoll,Evmrc=@ComplaintEvm,ActionEvm=@ActionEvm,Remarksaro=@RemarkARO,remarks=@Remark,After5PM=@After5PMYN,After5PMCount=@After5PMVoting where plno=@PlNo and acno=@AcNo and psno=@PsNo and subno=@PsSubno";
                Parameter.Clear();
                Parameter.Add("@MaleVoting ", ((BL_POLLINGDETAILS)classObject).MaleVoting.ToString());
                Parameter.Add("@FemaleVoting ", ((BL_POLLINGDETAILS)classObject).FemaleVoting.ToString());
                Parameter.Add("@TSHVoting ", ((BL_POLLINGDETAILS)classObject).TSHVoting.ToString());
                Parameter.Add("@TotalVoting ", ((BL_POLLINGDETAILS)classObject).TotalVoting.ToString());
                Parameter.Add("@EpicVoting ", ((BL_POLLINGDETAILS)classObject).EpicVoting.ToString());
                Parameter.Add("@OtherDocVoting ", ((BL_POLLINGDETAILS)classObject).OtherDocVoting.ToString());
                Parameter.Add("@PhotoVoting ", ((BL_POLLINGDETAILS)classObject).PhotoVoting.ToString());

                Parameter.Add("@Column17a ", ((BL_POLLINGDETAILS)classObject).Column17a.ToString());
                Parameter.Add("@MockPollAgents ", ((BL_POLLINGDETAILS)classObject).MockPollAgents.ToString());
                Parameter.Add("@TenderVoting ", ((BL_POLLINGDETAILS)classObject).TenderVoting.ToString());
                Parameter.Add("@ChallangedVoting ", ((BL_POLLINGDETAILS)classObject).ChallangedVoting.ToString());
                Parameter.Add("@ComplaintPoll ", ((BL_POLLINGDETAILS)classObject).ComplaintPoll.ToString());
                Parameter.Add("@ActionPoll ", ((BL_POLLINGDETAILS)classObject).ActionPoll.ToString());
                Parameter.Add("@ComplaintEvm ", ((BL_POLLINGDETAILS)classObject).ComplaintEvm.ToString());
                Parameter.Add("@ActionEvm ", ((BL_POLLINGDETAILS)classObject).ActionEvm.ToString());
                Parameter.Add("@RemarkARO ", ((BL_POLLINGDETAILS)classObject).RemarkARO.ToString());
                Parameter.Add("@Remark ", ((BL_POLLINGDETAILS)classObject).Remark.ToString());
                Parameter.Add("@After5PMYN ", ((BL_POLLINGDETAILS)classObject).After5PMYN.ToString());
                Parameter.Add("@After5PMVoting ", ((BL_POLLINGDETAILS)classObject).After5PMVoting.ToString());

                Parameter.Add("@PlNo ", ((BL_POLLINGDETAILS)classObject).PlNo.ToString());
                Parameter.Add("@AcNo ", ((BL_POLLINGDETAILS)classObject).AcNo.ToString());
                Parameter.Add("@PsNo ", ((BL_POLLINGDETAILS)classObject).PsNo.ToString());
                Parameter.Add("@PsSubno ", ((BL_POLLINGDETAILS)classObject).PsSubno.ToString());


                ExecuteNonQuery(Parameter, Query);

                # endregion

                # region Update Polling Other Details
        public List <Autorizacionusuario> GetUsuarioAutorizacionByTipoEntidad(String TipoEntidad)
        {
            try
            {
                Parameter param = new Parameter();
                param.Add("@TipoEntidad", TipoEntidad);

                SqlManager objSql = new SqlManager();
                List <Autorizacionusuario> lista = objSql.getStatement <Autorizacionusuario>("up_AutorizacionUsuario_SelectByTipoEntidad", param);

                objSql.Dispose();
                objSql = null;

                param = null;

                return(lista);
            }
            catch (Exception ex)
            {
                //afilogDAO.Save(0, 0, "Autorizacionusuario selectTipoentidad", "GetUsuarioAutorizacionByTipoEntidad", ex);
                throw ex;
            }
        }
        public DataSet INSERT(object classObject)
        {
            try
            {
                int maxid = 0;
                Query = "select max(maxid) from Tbl_Psmaster where plno=@PLNo and acno=@Acno";
                Parameter.Clear();
                Parameter.Add("@PLNo", ((BL_PSMASTER)classObject).PlNo.ToString());
                Parameter.Add("@Acno", ((BL_PSMASTER)classObject).AcNo.ToString());
                string ds = ExecuteScaler(Parameter, Query);
                //if (ds.Tables.Count >= 1 && ds.Tables[0].Rows.Count >= 1)
                //maxid = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
                maxid  = Convert.ToInt32(ds);
                maxid += 1;

                Query = "insert into Tbl_PsMaster values(" + maxid + ",@PLNo,	@Acno,	@PSNo,	@Subno,	@PSName,	@PSEngName,	@PSUNIName,	@PSLocation,	@PSEngLocation,	@PSUNILocation,	@EvmUsed)";
                Parameter.Clear();
                Parameter.Add("@PLNo", ((BL_PSMASTER)classObject).PlNo.ToString());
                Parameter.Add("@Acno", ((BL_PSMASTER)classObject).AcNo.ToString());
                Parameter.Add("@PSNo", ((BL_PSMASTER)classObject).PsNo.ToString());
                Parameter.Add("@Subno", ((BL_PSMASTER)classObject).PsSubno.ToString());
                Parameter.Add("@PSName", ((BL_PSMASTER)classObject).PsName.ToString());
                Parameter.Add("@PSEngName", ((BL_PSMASTER)classObject).PsEngName.ToString());
                Parameter.Add("@PSUNIName", ((BL_PSMASTER)classObject).PsUniName.ToString());
                Parameter.Add("@PSLocation", ((BL_PSMASTER)classObject).PsLocation.ToString());
                Parameter.Add("@PSEngLocation", ((BL_PSMASTER)classObject).PsEngLocation.ToString());
                Parameter.Add("@PSUNILocation", ((BL_PSMASTER)classObject).PsUniLocation.ToString());
                Parameter.Add("@EvmUsed", ((BL_PSMASTER)classObject).EvmUsed.ToString());
                ExecuteNonQuery(Parameter, Query);
            }

            catch (Exception ex)
            {
            }
            return(SELECT(classObject));
        }
        public BehaviorPage AddAnimal()
        {
            addAnimal.ClickCustom(driver);
            Sleep(3000);
            petType.ClickCustom(driver);
            Sleep();
            petType.SelectDropDown(driver, Parameter.Get <string>("PetType"));
            Sleep();
            Parameter.Add <string>("AnimalName", "Animal_" + FakeData.FirstName);
            animalName.SendKeysWrapper(Parameter.Get <string>("AnimalName"), driver);
            years.SendKeys(Parameter.Get <string>("Years"));
            years.SendKeys(Keys.Tab);
            primaryBreed.SelectByIndex(driver);
            primaryColor.SelectByIndex(driver);
            gender.SelectDropDown(driver, Parameter.Get <string>("Gender"));
            estAdultSize.SelectByIndex(driver);
            if (FindBy(noteType.GetLocator(), 1, true) != null)
            {
                noteType.SelectByIndex(driver);
            }

            nextButton.ClickCustom(driver);
            return(new BehaviorPage(driver));
        }
 public parametrogeneral GetParametroGeneralByIdSociedadLogistica(int idSociedadLogistica)
 {
     try
     {
         SqlManager objSql = new SqlManager(ConfigurationManager.AppSettings["BDSEGURIDAD"].ToString());
         Parameter  param  = new Parameter();
         param.Add("@idSociedadLogistica", idSociedadLogistica);
         List <parametrogeneral> lista = objSql.getStatement <parametrogeneral>("USP_ParametroGeneral_SelectByCodigo_Sociedad", param);
         if (lista != null && lista.Count > 0)
         {
             return(lista[0]);
         }
         else
         {
             return(new parametrogeneral());
         }
     }
     catch (Exception ex)
     {
         //afilogDAO.Save(0, 0, "parametrogeneral SelectByEmpresaId", "GetParametroGeneralByEmpresaId", ex);
     }
     //Rutina de Guardado en Log
     return(new parametrogeneral());
 }
Esempio n. 15
0
        static Dictionary <T, bool> GetExpectedVariations <T>() where T : ITestVariation, new()
        {
            Dictionary <T, bool> expectedVariations = new Dictionary <T, bool>();

            Parameter <int> intValue = new Parameter <int>("IntValue");

            intValue.Add(0);
            intValue.Add(5);
            intValue.Add(10);
            Parameter <bool> boolValue = new Parameter <bool>("BoolValue");

            boolValue.Add(true);
            Parameter <string> stringValue = new Parameter <string>("StringValue");

            stringValue.Add("There");
            stringValue.Add("be");
            stringValue.Add("giants");
            List <ParameterBase> parameters = new List <ParameterBase>()
            {
                intValue, boolValue, stringValue
            };

            Model <Variation> model = new Model <Variation>(parameters);

            foreach (Variation variation in model.GenerateVariations(2))
            {
                expectedVariations.Add(new T()
                {
                    BoolValue   = (bool)variation["BoolValue"],
                    IntValue    = (int)variation["IntValue"],
                    StringValue = (string)variation["StringValue"]
                },
                                       false);
            }
            return(expectedVariations);
        }
 public CameraSceneObjectModel(CameraItemModel itemModel) : base(itemModel)
 {
     Parameter.Add(new PositionModel());
     Parameter.Add(new RotationModel());
 }
Esempio n. 17
0
 /// <summary>
 /// Created a Prototype for a animated Image
 /// </summary>
 public AnimImage()
 {
     RenderName = GetType().FullName;
     Parameter.Add("FrameTime", FrameTime = new ValueWrapper <double>());
 }
Esempio n. 18
0
        public DataSet SELECT(object classObject)
        {
            DataSet ds = new DataSet();

            DataTable dt = ExecuteQuery("SELECT * FROM VW_CARD_COUNTS;").Tables[0].Copy();

            dt.TableName = "CARD_COUNTS";
            ds.Tables.Add(dt);

            dt           = ExecuteQuery("SELECT * FROM TOTALS;").Tables[0].Copy();
            dt.TableName = "TOTAL_CARD_COUNTS";
            ds.Tables.Add(dt);

            Parameter.Clear();
            Parameter.Add("@State_id", ((BL_MAIN_FORM)classObject).STATE_ID.ToString());
            Parameter.Add("@District_id", ((BL_MAIN_FORM)classObject).DISTRICT_ID.ToString());
            Parameter.Add("@Taluka_id", ((BL_MAIN_FORM)classObject).TALUKA_ID.ToString());
            Parameter.Add("@Village_id", ((BL_MAIN_FORM)classObject).VILLAGE_ID.ToString());
            Parameter.Add("@Shop_id", ((BL_MAIN_FORM)classObject).SHOP_ID.ToString());
            Query = @"SELECT Cardholder_id, State_id, District_id, Taluka_id, Village_id, Shop_id, Card_Reference_Number, E_Salutation, E_Fname, E_Mname, E_Lname,M_Salutation, M_Fname, M_Mname, M_Lname
                      FROM Tbl_CardholderMaster
                      where State_id=@State_id and District_id=@District_id and Taluka_id=@Taluka_id and Village_id=@Village_id and  Shop_id=@Shop_id and ISVERIFY='1'
                      order by State_id, District_id, Taluka_id, Village_id, Shop_id,Cardholder_id
                      ";

            dt = ExecuteQuery(Parameter, Query).Tables[0].Copy();
            DataColumn dc = new DataColumn("M_SHOW", typeof(System.String));

            dt.Columns.Add(dc);
            dc.SetOrdinal(1);
            dc = new DataColumn("SHOW", typeof(System.String));
            dt.Columns.Add(dc);
            dc.SetOrdinal(2);

            //dt.Columns.Add(new DataColumn("SHOW", typeof(System.String)));
            foreach (DataRow dr in dt.Rows)
            {
                dr["M_SHOW"] = dr["M_Salutation"].ToString() + " " + dr["M_Fname"].ToString() + " " + dr["M_Mname"].ToString() + " " + dr["M_Lname"].ToString();
                dr["SHOW"]   = dr["E_Salutation"].ToString() + " " + dr["E_Fname"].ToString() + " " + dr["E_Mname"].ToString() + " " + dr["E_Lname"].ToString();
            }
            dt.AcceptChanges();
            dt.TableName = "VERIFY Cards";
            ds.Tables.Add(dt);


            Parameter.Clear();
            Parameter.Add("@State_id", ((BL_MAIN_FORM)classObject).STATE_ID.ToString());
            Parameter.Add("@District_id", ((BL_MAIN_FORM)classObject).DISTRICT_ID.ToString());
            Parameter.Add("@Taluka_id", ((BL_MAIN_FORM)classObject).TALUKA_ID.ToString());
            Parameter.Add("@Village_id", ((BL_MAIN_FORM)classObject).VILLAGE_ID.ToString());
            Parameter.Add("@Shop_id", ((BL_MAIN_FORM)classObject).SHOP_ID.ToString());
            Query = @"SELECT Cardholder_id, State_id, District_id, Taluka_id, Village_id, Shop_id, Card_Reference_Number, E_Salutation, E_Fname, E_Mname, E_Lname,M_Salutation, M_Fname, M_Mname, M_Lname
                      FROM Tbl_CardholderMaster
                      where State_id=@State_id and District_id=@District_id and Taluka_id=@Taluka_id and Village_id=@Village_id and  Shop_id=@Shop_id and ISVERIFY='0'
                      order by State_id, District_id, Taluka_id, Village_id, Shop_id,Cardholder_id desc
                      ";

            dt = ExecuteQuery(Parameter, Query).Tables[0].Copy();
            dc = new DataColumn("M_SHOW", typeof(System.String));
            dt.Columns.Add(dc);
            dc.SetOrdinal(1);
            dc = new DataColumn("SHOW", typeof(System.String));
            dt.Columns.Add(dc);
            dc.SetOrdinal(2);

            //dt.Columns.Add(new DataColumn("SHOW", typeof(System.String)));
            foreach (DataRow dr in dt.Rows)
            {
                dr["M_SHOW"] = dr["M_Salutation"].ToString() + " " + dr["M_Fname"].ToString() + " " + dr["M_Mname"].ToString() + " " + dr["M_Lname"].ToString();
                dr["SHOW"]   = dr["E_Salutation"].ToString() + " " + dr["E_Fname"].ToString() + " " + dr["E_Mname"].ToString() + " " + dr["E_Lname"].ToString();
            }
            dt.AcceptChanges();
            dt.TableName = "NOT VERIFY Cards";
            ds.Tables.Add(dt);

            return(ds);
        }
Esempio n. 19
0
 /// <summary>
 /// Creates a Prototype for an image
 /// </summary>
 public Image()
 {
     RenderName = GetType().FullName;
     Parameter.Add("Url", Url = new ValueWrapper <string>());
 }
Esempio n. 20
0
 /// <summary>
 /// Creates the base prototype that has a colored representation
 /// </summary>
 public RenderingBase()
 {
     RenderName = GetType().FullName;
     Parameter.Add("ForeColor", ForeColor = new ValueWrapper <Color>());
     Parameter.Add("BackColor", BackColor = new ValueWrapper <Color>());
 }
Esempio n. 21
0
 /// <summary>
 /// Creates a Prototype for a single line
 /// </summary>
 public Line()
 {
     RenderName             = GetType().FullName;
     Parameter.Add("X2", X2 = new ValueWrapper <ScreenPos>());
     Parameter.Add("Y2", Y2 = new ValueWrapper <ScreenPos>());
 }
Esempio n. 22
0
 public void Initialize()
 {
     Parameter.Add <string>("Client", "ENRICHMENT");
     this.CollectSharedParameters();
     driver = (new WebDriver()).InitDriver(Parameter.Get <string>("Url"));
 }
        public DataSet INSERT(object classObject)
        {
            DataSet r_ds = new DataSet();

            try
            {
                #region
                ////    blFill_Para_Name(
                //    //Card holder table
                //    Query = "insert into Tbl_CardholderMaster values(@Cardholder_id, @State_id,@District_id,  @Taluka_id, @Village_id, @Shop_id, @CardType_id, @Card_Reference_Number, @Gender, @E_Salutation,@E_Fname, @E_Mname, @E_Lname, @M_Salutation, @M_Fname, @M_Mname, @M_Lname, @Total_Unit, @Total_Person, @Ration_Card_Number, @Bank_id, @Bank_Account_Number, @Card_Unique_Number, @Isgas, @Gas_Qty, @Createdon, @Createdby, @Updatedon, @Updatedby, @IsActive)";
                //    Parameter.Clear();
                //    Parameter.Add("@Cardholder_id", ((BL_ACMASTER)classObject).Cardholder_id.ToString());
                //    Parameter.Add("@State_id", ((BL_ACMASTER)classObject).State_id.ToString());
                //    Parameter.Add("@District_id", ((BL_ACMASTER)classObject).District_id.ToString());
                //    Parameter.Add("@Taluka_id", ((BL_ACMASTER)classObject).Taluka_id.ToString());
                //    Parameter.Add("@Village_id", ((BL_ACMASTER)classObject).Village_id.ToString());

                //    Parameter.Add("@Shop_id", ((BL_ACMASTER)classObject).Shop_id.ToString());
                //    Parameter.Add("@CardType_id", ((BL_ACMASTER)classObject).CardType_id.ToString());
                //    Parameter.Add("@Card_Reference_Number", ((BL_ACMASTER)classObject).Card_Reference_Number.ToString());
                //    Parameter.Add("@Gender", ((BL_ACMASTER)classObject).Gender.ToString());

                //    Parameter.Add("@E_Salutation", ((BL_ACMASTER)classObject).E_Salutation.ToString());
                //    Parameter.Add("@E_Fname", ((BL_ACMASTER)classObject).E_Fname.ToString());
                //    Parameter.Add("@E_Mname", ((BL_ACMASTER)classObject).E_Mname.ToString());
                //    Parameter.Add("@E_Lname", ((BL_ACMASTER)classObject).E_Lname.ToString());

                //    Parameter.Add("@M_Salutation", ((BL_ACMASTER)classObject).M_Salutation.ToString());
                //    Parameter.Add("@M_Fname", ((BL_ACMASTER)classObject).M_Fname.ToString());
                //    Parameter.Add("@M_Mname", ((BL_ACMASTER)classObject).M_Mname.ToString());
                //    Parameter.Add("@M_Lname", ((BL_ACMASTER)classObject).M_Lname.ToString());

                //    Parameter.Add("@Total_Unit", ((BL_ACMASTER)classObject).Total_Unit.ToString());
                //    Parameter.Add("@Total_Person", ((BL_ACMASTER)classObject).Total_Person.ToString());
                //    Parameter.Add("@Ration_Card_Number", ((BL_ACMASTER)classObject).Ration_Card_Number.ToString());
                //    Parameter.Add("@Bank_id", ((BL_ACMASTER)classObject).Bank_id.ToString());

                //    Parameter.Add("@Bank_Account_Number", ((BL_ACMASTER)classObject).Bank_Account_Number.ToString());
                //    Parameter.Add("@Card_Unique_Number", ((BL_ACMASTER)classObject).Card_Unique_Number.ToString());
                //    Parameter.Add("@Isgas", ((BL_ACMASTER)classObject).Isgas.ToString());
                //    Parameter.Add("@Gas_Qty", ((BL_ACMASTER)classObject).Gas_Qty.ToString());

                //    Parameter.Add("@Createdon", ((BL_ACMASTER)classObject).Createdon.ToString());
                //    Parameter.Add("@Createdby", ((BL_ACMASTER)classObject).Createdby.ToString());
                //    Parameter.Add("@Updatedon", ((BL_ACMASTER)classObject).Updatedon.ToString());
                //    Parameter.Add("@Updatedby", ((BL_ACMASTER)classObject).Updatedby.ToString());
                //    Parameter.Add("@IsActive", ((BL_ACMASTER)classObject).IsActive.ToString());

                //    StringBuilder x = new StringBuilder("");
                //    x.Append(Fill_CardHolder.Instance.Cardholder_Details.DataSet.GetXml());


                //    ParaNameValue.Add("@Menudata", x.ToString());
                //    //ParaNameValue.Add("@Group_Menu_id", ("");
                //    //ParaNameValue.Add("@Menu_id", ((MENU_MASTER)classObject).Menu_Url.ToString());
                //    ParaNameValue.Add("@flag", "A");
                //    DataSet ds = EXECUTE_PROCEDURE(ParaNameValue, "Sp_Menu_Permission");
                //    Fill_Menu_Grid.Instance.Menu_Details.Clear();
                //    ds.Tables.Clear();

                //    return ds;



                //    ExecuteNonQuery(Parameter, Query);

                //    Query = "insert into Tbl_CardholderwiseMember values(@Cardmember_id, @Cardholder_id, @State_id, @District_id, @Taluka_id, @2Village_id, @Shop_id, @Machine_Unique_Number, @Gender, @E_Salutation, @E_M_Fname, @2E_M_Mname, @E_M_Lname, @M_Salutation, @M_M_Fname,@M_M_Mname, @M_M_Lname, @Finger, @Member_Flag, @Isregister, @Card_Unique_Number, @Adhar_Number, @Age, @LImage, @RImage, @Createdon, @Createdby, @Updatedon, @2Updatedby, @IsActive)";
                //    Parameter.Clear();
                //    Parameter.Add("@Cardmember_id", ((BL_ACMASTER)classObject).Cardmember_id.ToString());
                //    Parameter.Add("@Cardholder_id", ((BL_ACMASTER)classObject).Cardholder_id.ToString());
                //    Parameter.Add("@State_id", ((BL_ACMASTER)classObject).State_id.ToString());
                //    Parameter.Add("@District_id", ((BL_ACMASTER)classObject).District_id.ToString());
                //    Parameter.Add("@Taluka_id", ((BL_ACMASTER)classObject).Taluka_id.ToString());
                //    Parameter.Add("@Village_id", ((BL_ACMASTER)classObject).Village_id.ToString());

                //    Parameter.Add("@Shop_id", ((BL_ACMASTER)classObject).Shop_id.ToString());

                //    Parameter.Add("@Machine_Unique_Number", ((BL_ACMASTER)classObject).Machine_Unique_Number.ToString());
                //    Parameter.Add("@Gender", ((BL_ACMASTER)classObject).Gender.ToString());

                //    Parameter.Add("@E_Salutation", ((BL_ACMASTER)classObject).E_Salutation.ToString());
                //    Parameter.Add("@E_M_Fname", ((BL_ACMASTER)classObject).E_M_Fname.ToString());
                //    Parameter.Add("@E_M_Mname", ((BL_ACMASTER)classObject).E_M_Mname.ToString());
                //    Parameter.Add("@E_M_Lname", ((BL_ACMASTER)classObject).E_M_Lname.ToString());

                //    Parameter.Add("@M_Salutation", ((BL_ACMASTER)classObject).M_Salutation.ToString());
                //    Parameter.Add("@M_M_Fname", ((BL_ACMASTER)classObject).M_M_Fname.ToString());
                //    Parameter.Add("@M_M_Mname", ((BL_ACMASTER)classObject).M_M_Mname.ToString());
                //    Parameter.Add("@M_M_Lname", ((BL_ACMASTER)classObject).M_M_Lname.ToString());

                //    Parameter.Add("@Finger", ((BL_ACMASTER)classObject).Finger.ToString());
                //    Parameter.Add("@Member_Flag", ((BL_ACMASTER)classObject).Member_Flag.ToString());
                //    Parameter.Add("@Isregister", ((BL_ACMASTER)classObject).Isregister.ToString());
                //    Parameter.Add("@Card_Unique_Number", ((BL_ACMASTER)classObject).Card_Unique_Number.ToString());

                //    Parameter.Add("@Adhar_Number", ((BL_ACMASTER)classObject).Bank_Account_Number.ToString());
                //    Parameter.Add("@Age", ((BL_ACMASTER)classObject).Age.ToString());
                //    Parameter.Add("@LImage", ((BL_ACMASTER)classObject).LImage.ToString());
                //    Parameter.Add("@RImage", ((BL_ACMASTER)classObject).RImage.ToString());

                //    Parameter.Add("@Createdon", ((BL_ACMASTER)classObject).Createdon.ToString());
                //    Parameter.Add("@Createdby", ((BL_ACMASTER)classObject).Createdby.ToString());
                //    Parameter.Add("@Updatedon", ((BL_ACMASTER)classObject).Updatedon.ToString());
                //    Parameter.Add("@Updatedby", ((BL_ACMASTER)classObject).Updatedby.ToString());
                //    Parameter.Add("@IsActive", ((BL_ACMASTER)classObject).IsActive.ToString());
                #endregion
                if (((BL_IMPORTDB_UPDATE)classObject).Flag == "1")
                {
                    Parameter.Clear();
                    Parameter.Add("@Path", ((BL_IMPORTDB_UPDATE)classObject).Path);
                    Parameter.Add("@Flag", "1");
                    r_ds = blFill_Para_Name(Parameter, "SP_FORDATAENTRY_Fill_MASTER_MEMBER_For_BEED");
                }
                if (((BL_IMPORTDB_UPDATE)classObject).Flag == "2")
                {
                    Parameter.Clear();
                    Parameter.Add("@Path", ((BL_IMPORTDB_UPDATE)classObject).Path);
                    Parameter.Add("@Flag", "2");
                    r_ds = blFill_Para_Name(Parameter, "SP_FORDATAENTRY_Fill_MASTER_MEMBER_For_BEED");
                }
                //Parameter.Clear();
                //Parameter.Add("@Path", ((BL_IMPORTDB_UPDATE)classObject).Path);
                //Parameter.Add("@Flag", "3");
                //r_ds = blFill_Para_Name(Parameter, "SP_FORDATAENTRY_Fill_MASTER_MEMBER_For_BEED");
            }
            catch (Exception ex)
            {
            }
            return(r_ds);
        }
        public DataSet DELETE(object classObject)
        {
            DataSet ds = new DataSet();

            try
            {
                Parameter.Clear();
                if (((BL_BILLINGINVOICE)classObject).form.ToString().Trim() == "SI")
                {
                    Parameter.Add("@Tras_Date", ((BL_BILLINGINVOICE)classObject).Tras_Date.ToString().Trim());
                    Parameter.Add("@Customer_Id", ((BL_BILLINGINVOICE)classObject).Customer_Id.ToString().Trim());
                    Parameter.Add("@Amount", ((BL_BILLINGINVOICE)classObject).Total.ToString().Trim());
                    Parameter.Add("@Grand_Total", ((BL_BILLINGINVOICE)classObject).Grand_Total.ToString().Trim());
                    Parameter.Add("@Paid", ((BL_BILLINGINVOICE)classObject).Paid.ToString().Trim());
                    Parameter.Add("@On_Credit", ((BL_BILLINGINVOICE)classObject).On_Credit.ToString().Trim());
                    Parameter.Add("@Discount", ((BL_BILLINGINVOICE)classObject).Discount.ToString().Trim());
                    Parameter.Add("@Vat", ((BL_BILLINGINVOICE)classObject).Vat.ToString().Trim());
                    Parameter.Add("@Transportation_Id", "0");
                    Parameter.Add("@Carton", ((BL_BILLINGINVOICE)classObject).Carton.ToString().Trim());
                    Parameter.Add("@flag", "UI");
                    ds = blFill_Para_Name(Parameter, "Sp_SalesInvoice");
                }
                if (((BL_BILLINGINVOICE)classObject).form.ToString().Trim() == "SP")
                {
                    Parameter.Add("@Tras_Date", ((BL_BILLINGINVOICE)classObject).Tras_Date.ToString().Trim());
                    Parameter.Add("@Sales_Details_id", ((BL_BILLINGINVOICE)classObject).Sales_Details_id.ToString().Trim());
                    Parameter.Add("@Invoice_Number", ((BL_BILLINGINVOICE)classObject).Invoice_Number.ToString().Trim());
                    Parameter.Add("@Sales_Id", ((BL_BILLINGINVOICE)classObject).Sales_Id.ToString().Trim());
                    Parameter.Add("@SubItemId", ((BL_BILLINGINVOICE)classObject).SubItemId.ToString().Trim());
                    Parameter.Add("@Quantity", ((BL_BILLINGINVOICE)classObject).Quantity.ToString().Trim());
                    Parameter.Add("@Rate", ((BL_BILLINGINVOICE)classObject).Rate.ToString().Trim());
                    Parameter.Add("@Total", ((BL_BILLINGINVOICE)classObject).Amount.ToString().Trim());
                    Parameter.Add("@flag", "DP");
                    ds = blFill_Para_Name(Parameter, "Sp_SalesInvoice");
                }
                if (((BL_BILLINGINVOICE)classObject).form.ToString().Trim() == "PI")
                {
                    Parameter.Add("@Invoice_Number", ((BL_BILLINGINVOICE)classObject).Invoice_Number.ToString().Trim());
                    Parameter.Add("@Tran_Date", ((BL_BILLINGINVOICE)classObject).Tras_Date.ToString().Trim());
                    Parameter.Add("@Customer_Id", ((BL_BILLINGINVOICE)classObject).Customer_Id.ToString().Trim());
                    Parameter.Add("@Sub_Total", ((BL_BILLINGINVOICE)classObject).Total.ToString().Trim());
                    Parameter.Add("@Tax", ((BL_BILLINGINVOICE)classObject).Vat.ToString().Trim());
                    Parameter.Add("@Grand_Total", ((BL_BILLINGINVOICE)classObject).Grand_Total.ToString().Trim());
                    Parameter.Add("@ExciseDuety", ((BL_BILLINGINVOICE)classObject).Discount.ToString().Trim());
                    Parameter.Add("@Paid", ((BL_BILLINGINVOICE)classObject).Paid.ToString().Trim());
                    Parameter.Add("@On_Credit", ((BL_BILLINGINVOICE)classObject).On_Credit.ToString().Trim());
                    Parameter.Add("@flag", "AI");
                    ds = blFill_Para_Name(Parameter, "Sp_PurchaseInvoice");
                }
                if (((BL_BILLINGINVOICE)classObject).form.ToString().Trim() == "PP")
                {
                    Parameter.Add("@Purchase_Item_id", ((BL_BILLINGINVOICE)classObject).Sales_Details_id.ToString().Trim());
                    Parameter.Add("@Purchase_Id", ((BL_BILLINGINVOICE)classObject).Sales_Id.ToString().Trim());
                    Parameter.Add("@Invoice_Number", ((BL_BILLINGINVOICE)classObject).Invoice_Number.ToString().Trim());
                    Parameter.Add("@SubItemId", ((BL_BILLINGINVOICE)classObject).SubItemId.ToString().Trim());
                    Parameter.Add("@Quantity", ((BL_BILLINGINVOICE)classObject).Quantity.ToString().Trim());
                    Parameter.Add("@Prise", ((BL_BILLINGINVOICE)classObject).Rate.ToString().Trim());
                    Parameter.Add("@Total", ((BL_BILLINGINVOICE)classObject).Amount.ToString().Trim());
                    Parameter.Add("@Tran_Date", ((BL_BILLINGINVOICE)classObject).Tras_Date.ToString().Trim());
                    Parameter.Add("@flag", "DP");
                    ds = blFill_Para_Name(Parameter, "Sp_PurchaseInvoice");
                }
                if (((BL_BILLINGINVOICE)classObject).form.ToString().Trim() == "PY")
                {
                    Parameter.Add("@PayModeId", ((BL_BILLINGINVOICE)classObject).PayModeId.ToString().Trim());
                    Parameter.Add("@Number", ((BL_BILLINGINVOICE)classObject).Number.ToString().Trim());
                    Parameter.Add("@Details", ((BL_BILLINGINVOICE)classObject).Details.ToString().Trim());
                    Parameter.Add("@Tras_Date", ((BL_BILLINGINVOICE)classObject).Tras_Date.ToString().Trim());
                    Parameter.Add("@Pay_Mode_Id", ((BL_BILLINGINVOICE)classObject).Pay_Mode_Id.ToString().Trim());
                    Parameter.Add("@Billing_ID", ((BL_BILLINGINVOICE)classObject).Sales_Id.ToString().Trim());
                    Parameter.Add("@Invoice_Type", ((BL_BILLINGINVOICE)classObject).flag.ToString().Trim());
                    Parameter.Add("@flag", "PY");
                    ds = blFill_Para_Name(Parameter, "Sp_SalesInvoice");
                }
                if (((BL_BILLINGINVOICE)classObject).form.ToString().Trim() == "TP")
                {
                    Parameter.Add("@TrasportEmp_Id", ((BL_BILLINGINVOICE)classObject).TrasportEmp_Id.ToString().Trim());
                    Parameter.Add("@TEmployee_Name", ((BL_BILLINGINVOICE)classObject).TEmployee_Name.ToString().Trim());
                    Parameter.Add("@TVehicale_Number", ((BL_BILLINGINVOICE)classObject).TVehicale_Number.ToString().Trim());
                    Parameter.Add("@TEmployee_Number", ((BL_BILLINGINVOICE)classObject).TEmployee_Number.ToString().Trim());
                    Parameter.Add("@Transportation_Id", ((BL_BILLINGINVOICE)classObject).Transportation.ToString().Trim());
                    Parameter.Add("@Sales_Id", ((BL_BILLINGINVOICE)classObject).Sales_Id.ToString().Trim());
                    Parameter.Add("@flag", "TP");
                    ds = blFill_Para_Name(Parameter, "Sp_SalesInvoice");
                }
            }
            catch (Exception err)
            {
                err.GetBaseException();
            }
            return(ds);
            //throw new NotImplementedException();
        }
Esempio n. 25
0
 public DataSet SELECT1(object classObject)
 {
     Parameter.Clear();
     Parameter.Add("@RootId", ((BL_ROOTTRANSACTION)classObject).RootId.ToString().Trim());
     return(blFill_Para_Name(Parameter, "SP_RootTransaction"));
 }
Esempio n. 26
0
        public bool Actualizar(Cliente objEntidad)
        {
            SqlManager objSql    = new SqlManager();
            bool       resultado = false;
            Parameter  param     = new Parameter();

            param.Add("@IdCliente", objEntidad.IdCliente);
            param.Add("@CodigoEmpresa", objEntidad.CodigoEmpresa);
            param.Add("@CodigoCliente", objEntidad.CodigoCliente);
            param.Add("@CodigoUbigeo", objEntidad.CodigoUbigeo);
            param.Add("@RazonSocial", objEntidad.RazonSocial);
            param.Add("@Direccion", objEntidad.Direccion);
            param.Add("@DireccionCobranza", objEntidad.DireccionCobranza);
            param.Add("@IdCatalogo", objEntidad.IdCatalogo);
            param.Add("@Telefono", objEntidad.Telefono);
            param.Add("@Ruc", objEntidad.Ruc);
            param.Add("@EstadoRegistro", objEntidad.EstadoRegistro);
            param.Add("@TipoDocumento", objEntidad.TipoDocumento);
            param.Add("@ContactoCliente", objEntidad.ContactoCliente);
            param.Add("@CodSociedad", objEntidad.CodSociedad);

            try
            {
                objSql.ExecuteNonQuery("USP_Actualizar_Cliente", param);
                resultado = true;
            }
            catch (Exception)
            {
                //afilogDAO.Save(0, 0, "Sincronizar cliente", "registrar", ex);
                resultado = false;
            }
            //Rutina de Guardado en Log
            return(resultado);
        }
Esempio n. 27
0
        public bool Registrar(Cliente objEntidad)
        {
            SqlManager objSql    = new SqlManager();
            bool       resultado = false;
            Parameter  param     = new Parameter();

            param.Add("@CodigoEmpresa", objEntidad.CodigoEmpresa);
            param.Add("@CodigoCliente", objEntidad.CodigoCliente);
            param.Add("@CodigoUbigeo", objEntidad.CodigoUbigeo);
            param.Add("@RazonSocial", objEntidad.RazonSocial);
            param.Add("@Direccion", objEntidad.Direccion);
            param.Add("@DireccionCobranza", objEntidad.DireccionCobranza);
            param.Add("@IdCatalogo", objEntidad.IdCatalogo);
            param.Add("@Telefono", objEntidad.Telefono);
            param.Add("@Ruc", objEntidad.Ruc);
            param.Add("@EstadoRegistro", objEntidad.EstadoRegistro);
            param.Add("@TipoDocumento", objEntidad.TipoDocumento);
            param.Add("@ContactoCliente", objEntidad.ContactoCliente);
            param.Add("@CodSociedad", objEntidad.CodSociedad);

            try
            {
                objSql.ExecuteNonQuery("USP_Registrar_Cliente", param);
                resultado = true;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(resultado);
        }
Esempio n. 28
0
        public DataSet INSERT(object classObject)
        {
            try
            {
                #region  maxid for pollingdetails
                int maxid = 0;
                Query = "select max(maxid) from Tbl_Pollingdetails where plno=@PlNo and acno=@Acno and psno=@PsNo and subno=@subno";
                Parameter.Clear();
                Parameter.Add("@PLNo", ((BL_POLLINGDETAILS)classObject).PlNo.ToString());
                Parameter.Add("@Acno", ((BL_POLLINGDETAILS)classObject).AcNo.ToString());
                Parameter.Add("@PsNo", ((BL_POLLINGDETAILS)classObject).PsNo.ToString());
                Parameter.Add("@SubNo", ((BL_POLLINGDETAILS)classObject).PsSubno.ToString());

                string ds = ExecuteScaler(Parameter, Query);
                //if (ds.Tables.Count >= 1 && ds.Tables[0].Rows.Count >= 1)
                //maxid = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
                maxid  = Convert.ToInt32(ds.Trim() == "" ? "0" : ds);
                maxid += 1;
                #endregion

                #region insert in polling details
                Query = @"insert into Tbl_PollingDetails values(" + maxid.ToString() + ",@PlNo,@AcNo,@PsNo,@PsSubno,@MaleVoting,@FemaleVoting,@TSHVoting,@TotalVoting,@EpicVoting,@OtherDocVoting,@PhotoVoting,@Column17a,@MockPollAgents,@TenderVoting,'Y',@ChallangedVoting,@ComplaintPoll,@ActionPoll,@ComplaintEvm,@ActionEvm,@RemarkARO,@Remark,@After5PMYN,@After5PMVoting)";
                Parameter.Clear();
                Parameter.Add("@PlNo ", ((BL_POLLINGDETAILS)classObject).PlNo.ToString());
                Parameter.Add("@AcNo ", ((BL_POLLINGDETAILS)classObject).AcNo.ToString());
                Parameter.Add("@PsNo ", ((BL_POLLINGDETAILS)classObject).PsNo.ToString());
                Parameter.Add("@PsSubno ", ((BL_POLLINGDETAILS)classObject).PsSubno.ToString());
                Parameter.Add("@MaleVoting ", ((BL_POLLINGDETAILS)classObject).MaleVoting.ToString());
                Parameter.Add("@FemaleVoting ", ((BL_POLLINGDETAILS)classObject).FemaleVoting.ToString());
                Parameter.Add("@TSHVoting ", ((BL_POLLINGDETAILS)classObject).TSHVoting.ToString());
                Parameter.Add("@TotalVoting ", ((BL_POLLINGDETAILS)classObject).TotalVoting.ToString());
                Parameter.Add("@EpicVoting ", ((BL_POLLINGDETAILS)classObject).EpicVoting.ToString());
                Parameter.Add("@OtherDocVoting ", ((BL_POLLINGDETAILS)classObject).OtherDocVoting.ToString());
                Parameter.Add("@PhotoVoting ", ((BL_POLLINGDETAILS)classObject).PhotoVoting.ToString());

                Parameter.Add("@Column17a ", ((BL_POLLINGDETAILS)classObject).Column17a.ToString());
                Parameter.Add("@MockPollAgents ", ((BL_POLLINGDETAILS)classObject).MockPollAgents.ToString());
                Parameter.Add("@TenderVoting ", ((BL_POLLINGDETAILS)classObject).TenderVoting.ToString());
                Parameter.Add("@ChallangedVoting ", ((BL_POLLINGDETAILS)classObject).ChallangedVoting.ToString());
                Parameter.Add("@ComplaintPoll ", ((BL_POLLINGDETAILS)classObject).ComplaintPoll.ToString());
                Parameter.Add("@ActionPoll ", ((BL_POLLINGDETAILS)classObject).ActionPoll.ToString());
                Parameter.Add("@ComplaintEvm ", ((BL_POLLINGDETAILS)classObject).ComplaintEvm.ToString());
                Parameter.Add("@ActionEvm ", ((BL_POLLINGDETAILS)classObject).ActionEvm.ToString());
                Parameter.Add("@RemarkARO ", ((BL_POLLINGDETAILS)classObject).RemarkARO.ToString());
                Parameter.Add("@Remark ", ((BL_POLLINGDETAILS)classObject).Remark.ToString());
                Parameter.Add("@After5PMYN ", ((BL_POLLINGDETAILS)classObject).After5PMYN.ToString());
                Parameter.Add("@After5PMVoting ", ((BL_POLLINGDETAILS)classObject).After5PMVoting.ToString());

                ExecuteNonQuery(Parameter, Query);
                #endregion

                #region maxid for pollingotherdeatils
                maxid = 0;
                Query = "select max(maxid) from Tbl_PollingOtherdetails where plno=@PlNo and acno=@Acno and psno=@PsNo and subno=@subno";
                Parameter.Clear();
                Parameter.Add("@PLNo", ((BL_POLLINGDETAILS)classObject).PlNo.ToString());
                Parameter.Add("@Acno", ((BL_POLLINGDETAILS)classObject).AcNo.ToString());
                Parameter.Add("@PsNo", ((BL_POLLINGDETAILS)classObject).PsNo.ToString());
                Parameter.Add("@SubNo", ((BL_POLLINGDETAILS)classObject).PsSubno.ToString());

                ds = ExecuteScaler(Parameter, Query);
                //if (ds.Tables.Count >= 1 && ds.Tables[0].Rows.Count >= 1)
                //maxid = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
                maxid  = Convert.ToInt32(ds.Trim() == "" ? "0" : ds);
                maxid += 1;

                #endregion

                #region inset in polling other details
                Query = @"insert into tbl_pollingOtherdetails values(" + maxid.ToString() + ",@PlNo,@AcNo,@PsNo,@PsSubno,@WithoutAnyIndentityVoting,@HandicapRampVoting,@BRAILWVoting,@BrailWOVoting,@RejectUnder49o,'Y',@THadicapVoting)";
                Parameter.Clear();

                Parameter.Add("@PlNo ", ((BL_POLLINGDETAILS)classObject).PlNo.ToString());
                Parameter.Add("@AcNo ", ((BL_POLLINGDETAILS)classObject).AcNo.ToString());
                Parameter.Add("@PsNo ", ((BL_POLLINGDETAILS)classObject).PsNo.ToString());
                Parameter.Add("@PsSubno ", ((BL_POLLINGDETAILS)classObject).PsSubno.ToString());


                Parameter.Add("@WithoutAnyIndentityVoting ", ((BL_POLLINGDETAILS)classObject).WithoutAnyIndentityVoting.ToString());
                Parameter.Add("@HandicapRampVoting ", ((BL_POLLINGDETAILS)classObject).HandicapRampVoting.ToString());
                Parameter.Add("@BRAILWVoting ", ((BL_POLLINGDETAILS)classObject).BRAILWVoting.ToString());
                Parameter.Add("@BrailWOVoting ", ((BL_POLLINGDETAILS)classObject).BrailWOVoting.ToString());
                Parameter.Add("@RejectUnder49o", ((BL_POLLINGDETAILS)classObject).RejectUnder49o.ToString());
                Parameter.Add("@THadicapVoting ", ((BL_POLLINGDETAILS)classObject).THadicapVoting.ToString());

                ExecuteNonQuery(Parameter, Query);
                #endregion
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }
            return(SELECT(classObject));
        }
Esempio n. 29
0
 public static Parameter AddMore(this Parameter parameter, string name, object value)
 {
     parameter.Add(name, value);
     return(parameter);
 }