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); }