public int InsertPasscode(PasscodeDTO data) { int passcodeId = 0; PasscodeDTO user = new PasscodeDTO(); if (_user == null) { _user = new UserService(); } passcodeId = _user.InsertPasscode(data); return(passcodeId); }
public int InsertPasscode(PasscodeDTO data) { int passCodeId = 0; // string passcode = System.Web.Security.Membership.GeneratePassword(6, 2); SqlParameter[] sqlParams = new SqlParameter[4]; sqlParams[0] = new SqlParameter("SenderID", data.SenderID); sqlParams[1] = new SqlParameter("RecipientEmail", data.RecipientEmail); sqlParams[2] = new SqlParameter("PassCode", data.PassCode); sqlParams[3] = new SqlParameter("IsSignedUp", data.IsSignedUp); object objResult = SqlClientRMXProd.ExecuteScalar("udsp_InsertPasscodeInfo", sqlParams); if ((objResult != null) && (Int32.TryParse(objResult.ToString(), out passCodeId))) { return(passCodeId); } return(passCodeId); }
public PasscodeDTO GetPasscode() { PasscodeDTO list = new PasscodeDTO(); try { DataTable dtUser = SqlClientRMXProd.ExecuteDataTable("udsp_GetPassCode"); if (dtUser != null && dtUser.Rows.Count > 0) { list.PasscodeID = Convert.ToInt32(dtUser.Rows[0]["PasscodeID"].ToString()); list.PassCode = dtUser.Rows[0]["PassCode"].ToString(); list.RecipientEmail = dtUser.Rows[0]["RecipientEmail"].ToString(); list.SenderID = dtUser.Rows[0]["SenderID"].ToString(); list.IsSignedUp = Convert.ToBoolean(dtUser.Rows[0]["IsSignedUp"].ToString()); } } catch (Exception ex) { } return(list); }