public DataSet Select_Data(tbl_PartnersPreferencesProp Objtbl_PartnersPreferencesProp)
{
SqlCommand cmdToExecute = new SqlCommand();
cmdToExecute.CommandText = "Select_tbl_PartnersPreferences";
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();
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("Select_tbl_PartnersPreferences");
cmdToExecute.Parameters.Add(new SqlParameter("@MemberCode", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.MemberCode));
da = new SqlDataAdapter(cmdToExecute);
da.Fill(ds);
//TotalCount = Convert.ToInt32(cmdToExecute.Parameters["@TotalCount"].Value);
return(ds);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Search_Data(tbl_PartnersPreferencesProp Objtbl_PartnersPreferencesProp)
{
try
{
tbl_PartnersPreferencesDAL Objtbl_PartnersPreferencesDAL = new tbl_PartnersPreferencesDAL();
return(Objtbl_PartnersPreferencesDAL.Search_Data(Objtbl_PartnersPreferencesProp));
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete_Data(tbl_PartnersPreferencesProp Objtbl_PartnersPreferencesProp)
{
try
{
tbl_PartnersPreferencesDAL Objtbl_PartnersPreferencesDAL = new tbl_PartnersPreferencesDAL();
return(Objtbl_PartnersPreferencesDAL.Delete_Data(Objtbl_PartnersPreferencesProp));
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertUpdate_Data(tbl_PartnersPreferencesProp Objtbl_PartnersPreferencesProp)
{
int _RetVal = 0;
SqlCommand cmdToExecute = new SqlCommand();
cmdToExecute.CommandText = "InsertUpdate_tbl_PartnersPreferences";
cmdToExecute.CommandType = CommandType.StoredProcedure;
// Use base class' connection object
cmdToExecute.Connection = objdb.objConnection;
try
{
objdb.GetConnStr();
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("InsertUpdate_tbl_PartnersPreferences");
cmdToExecute.Parameters.Add(new SqlParameter("@MemberCode", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.MemberCode));
cmdToExecute.Parameters.Add(new SqlParameter("@AgeFrom", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.AgeFrom));
cmdToExecute.Parameters.Add(new SqlParameter("@AgeTo", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.AgeTo));
cmdToExecute.Parameters.Add(new SqlParameter("@HeightFrom", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.HeightFrom));
cmdToExecute.Parameters.Add(new SqlParameter("@HeightTo", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.HeightTo));
cmdToExecute.Parameters.Add(new SqlParameter("@MaritalStatus", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.MaritalStatus));
cmdToExecute.Parameters.Add(new SqlParameter("@HaveChildren", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.HaveChildren));
cmdToExecute.Parameters.Add(new SqlParameter("@Religion", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.Religion));
cmdToExecute.Parameters.Add(new SqlParameter("@MotherTongue", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.MotherTongue));
cmdToExecute.Parameters.Add(new SqlParameter("@Caste", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.Caste));
cmdToExecute.Parameters.Add(new SqlParameter("@SubCaste", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.SubCaste));
cmdToExecute.Parameters.Add(new SqlParameter("@Manglik", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.Manglik));
cmdToExecute.Parameters.Add(new SqlParameter("@CountryLivingIn", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.CountryLivingIn));
cmdToExecute.Parameters.Add(new SqlParameter("@StateCity", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.StateCity));
cmdToExecute.Parameters.Add(new SqlParameter("@ResidencyStatus", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.ResidencyStatus));
cmdToExecute.Parameters.Add(new SqlParameter("@Education", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.Education));
cmdToExecute.Parameters.Add(new SqlParameter("@Occupation", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.Occupation));
cmdToExecute.Parameters.Add(new SqlParameter("@WorkingWith", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.WorkingWith));
cmdToExecute.Parameters.Add(new SqlParameter("@AnnualIncomeCurrency", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.AnnualIncomeCurrency));
cmdToExecute.Parameters.Add(new SqlParameter("@AnnualIncome", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.AnnualIncome));
cmdToExecute.Parameters.Add(new SqlParameter("@Diet", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.Diet));
cmdToExecute.Parameters.Add(new SqlParameter("@Smoke", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.Smoke));
cmdToExecute.Parameters.Add(new SqlParameter("@Drink", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.Drink));
cmdToExecute.Parameters.Add(new SqlParameter("@BodyType", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.BodyType));
cmdToExecute.Parameters.Add(new SqlParameter("@Complexion", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.Complexion));
cmdToExecute.Parameters.Add(new SqlParameter("@HealthProblem", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.HealthProblem));
cmdToExecute.Parameters.Add(new SqlParameter("@AboutPartner", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_PartnersPreferencesProp.AboutPartner));
cmdToExecute.Parameters.Add(new SqlParameter("@RetVal", SqlDbType.Int, 20, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, 18));
cmdToExecute.ExecuteNonQuery();
return(Convert.ToInt32(cmdToExecute.Parameters["@RetVal"].Value));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Select_Data(tbl_PartnersPreferencesProp Objtbl_PartnersPreferencesProp)
{
try
{
tbl_PartnersPreferencesDAL Objtbl_PartnersPreferencesDAL = new tbl_PartnersPreferencesDAL();
DataSet dsData = Objtbl_PartnersPreferencesDAL.Select_Data(Objtbl_PartnersPreferencesProp);
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete_Data(tbl_PartnersPreferencesProp Objtbl_PartnersPreferencesProp)
{
try
{
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("Delete_tbl_PartnersPreferences");
//return DB.ExecuteNonQuery(DBCmd);
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Search_Data(tbl_PartnersPreferencesProp Objtbl_PartnersPreferencesProp)
{
try
{
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("Search_tbl_PartnersPreferences");
//DB.AddInParameter(DBCmd, "@SearchBy", DbType.String, Objtbl_PartnersPreferencesProp.SearchBy);
//DB.AddInParameter(DBCmd, "@SearchVal", DbType.String, Objtbl_PartnersPreferencesProp.SearchVal);
//return DB.ExecuteDataSet(DBCmd);
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
