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
}
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;
}
}
/// <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);
}
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);
}
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;
}
}
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));
}
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());
}
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());
}
/// <summary>
/// Created a Prototype for a animated Image
/// </summary>
public AnimImage()
{
RenderName = GetType().FullName;
Parameter.Add("FrameTime", FrameTime = new ValueWrapper <double>());
}
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);
}
/// <summary>
/// Creates a Prototype for an image
/// </summary>
public Image()
{
RenderName = GetType().FullName;
Parameter.Add("Url", Url = new ValueWrapper <string>());
}
/// <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>());
}
/// <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>());
}
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();
}
public DataSet SELECT1(object classObject)
{
Parameter.Clear();
Parameter.Add("@RootId", ((BL_ROOTTRANSACTION)classObject).RootId.ToString().Trim());
return(blFill_Para_Name(Parameter, "SP_RootTransaction"));
}
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);
}
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);
}
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));
}
public static Parameter AddMore(this Parameter parameter, string name, object value)
{
parameter.Add(name, value);
return(parameter);
}