public int ChangePassword(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
SqlCommand cmdToExecute = new SqlCommand();
cmdToExecute.CommandText = "ChangePassword";
cmdToExecute.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
SqlDataAdapter da = null;
// Use base class' connection object
cmdToExecute.Connection = objdb.objConnection;
try
{
objdb.GetConnStr();
cmdToExecute.Parameters.Add(new SqlParameter("@MemberCode", SqlDbType.Int, 120, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.MemberCode));
cmdToExecute.Parameters.Add(new SqlParameter("@EmailID", SqlDbType.NVarChar, 200, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.EmailID));
cmdToExecute.Parameters.Add(new SqlParameter("@OldPassword", SqlDbType.NVarChar, 200, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Password));
cmdToExecute.Parameters.Add(new SqlParameter("@NewPassword", SqlDbType.NVarChar, 200, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.NewPassword));
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("ChangePassword");
//DB.AddInParameter(DBCmd, "@MemberCode", DbType.Int32, Objtbl_MemberMasterProp.);
//DB.AddInParameter(DBCmd, "@EmailID", DbType.String, Objtbl_MemberMasterProp.EmailID);
//DB.AddInParameter(DBCmd, "@OldPassword", DbType.String, Objtbl_MemberMasterProp.Password);
//DB.AddInParameter(DBCmd, "@NewPassword", DbType.String, Objtbl_MemberMasterProp.NewPassword);
//return DB.ExecuteNonQuery(DBCmd);
return(Convert.ToInt32(cmdToExecute.ExecuteNonQuery()));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Search_Data(tbl_MemberMasterProp Objtbl_MemberMasterProp, ref int TotalCount)
{
SqlCommand cmdToExecute = new SqlCommand();
cmdToExecute.CommandText = "Search_tbl_MemberMaster";
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("@SearchBy", SqlDbType.NVarChar, 120, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.SearchBy));
cmdToExecute.Parameters.Add(new SqlParameter("@SearchVal", SqlDbType.NVarChar, 220, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.SearchVal));
//cmdToExecute.Parameters.Add(new SqlParameter("@RecordCount", SqlDbType.Int, 18, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.RecordCount));
//cmdToExecute.Parameters.Add(new SqlParameter("@TotalCount", SqlDbType.Int, 18, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, _TotalCount));
da = new SqlDataAdapter(cmdToExecute);
da.Fill(ds);
//TotalCount = Convert.ToInt32(cmdToExecute.Parameters["@TotalCount"].Value);
return(ds);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Profile_Summary(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
SqlCommand cmdToExecute = new SqlCommand();
cmdToExecute.CommandText = "Profile_Summary";
cmdToExecute.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
SqlDataAdapter da = null;
// Use base class' connection object
cmdToExecute.Connection = objdb.objConnection;
try
{
objdb.GetConnStr();
cmdToExecute.Parameters.Add(new SqlParameter("@isActive", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.isActive));
da = new SqlDataAdapter(cmdToExecute);
da.Fill(ds);
return(ds);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(ds);
}
public int Delete_Data(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
tbl_MemberMasterDAL Objtbl_MemberMasterDAL = new tbl_MemberMasterDAL();
return(Objtbl_MemberMasterDAL.Delete_Data(Objtbl_MemberMasterProp));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet CheckforLogin(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
tbl_MemberMasterDAL Objtbl_MemberMasterDAL = new tbl_MemberMasterDAL();
return(Objtbl_MemberMasterDAL.CheckforLogin(Objtbl_MemberMasterProp));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Load_MemberDetails(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
tbl_MemberMasterDAL Objtbl_MemberMasterDAL = new tbl_MemberMasterDAL();
return(Objtbl_MemberMasterDAL.Load_MemberDetails(Objtbl_MemberMasterProp));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Profile_Summary(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
tbl_MemberMasterDAL Objtbl_MemberMasterDAL = new tbl_MemberMasterDAL();
return(Objtbl_MemberMasterDAL.Profile_Summary(Objtbl_MemberMasterProp));
}
catch (Exception ex)
{
throw ex;
}
}
//Created For Admin
//public int InsertUpdate_DataNA(ref tbl_MemberMasterProp Objtbl_MemberMasterProp)
//{
// try
// {
// tbl_MemberMasterDAL Objtbl_MemberMasterDAL = new tbl_MemberMasterDAL();
// return Objtbl_MemberMasterDAL.InsertUpdate_DataNA(ref Objtbl_MemberMasterProp);
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public int Update_ProfileStatus(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
tbl_MemberMasterDAL Objtbl_MemberMasterDAL = new tbl_MemberMasterDAL();
return(Objtbl_MemberMasterDAL.Update_ProfileStatus(Objtbl_MemberMasterProp));
}
catch (Exception ex)
{
throw ex;
}
}
public int ChangePassword(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
tbl_MemberMasterDAL Objtbl_MemberMasterDAL = new tbl_MemberMasterDAL();
return(Objtbl_MemberMasterDAL.ChangePassword(Objtbl_MemberMasterProp));
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertUpdate_Data(ref tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
tbl_MemberMasterDAL Objtbl_MemberMasterDAL = new tbl_MemberMasterDAL();
return(Objtbl_MemberMasterDAL.InsertUpdate_Data(ref Objtbl_MemberMasterProp));
}
catch (Exception ex)
{
throw ex;
}
}
//public DataSet Select_DataN(tbl_MemberMasterProp Objtbl_MemberMasterProp, ref int PageCount)
//{
// try
// {
// if (Objtbl_MemberMasterProp.MemberCode != 0)
// {
// Objtbl_MemberMasterProp.PageNo = 1;
// Objtbl_MemberMasterProp.RecordCount = 1;
// }
// int RecordCount = 0;
// tbl_MemberMasterDAL Objtbl_MemberMasterDAL = new tbl_MemberMasterDAL();
// DataSet dsData = Objtbl_MemberMasterDAL.Select_DataN(Objtbl_MemberMasterProp, ref RecordCount);
// double Page = Convert.ToDouble(RecordCount) / Convert.ToDouble(Objtbl_MemberMasterProp.RecordCount);
// if (dsData.Tables[0].Rows.Count > 0)
// {
// string[] PageDecimal = Page.ToString().Split('.');
// if (PageDecimal.Length > 1 && Convert.ToInt32(PageDecimal[1]) > 0)
// {
// PageCount = Convert.ToInt32(Page.ToString().Split('.')[0]) + 1;
// }
// else
// {
// PageCount = Convert.ToInt32(Page);
// }
// }
// else
// {
// PageCount = 0;
// }
// return dsData;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//public DataSet Select_DataNA(tbl_MemberMasterProp Objtbl_MemberMasterProp)
//{
// try
// {
// tbl_MemberMasterDAL Objtbl_MemberMasterDAL = new tbl_MemberMasterDAL();
// return Objtbl_MemberMasterDAL.Select_DataNA(Objtbl_MemberMasterProp);
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public DataSet Select_ExpiredInDays(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
tbl_MemberMasterDAL Objtbl_MemberMasterDAL = new tbl_MemberMasterDAL();
DataSet dsData = Objtbl_MemberMasterDAL.Select_ExpiredInDays(Objtbl_MemberMasterProp);
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Load_BookMarkList(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
tbl_MemberMasterDAL Objtbl_MemberMasterDAL = new tbl_MemberMasterDAL();
DataSet dsData = Objtbl_MemberMasterDAL.Load_BookMarkList(Objtbl_MemberMasterProp);
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet ForgotPassword(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
tbl_MemberMasterDAL Objtbl_MemberMasterDAL = new tbl_MemberMasterDAL();
DataSet dsData = Objtbl_MemberMasterDAL.ForgotPassword(Objtbl_MemberMasterProp);
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet ForgotPassword(tbl_MemberMasterProp objtbl_MemberMasterProp)
{
try
{
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("ForgotPassword");
//DB.AddInParameter(DBCmd, "@EmailID", DbType.String, objtbl_MemberMasterProp.EmailID);
//return DB.ExecuteDataSet(DBCmd);
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete_Data(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("Delete_tbl_MemberMaster");
//DB.AddInParameter(DBCmd, "@MemberCode", DbType.Int32, Objtbl_MemberMasterProp.MemberCode);
//DB.AddInParameter(DBCmd, "@DeletionType", DbType.Int32, 1);
//return DB.ExecuteNonQuery(DBCmd);
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Load_MFProfileList(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("Load_MFProfileList");
//DB.AddInParameter(DBCmd, "@Gender", DbType.String, Objtbl_MemberMasterProp.Gender);
//return DB.ExecuteDataSet(DBCmd);
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public int Update_ProfileStatus(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("Update_ProfileStatus");
//DB.AddInParameter(DBCmd, "@MemberCode", DbType.Int32, Objtbl_MemberMasterProp.MemberCode);
//DB.AddInParameter(DBCmd, "@isActive", DbType.Int32, Objtbl_MemberMasterProp.isActive);
//return DB.ExecuteNonQuery(DBCmd);
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Select_ExpiredInDays(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("Select_ExpiredInDays");
//DB.AddInParameter(DBCmd, "@SearchVal", DbType.Int32, Objtbl_MemberMasterProp.SearchVal);
//DataSet dsData = DB.ExecuteDataSet(DBCmd);
//return dsData;
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Load_BookMarkList(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
try
{
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("Load_BookmarkList");
//DB.AddInParameter(DBCmd, "@BookmarkList", DbType.String, Objtbl_MemberMasterProp.SearchVal);
//DataSet dsData = DB.ExecuteDataSet(DBCmd);
//return dsData;
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Select_Data(tbl_MemberMasterProp Objtbl_MemberMasterProp, ref int TotalCount)
{
SqlCommand cmdToExecute = new SqlCommand();
cmdToExecute.CommandText = "Select_tbl_MemberMaster";
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_MemberMasterProp.MemberCode));
cmdToExecute.Parameters.Add(new SqlParameter("@PageNo", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.PageNo));
cmdToExecute.Parameters.Add(new SqlParameter("@RecordCount", SqlDbType.Int, 18, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.RecordCount));
cmdToExecute.Parameters.Add(new SqlParameter("@TotalCount", SqlDbType.Int, 18, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, _TotalCount));
da = new SqlDataAdapter(cmdToExecute);
da.Fill(ds);
TotalCount = Convert.ToInt32(cmdToExecute.Parameters["@TotalCount"].Value);
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("Select_tbl_MemberMaster");
//DB.AddInParameter(DBCmd, "@MemberCode", DbType.Int32, Objtbl_MemberMasterProp.MemberCode);
//DB.AddInParameter(DBCmd, "@PageNo", DbType.Int32, Objtbl_MemberMasterProp.PageNo);
//DB.AddInParameter(DBCmd, "@RecordCount", DbType.Int32, Objtbl_MemberMasterProp.RecordCount);
//DB.AddOutParameter(DBCmd, "@TotalCount", DbType.Int32, 18);
//DataSet dsData = DB.ExecuteDataSet(DBCmd);
//TotalCount = Convert.ToInt32(DBCmd.Parameters["@TotalCount"].Value);
//return dsData;
return(ds);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Select_Data(tbl_MemberMasterProp Objtbl_MemberMasterProp, ref int PageCount)
{
try
{
if (Objtbl_MemberMasterProp.MemberCode != 0)
{
Objtbl_MemberMasterProp.PageNo = 1;
Objtbl_MemberMasterProp.RecordCount = 1;
}
int RecordCount = 0;
tbl_MemberMasterDAL Objtbl_MemberMasterDAL = new tbl_MemberMasterDAL();
DataSet dsData = Objtbl_MemberMasterDAL.Select_Data(Objtbl_MemberMasterProp, ref RecordCount);
double Page = Convert.ToDouble(RecordCount) / Convert.ToDouble(Objtbl_MemberMasterProp.RecordCount);
if (dsData.Tables[0].Rows.Count > 0)
{
string[] PageDecimal = Page.ToString().Split('.');
if (PageDecimal.Length > 1 && Convert.ToInt32(PageDecimal[1]) > 0)
{
PageCount = Convert.ToInt32(Page.ToString().Split('.')[0]) + 1;
}
else
{
PageCount = Convert.ToInt32(Page);
}
}
else
{
PageCount = 0;
}
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Load_MemberDetails(tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
SqlCommand cmdToExecute = new SqlCommand();
cmdToExecute.CommandText = "Load_MemberDetails";
cmdToExecute.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
SqlDataAdapter da = null;
// Use base class' connection object
cmdToExecute.Connection = objdb.objConnection;
try
{
objdb.GetConnStr();
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("Load_MemberDetails");
cmdToExecute.Parameters.Add(new SqlParameter("@MemberCode", SqlDbType.Int, 120, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.MemberCode));
cmdToExecute.Parameters.Add(new SqlParameter("@ProfileID", SqlDbType.NVarChar, 200, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.ProfileID));
cmdToExecute.Parameters.Add(new SqlParameter("@LoginCode", SqlDbType.NVarChar, 200, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.LoginCode));
cmdToExecute.Parameters.Add(new SqlParameter("@isLogedin", SqlDbType.Bit, 2, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.isLogedin));
//DB.AddInParameter(DBCmd, "@ProfileID", DbType.String, Objtbl_MemberMasterProp.ProfileID);
//DB.AddInParameter(DBCmd, "@LoginCode", DbType.String, Objtbl_MemberMasterProp.LoginCode);
//DB.AddInParameter(DBCmd, "@isLogedin", DbType.Boolean, Objtbl_MemberMasterProp.isLogedin);
//DB.AddInParameter(DBCmd, "@MemberCode", DbType.Int32, Objtbl_MemberMasterProp.MemberCode);
//return DB.ExecuteDataSet(DBCmd);
da = new SqlDataAdapter(cmdToExecute);
da.Fill(ds);
return(ds);
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertUpdate_Data(ref tbl_MemberMasterProp Objtbl_MemberMasterProp)
{
int _RetVal = 0;
SqlCommand cmdToExecute = new SqlCommand();
cmdToExecute.CommandText = "InsertUpdate_tbl_MemberMaster";
cmdToExecute.CommandType = CommandType.StoredProcedure;
// Use base class' connection object
cmdToExecute.Connection = objdb.objConnection;
try
{
objdb.GetConnStr();
cmdToExecute.Parameters.Add(new SqlParameter("@MemberCode", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.MemberCode));
cmdToExecute.Parameters.Add(new SqlParameter("@ProfileID", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.ProfileID));
cmdToExecute.Parameters.Add(new SqlParameter("@ProfileCreatedBy", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.ProfileCreatedBy));
cmdToExecute.Parameters.Add(new SqlParameter("@MemberName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.MemberName));
cmdToExecute.Parameters.Add(new SqlParameter("@Gender", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Gender));
cmdToExecute.Parameters.Add(new SqlParameter("@DateofBirth", SqlDbType.DateTime, 30, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.DateofBirth));
cmdToExecute.Parameters.Add(new SqlParameter("@TimeofBirth", SqlDbType.DateTime, 30, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.TimeofBirth));
cmdToExecute.Parameters.Add(new SqlParameter("@BirthPlace", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.BirthPlace));
cmdToExecute.Parameters.Add(new SqlParameter("@MaritalStatus", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.MaritalStatus));
cmdToExecute.Parameters.Add(new SqlParameter("@NoOfChildren", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.NoOfChildren));
cmdToExecute.Parameters.Add(new SqlParameter("@LiveChildrenTogether", SqlDbType.Int, 1, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.LiveChildrenTogether));
cmdToExecute.Parameters.Add(new SqlParameter("@Height", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Height));
cmdToExecute.Parameters.Add(new SqlParameter("@Weight", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Weight));
cmdToExecute.Parameters.Add(new SqlParameter("@BodyType", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.BodyType));
cmdToExecute.Parameters.Add(new SqlParameter("@HealthInformation", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.HealthInformation));
cmdToExecute.Parameters.Add(new SqlParameter("@Complexion", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Complexion));
cmdToExecute.Parameters.Add(new SqlParameter("@AnyDisability", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.AnyDisability));
cmdToExecute.Parameters.Add(new SqlParameter("@BloodGroup", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.BloodGroup));
cmdToExecute.Parameters.Add(new SqlParameter("@HomeAddress1", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.HomeAddress1));
cmdToExecute.Parameters.Add(new SqlParameter("@HomeAddress2", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.HomeAddress2));
cmdToExecute.Parameters.Add(new SqlParameter("@VisaStatus", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.VisaStatus));
cmdToExecute.Parameters.Add(new SqlParameter("@Country", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Country));
cmdToExecute.Parameters.Add(new SqlParameter("@StateCity", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.StateCity));
cmdToExecute.Parameters.Add(new SqlParameter("@MobileNo", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.MobileNo));
cmdToExecute.Parameters.Add(new SqlParameter("@LandlineNo", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.LandlineNo));
cmdToExecute.Parameters.Add(new SqlParameter("@MobileNo1", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.MobileNo1));
cmdToExecute.Parameters.Add(new SqlParameter("@LandlineNo1", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.LandlineNo1));
cmdToExecute.Parameters.Add(new SqlParameter("@SecondaryEmailID", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.SecondaryEmailID));
cmdToExecute.Parameters.Add(new SqlParameter("@Religion", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Religion));
cmdToExecute.Parameters.Add(new SqlParameter("@MotherTongue", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.MotherTongue));
cmdToExecute.Parameters.Add(new SqlParameter("@Caste", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Caste));
cmdToExecute.Parameters.Add(new SqlParameter("@SubCaste", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.SubCaste));
cmdToExecute.Parameters.Add(new SqlParameter("@Gotra", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Gotra));
cmdToExecute.Parameters.Add(new SqlParameter("@FatherName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.FatherName));
cmdToExecute.Parameters.Add(new SqlParameter("@FatherOccupation", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.FatherOccupation));
cmdToExecute.Parameters.Add(new SqlParameter("@MotherName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.MotherName));
cmdToExecute.Parameters.Add(new SqlParameter("@MotherOccupation", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.MotherOccupation));
cmdToExecute.Parameters.Add(new SqlParameter("@MosalPlace", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.MosalPlace));
cmdToExecute.Parameters.Add(new SqlParameter("@NativePlace", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.NativePlace));
cmdToExecute.Parameters.Add(new SqlParameter("@FamilyType", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.FamilyType));
cmdToExecute.Parameters.Add(new SqlParameter("@FamilyValues", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.FamilyValues));
cmdToExecute.Parameters.Add(new SqlParameter("@Manglik", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Manglik));
cmdToExecute.Parameters.Add(new SqlParameter("@Nakshtra", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Nakshtra));
cmdToExecute.Parameters.Add(new SqlParameter("@Rashi", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Rashi));
cmdToExecute.Parameters.Add(new SqlParameter("@Education", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Education));
cmdToExecute.Parameters.Add(new SqlParameter("@Occupation", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Occupation));
cmdToExecute.Parameters.Add(new SqlParameter("@WorkingAs", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.WorkingAs));
cmdToExecute.Parameters.Add(new SqlParameter("@WorkingWith", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.WorkingWith));
cmdToExecute.Parameters.Add(new SqlParameter("@WorkAddress", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.WorkAddress));
cmdToExecute.Parameters.Add(new SqlParameter("@AnnualIncomeCurrency", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.AnnualIncomeCurrency));
cmdToExecute.Parameters.Add(new SqlParameter("@AnnualIncome", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.AnnualIncome));
cmdToExecute.Parameters.Add(new SqlParameter("@Diet", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Diet));
cmdToExecute.Parameters.Add(new SqlParameter("@Drink", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Drink));
cmdToExecute.Parameters.Add(new SqlParameter("@Smoke", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Smoke));
cmdToExecute.Parameters.Add(new SqlParameter("@AboutInfo", SqlDbType.NVarChar, 500, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.AboutInfo));
cmdToExecute.Parameters.Add(new SqlParameter("@EmailID", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.EmailID));
cmdToExecute.Parameters.Add(new SqlParameter("@Password", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Password));
cmdToExecute.Parameters.Add(new SqlParameter("@RegisterDate", SqlDbType.DateTime, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.RegisterDate));
cmdToExecute.Parameters.Add(new SqlParameter("@isActive", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.isActive));
cmdToExecute.Parameters.Add(new SqlParameter("@Choice", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Choice));
cmdToExecute.Parameters.Add(new SqlParameter("@Remarks", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Remarks));
cmdToExecute.Parameters.Add(new SqlParameter("@mStatus", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.mStatus));
cmdToExecute.Parameters.Add(new SqlParameter("@FileNote", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.FileNote));
cmdToExecute.Parameters.Add(new SqlParameter("@Degree", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.Degree));
cmdToExecute.Parameters.Add(new SqlParameter("@OccupationDtls", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.OccupationDtls));
cmdToExecute.Parameters.Add(new SqlParameter("@VisaCountry", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.VisaCountry));
cmdToExecute.Parameters.Add(new SqlParameter("@AgeDiff", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.AgeDiff));
cmdToExecute.Parameters.Add(new SqlParameter("@MobileNo_Rel", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.MobileNo_Rel));
cmdToExecute.Parameters.Add(new SqlParameter("@MobileNo1_Rel", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.MobileNo1_Rel));
cmdToExecute.Parameters.Add(new SqlParameter("@LandlineNo1_Rel", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.LandlineNo1_Rel));
cmdToExecute.Parameters.Add(new SqlParameter("@MobileNo2_Rel", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_MemberMasterProp.MobileNo2_Rel));
cmdToExecute.Parameters.Add(new SqlParameter("@RetVal", SqlDbType.Int, 20, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, 18));
cmdToExecute.Parameters.Add(new SqlParameter("@RetProfileID", SqlDbType.NVarChar, 100, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, 15));
cmdToExecute.Parameters.Add(new SqlParameter("@RetPassword", SqlDbType.NVarChar, 100, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, 15));
cmdToExecute.ExecuteNonQuery();
Objtbl_MemberMasterProp.ProfileID = Convert.ToString(cmdToExecute.Parameters["@RetProfileID"].Value);
Objtbl_MemberMasterProp.Password = Convert.ToString(cmdToExecute.Parameters["@RetPassword"].Value);
return(Convert.ToInt32(cmdToExecute.Parameters["@RetVal"].Value));
}
catch (Exception ex)
{
throw ex;
}
}
