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