public string Signup(VMSignUp model)
{
List <jpuser> lstjpUSER = jpuserManager.Getjpuser(" USERNAME = '******'", null);
if (lstjpUSER.Count > 0)
{
return("Username already Exists");
}
lstjpUSER = jpuserManager.Getjpuser(" EMAIL = '" + model.Email + "'", null);
if (lstjpUSER.Count > 0)
{
return("An account already exists with the given Email");
}
jpuser userobj = new jpuser();
userobj.EMAIL = model.Email;
userobj.PASSWORD = model.Password;
userobj.USERNAME = model.Username;
userobj.ACTIVE = "N";
jpprofile profileobj = new jpprofile();
profileobj.NAME = " ";
profileobj.ADDRESS = " ";
profileobj.CONTACT = model.Contact;
profileobj.DOB = DateTime.ParseExact(model.DOB, Shared.Constants.DATE_RFC_FORMAT, CultureInfo.InvariantCulture);
profileobj.GENDER = model.Gender;
profileobj.CURRENTSALARY = "0";
MySqlConnection conn = Shared.BaseManager.PrimaryConnection();
conn.Open();
var transaction = conn.BeginTransaction();
string ret = jpuserManager.Savejpuser(userobj, conn, transaction);
if (!ret.Equals(Shared.Constants.MSG_ERR_DBSAVE.Text))
{
profileobj.USERID = int.Parse(ret);
ret = jpprofileManager.Savejpprofile(profileobj, conn, transaction);
if (ret.Equals(Shared.Constants.MSG_OK_DBSAVE.Text))
{
transaction.Commit();
conn.Close();
conn.Dispose();
//add verification url code here
userobj.USERID = profileobj.USERID;
string _token = (string)getVerificationURL(userobj);
return(sendEmail(userobj.EMAIL, _token));
}
}
transaction.Rollback();
conn.Close();
conn.Dispose();
return(Shared.Constants.MSG_ERR_SERVER.Text);
}
private bool isProfileComplete(jpprofile objjpprofile)
{
if (!string.IsNullOrEmpty(objjpprofile.NAME))
{
if (!string.IsNullOrEmpty(objjpprofile.CURRENTSALARY))
{
if (objjpprofile.lstjpqualification.Count > 0)
{
if (objjpprofile.lstjpexperience.Count > 0)
{
return(true);
}
}
}
}
return(false);
}
public string MyProfile(jpprofile model)
{
jpuser SessionUser = GetSessionUser();
if (SessionUser != null)
{
if (SessionUser.objjpprofile != null)
{
if (SessionUser.objjpprofile.lstjpqualification.Count > 0)
{
if (SessionUser.objjpprofile.lstjpexperience.Count > 0)
{
SessionUser.objjpprofile.CONTACT = model.CONTACT;
SessionUser.objjpprofile.CURRENTSALARY = model.CURRENTSALARY;
SessionUser.objjpprofile.NAME = model.NAME;
SessionUser.objjpprofile.GENDER = model.GENDER;
SessionUser.objjpprofile.CURRENTCURRENCY = model.CURRENTCURRENCY;
SessionUser.objjpprofile.NATIONALITY = model.NATIONALITY;
SessionUser.objjpprofile.LANGUAGE = model.LANGUAGE;
SessionUser.objjpprofile.lstjpqualification.FindAll(a => a.QUALIFICATIONID < 0).Select(c => { c.QUALIFICATIONID = 0; return(c); }).ToList();
SessionUser.objjpprofile.lstjpexperience.FindAll(a => a.EXPID < 0).Select(c => { c.EXPID = 0; return(c); }).ToList();
MySqlConnection conn = Shared.BaseManager.PrimaryConnection();
conn.Open();
var transaction = conn.BeginTransaction();
string ret = jpprofileManager.Savejpprofile(SessionUser.objjpprofile, conn, transaction);
if (ret.Equals(Shared.Constants.MSG_OK_DBSAVE.Text))
{
bool EduContinue = true;
//ret = jpqualificationManager.Deletejpqualification()
foreach (var edu in SessionUser.objjpprofile.lstjpqualification)
{
ret = jpqualificationManager.Savejpqualification(edu, conn, transaction);
if (!ret.Equals(Shared.Constants.MSG_OK_DBSAVE.Text))
{
EduContinue = false;
break;
}
}
if (EduContinue)
{
bool ExpContinue = true;
foreach (var exp in SessionUser.objjpprofile.lstjpexperience)
{
ret = jpexperienceManager.Savejpexperience(exp, conn, transaction);
if (!ret.Equals(Shared.Constants.MSG_OK_DBSAVE.Text))
{
ExpContinue = false;
break;
}
}
if (ExpContinue)
{
transaction.Commit();
conn.Close();
conn.Dispose();
SessionUser.objjpprofile = GetCompleteUserProfile(SessionUser.USERID);
SessionUser.isProfileComplete = isProfileComplete(SessionUser.objjpprofile);
SetSessionUser(SessionUser);
return(Shared.Constants.MSG_SUCCESS.Text);
}
}
}
transaction.Rollback();
conn.Close();
conn.Dispose();
return(Shared.Constants.MSG_ERR_SERVER.Text);
}
}
}
}
return(Shared.Constants.MSG_ERROR.Text);
}
