public VO_RESPONSE INV_SET_PASSWORD(string VI_USERNAME, string VI_PASSWORD, string VI_MSISDN, string VI_SUB_PASSWORD, string VI_EMAIL)
{
VO_RESPONSE response = new VO_RESPONSE();
DBConnection MID = new DBConnection();
try
{
MID.OpenDB();
if (!MID.FN_LOGIN(VI_USERNAME, VI_PASSWORD))
{
response.VO_RESULT = -1;
response.VO_MESSAGE = "Invalid Username/ Password system login";
return(response);
}
response = MID.FN_SET_PASSWORD(VI_MSISDN, VI_SUB_PASSWORD, VI_EMAIL);
return(response);
}
catch (Exception ex)
{
response.VO_RESULT = -9000;
response.VO_MESSAGE = string.Concat("WSDL EXCEPTION: ", ex.Message);
return(response);
}
}
public VO_RESPONSE FN_SET_PASSWORD(string vi_PHONE, string vi_PASSWORD, string vi_EMAIL)
{
VO_RESPONSE Response_FN = new VO_RESPONSE();
string vo_message = "";
int vo_result = -1;
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "PCK_MAPP.FN_SET_PASSWORD_STG";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("VO_RES", OracleDbType.Int32, 1);
cmd.Parameters["VO_RES"].Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add("VI_PHONE", OracleDbType.Varchar2, 100, vi_PHONE, ParameterDirection.Input);
cmd.Parameters.Add("VI_PASSWORD", OracleDbType.Varchar2, 100, vi_PASSWORD, ParameterDirection.Input);
cmd.Parameters.Add("VI_EMAIL", OracleDbType.Varchar2, 100, vi_EMAIL, ParameterDirection.Input);
cmd.Parameters.Add("VO_MESSAGE", OracleDbType.Varchar2, 200, vo_message, ParameterDirection.Output);
cmd.Parameters.Add("VO_RESULT", OracleDbType.Int32, 1, vo_result, ParameterDirection.Output);
cmd.ExecuteNonQuery();
Response_FN.VO_MESSAGE = cmd.Parameters["VO_MESSAGE"].Value.ToString();
Response_FN.VO_RESULT = int.Parse(cmd.Parameters["VO_RESULT"].Value.ToString());
cmd.Dispose();
Close();
return(Response_FN);
}
public VO_RESPONSE FN_GET_CODE(string msisdn)
{
VO_RESPONSE Response_FN = new VO_RESPONSE();
string res = "";
string query = "SELECT EMAIL FROM MAPP_VALIDATE_USER WHERE NUM_CELL = :msisdn AND DT_CREATION >= SYSDATE - 5/1440 AND TP_STATUS = 1";
OracleCommand cmd = new OracleCommand(query, conn);
cmd.BindByName = true;
cmd.Parameters.Add(new OracleParameter("msisdn", msisdn));
OracleDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Response_FN.VO_RESULT = int.Parse(dr.GetString(0));
Response_FN.VO_MESSAGE = "Active Code";
}
}
else
{
Response_FN.VO_RESULT = -1;
Response_FN.VO_MESSAGE = "No Valid Code Active";
}
return(Response_FN);
}
public VO_RESPONSE SET_SELFCARE_LOGIN(string vi_msisdn, int vi_code)
{
VO_RESPONSE Response_FN = new VO_RESPONSE();
string vo_message = "";
int vo_result = -1;
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "PCK_MAPP.SET_SELFCARE_LOGIN";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("VO_RES", OracleDbType.Int32, 1);
cmd.Parameters["VO_RES"].Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add("VI_MSISDN", OracleDbType.Varchar2, 100, vi_msisdn, ParameterDirection.Input);
cmd.Parameters.Add("VI_CODE", OracleDbType.Int32, 4, vi_code, ParameterDirection.Input);
cmd.Parameters.Add("VO_MESSAGE", OracleDbType.Varchar2, 200, vo_message, ParameterDirection.Output);
cmd.Parameters.Add("VO_RESULT", OracleDbType.Int32, 1, vo_result, ParameterDirection.Output);
cmd.ExecuteNonQuery();
Response_FN.VO_MESSAGE = cmd.Parameters["VO_MESSAGE"].Value.ToString();
Response_FN.VO_RESULT = int.Parse(cmd.Parameters["VO_RESULT"].Value.ToString());
cmd.Dispose();
Close();
return(Response_FN);
}
