public DataTable activeuser(Register1 p)
{
DataTable programs = new DataTable();
try
{
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@userid", userid);
parameters.Add("@uniqueid", uniqueid);
DataTable dt = helper.GetDataTableFromStoredProc(SP.ActiveUser, parameters);
foreach (DataRow dr in dt.Rows)
{
p.userid = Convert.ToInt32(dr["user_id"].ToString());
p.username = dr["USER_NAME"].ToString();
p.first_name = (dr["first_name"].ToString());
p.last_name = dr["last_name"].ToString();
}
programs = dt;
}
catch (Exception ex)
{
ErrorLog.saveerror(ex);
}
return(programs);
}
public DataTable Insert(Register1 b)
{
DataTable result = null;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@company_name", company_name);
parameters.Add("@first_name", first_name);
parameters.Add("@last_name", last_name);
parameters.Add("@owner_emailid", owner_emailid);
parameters.Add("@owner_mobileno", owner_mobileno);
parameters.Add("@user_password", password);
parameters.Add("@country_id", country_id);
parameters.Add("@pincode", pincode);
parameters.Add("@created_by", created_by);
parameters.Add("@created_date", created_date);
parameters.Add("@start_date", start_date);
parameters.Add("@end_date", end_date);
parameters.Add("@uniqueidentity", uniqueid);
parameters.Add("@IsVerified", IsVerified);
parameters.Add("@Ref_Mobile", Ref_Mobile);
try
{
result = helper.GetDataTablebyProc(SP.Register, parameters);
}
catch (Exception ex)
{
ErrorLog.saveerror(ex);
return(result);
}
return(result);
}
public DataTable checkresetpwslink(Register1 p)
{
DataTable programs = new DataTable();
try
{
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@userid", userid);
parameters.Add("@uniqueid", uniqueid);
parameters.Add("@pid", passverifyID);
DataTable dt = helper.GetDataTableFromStoredProc(SP.checkpwdlink, parameters);
programs = dt;
}
catch (Exception ex)
{
ErrorLog.saveerror(ex);
}
return(programs);
}
public DataTable updatepassword(Register1 b)
{
DataTable result = null;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@userid", userid);
parameters.Add("@uniqueid", uniqueid);
parameters.Add("@modify_date", modifydate);
parameters.Add("@newpwd", password);
parameters.Add("@pid", passverifyID);
try
{
result = helper.GetDataTablebyProc(SP.Updatepwd, parameters);
}
catch (Exception ex)
{
ErrorLog.saveerror(ex);
return(result);
}
return(result);
}
public DataTable ResetRequest(Register1 p)
{
DataTable programs = new DataTable();
try
{
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@email", owner_emailid);
parameters.Add("@uniqueid", uniqueid);
parameters.Add("@created_date", created_date);
DataTable dt = helper.GetDataTableFromStoredProc(SP.ResetRequest, parameters);
programs = dt;
}
catch (Exception ex)
{
ErrorLog.saveerror(ex);
}
return(programs);
}