public DataSet Select_Data(tbl_UpdatePartnersPreferencesProp Objtbl_UpdatePartnersPreferencesProp)
{
SqlCommand cmdToExecute = new SqlCommand();
cmdToExecute.CommandText = "Select_tbl_UpdatePartnersPreferences";
cmdToExecute.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
SqlDataAdapter da = null;
// Use base class' connection object
cmdToExecute.Connection = objdb.objConnection;
int _TotalCount = 0;
try
{
objdb.GetConnStr();
cmdToExecute.Parameters.Add(new SqlParameter("@MemberCode", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.MemberCode));
da = new SqlDataAdapter(cmdToExecute);
da.Fill(ds);
return(ds);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Search_Data(tbl_UpdatePartnersPreferencesProp Objtbl_UpdatePartnersPreferencesProp)
{
try
{
tbl_UpdatePartnersPreferencesDAL Objtbl_UpdatePartnersPreferencesDAL = new tbl_UpdatePartnersPreferencesDAL();
return(Objtbl_UpdatePartnersPreferencesDAL.Search_Data(Objtbl_UpdatePartnersPreferencesProp));
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete_Data(tbl_UpdatePartnersPreferencesProp Objtbl_UpdatePartnersPreferencesProp)
{
try
{
tbl_UpdatePartnersPreferencesDAL Objtbl_UpdatePartnersPreferencesDAL = new tbl_UpdatePartnersPreferencesDAL();
return(Objtbl_UpdatePartnersPreferencesDAL.Delete_Data(Objtbl_UpdatePartnersPreferencesProp));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Select_Data(tbl_UpdatePartnersPreferencesProp Objtbl_UpdatePartnersPreferencesProp)
{
try
{
tbl_UpdatePartnersPreferencesDAL Objtbl_UpdatePartnersPreferencesDAL = new tbl_UpdatePartnersPreferencesDAL();
DataSet dsData = Objtbl_UpdatePartnersPreferencesDAL.Select_Data(Objtbl_UpdatePartnersPreferencesProp);
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete_Data(tbl_UpdatePartnersPreferencesProp Objtbl_UpdatePartnersPreferencesProp)
{
try
{
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("Delete_tbl_UpdatePartnersPreferences");
//return DB.ExecuteNonQuery(DBCmd);
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertUpdate_Data(tbl_UpdatePartnersPreferencesProp Objtbl_UpdatePartnersPreferencesProp)
{
int _RetVal = 0;
SqlCommand cmdToExecute = new SqlCommand();
cmdToExecute.CommandText = "InsertUpdate_tbl_UpdatePartnersPreferences";
cmdToExecute.CommandType = CommandType.StoredProcedure;
// Use base class' connection object
cmdToExecute.Connection = objdb.objConnection;
try
{
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("InsertUpdate_tbl_UpdatePartnersPreferences");
cmdToExecute.Parameters.Add(new SqlParameter("@MemberCode", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.MemberCode));
cmdToExecute.Parameters.Add(new SqlParameter("@AgeFrom", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.AgeFrom));
cmdToExecute.Parameters.Add(new SqlParameter("@AgeTo", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.AgeTo));
cmdToExecute.Parameters.Add(new SqlParameter("@HeightFrom", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.HeightFrom));
cmdToExecute.Parameters.Add(new SqlParameter("@HeightTo", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.HeightTo));
cmdToExecute.Parameters.Add(new SqlParameter("@MaritalStatus", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.MaritalStatus));
cmdToExecute.Parameters.Add(new SqlParameter("@HaveChildren", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.HaveChildren));
cmdToExecute.Parameters.Add(new SqlParameter("@Religion", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.Religion));
cmdToExecute.Parameters.Add(new SqlParameter("@MotherTongue", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.MotherTongue));
cmdToExecute.Parameters.Add(new SqlParameter("@Caste", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.Caste));
cmdToExecute.Parameters.Add(new SqlParameter("@SubCaste", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.SubCaste));
cmdToExecute.Parameters.Add(new SqlParameter("@Manglik", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.Manglik));
cmdToExecute.Parameters.Add(new SqlParameter("@CountryLivingIn", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.CountryLivingIn));
cmdToExecute.Parameters.Add(new SqlParameter("@StateCity", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.StateCity));
cmdToExecute.Parameters.Add(new SqlParameter("@ResidencyStatus", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.ResidencyStatus));
cmdToExecute.Parameters.Add(new SqlParameter("@Education", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.Education));
cmdToExecute.Parameters.Add(new SqlParameter("@Occupation", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.Occupation));
cmdToExecute.Parameters.Add(new SqlParameter("@WorkingWith", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.WorkingWith));
cmdToExecute.Parameters.Add(new SqlParameter("@AnnualIncomeCurrency", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.AnnualIncomeCurrency));
cmdToExecute.Parameters.Add(new SqlParameter("@AnnualIncome", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.AnnualIncome));
cmdToExecute.Parameters.Add(new SqlParameter("@Diet", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.Diet));
cmdToExecute.Parameters.Add(new SqlParameter("@Smoke", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.Smoke));
cmdToExecute.Parameters.Add(new SqlParameter("@Drink", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.Drink));
cmdToExecute.Parameters.Add(new SqlParameter("@BodyType", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.BodyType));
cmdToExecute.Parameters.Add(new SqlParameter("@Complexion", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.Complexion));
cmdToExecute.Parameters.Add(new SqlParameter("@HealthProblem", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.HealthProblem));
cmdToExecute.Parameters.Add(new SqlParameter("@AboutPartner", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_UpdatePartnersPreferencesProp.AboutPartner));
return(cmdToExecute.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Search_Data(tbl_UpdatePartnersPreferencesProp Objtbl_UpdatePartnersPreferencesProp)
{
try
{
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("Search_tbl_UpdatePartnersPreferences");
//cmdToExecute.Parameters.Add(new SqlParameter("@SearchBy", SqlDbType.NVarChar, 100, Objtbl_UpdatePartnersPreferencesProp.SearchBy);
//cmdToExecute.Parameters.Add(new SqlParameter("@SearchVal", SqlDbType.NVarChar, 100, Objtbl_UpdatePartnersPreferencesProp.SearchVal);
//return DB.ExecuteDataSet(DBCmd);
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
