public DataTable SOSVerification(SOSMessage sos)
{
LogTraceWriter traceWriter = new LogTraceWriter();
//traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SOSVerification ...");
//connect to database
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection();
StringBuilder str = new StringBuilder();
try
{
str.Append("UserTypeId:" + sos.UserTypeId + ",");
str.Append("UserId:" + sos.UserId + ",");
//traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString());
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SOSotpverification";
cmd.Connection = conn;
conn.Open();
SqlParameter id = new SqlParameter();
id.ParameterName = "@Mobilenumber";
id.SqlDbType = SqlDbType.VarChar;
id.Value = sos.Mobilenumber;
cmd.Parameters.Add(id);
SqlParameter UserId = new SqlParameter();
UserId.ParameterName = "@Otp";
UserId.SqlDbType = SqlDbType.VarChar;
UserId.Value = sos.Otp;
cmd.Parameters.Add(UserId);
SqlParameter ustid = new SqlParameter();
ustid.ParameterName = "@UserTypeId";
ustid.SqlDbType = SqlDbType.Int;
ustid.Value = sos.UserTypeId;
cmd.Parameters.Add(ustid);
cmd.ExecuteScalar();
conn.Close();
//traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SOSVerification completed.");
}
catch (Exception ex)
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
//string st = ex.Message;
//traceWriter.Trace(Request, "1", TraceLevel.Info, "{0}", "Error in SOSVerification:" + ex.Message);
dt.Columns.Add("Code");
dt.Columns.Add("description");
DataRow dr = dt.NewRow();
dr[0] = "ERR001";
dr[1] = ex.Message;
dt.Rows.Add(dr);
}
return(dt);
}
public DataTable SaveSOSMessage(SOSMessage sos)
{
LogTraceWriter traceWriter = new LogTraceWriter();
// traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveSOSMessage ...");
//connect to database
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection();
StringBuilder str = new StringBuilder();
try
{
str.Append("UserTypeId:" + sos.UserTypeId + ",");
str.Append("UserId:" + sos.UserId + ",");
//traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString());
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsUpdDelSOSMessage";
cmd.Connection = conn;
conn.Open();
SqlParameter flag = new SqlParameter();
flag.ParameterName = "@flag";
flag.SqlDbType = SqlDbType.VarChar;
flag.Value = sos.flag;
cmd.Parameters.Add(flag);
SqlParameter id = new SqlParameter();
id.ParameterName = "@Id";
id.SqlDbType = SqlDbType.Int;
id.Value = sos.Id;
cmd.Parameters.Add(id);
SqlParameter UserId = new SqlParameter();
UserId.ParameterName = "@UserId";
UserId.SqlDbType = SqlDbType.Int;
UserId.Value = sos.UserId;
cmd.Parameters.Add(UserId);
SqlParameter ustid = new SqlParameter();
ustid.ParameterName = "@UserTypeId";
ustid.SqlDbType = SqlDbType.Int;
ustid.Value = sos.UserTypeId;
cmd.Parameters.Add(ustid);
SqlParameter SentTo = new SqlParameter();
SentTo.ParameterName = "@SentTo";
SentTo.SqlDbType = SqlDbType.VarChar;
SentTo.Value = sos.SentTo;
cmd.Parameters.Add(SentTo);
SqlParameter MessageId = new SqlParameter();
MessageId.ParameterName = "@MessageId";
MessageId.SqlDbType = SqlDbType.Int;
MessageId.Value = sos.MessageId;
cmd.Parameters.Add(MessageId);
SqlParameter msg = new SqlParameter();
msg.ParameterName = "@Message";
msg.SqlDbType = SqlDbType.VarChar;
msg.Value = sos.Message;
cmd.Parameters.Add(msg);
SqlParameter SentOn = new SqlParameter();
SentOn.ParameterName = "@SentOn";
SentOn.SqlDbType = SqlDbType.DateTime;
SentOn.Value = sos.SentOn;
cmd.Parameters.Add(SentOn);
SqlParameter SentTime = new SqlParameter();
SentTime.ParameterName = "@SentTime";
SentTime.SqlDbType = SqlDbType.Time;
SentTime.Value = sos.SentTime;
cmd.Parameters.Add(SentTime);
SqlParameter Status = new SqlParameter();
Status.ParameterName = "@StatusId";
Status.SqlDbType = SqlDbType.Int;
Status.Value = sos.StatusId;
cmd.Parameters.Add(Status);
SqlParameter UpdatedBy = new SqlParameter();
UpdatedBy.ParameterName = "@UpdatedBy";
UpdatedBy.SqlDbType = SqlDbType.Int;
UpdatedBy.Value = sos.UpdatedBy;
cmd.Parameters.Add(UpdatedBy);
SqlParameter Lat = new SqlParameter("@Latitude", SqlDbType.Float);
Lat.Value = sos.Latitude;
cmd.Parameters.Add(Lat);
SqlParameter Lng = new SqlParameter("@Longitude", SqlDbType.Float);
Lng.Value = sos.Longitude;
cmd.Parameters.Add(Lng);
SqlDataAdapter ds = new SqlDataAdapter(cmd);
ds.Fill(dt);
#region SOS opt
string sotp = dt.Rows[0]["Otp"].ToString();
if (sotp != null)
{
try
{
MailMessage mail = new MailMessage();
string emailserver = System.Configuration.ConfigurationManager.AppSettings["emailserver"].ToString();
string username = System.Configuration.ConfigurationManager.AppSettings["username"].ToString();
string pwd = System.Configuration.ConfigurationManager.AppSettings["password"].ToString();
string fromaddress = System.Configuration.ConfigurationManager.AppSettings["fromaddress"].ToString();
string port = System.Configuration.ConfigurationManager.AppSettings["port"].ToString();
SmtpClient SmtpServer = new SmtpClient(emailserver);
mail.From = new MailAddress(fromaddress);
mail.To.Add(fromaddress);
mail.Subject = "User registration - Email OTP";
mail.IsBodyHtml = true;
string verifcodeMail = @"<table>
<tr>
<td>
<h2>Thank you for registering with PaySmart APP</h2>
<table width=\""760\"" align=\""center\"">
<tbody style='background-color:#F0F8FF;'>
<tr>
<td style=\""font-family:'Zurich BT',Arial,Helvetica,sans-serif;font-size:15px;text-align:left;line-height:normal;background-color:#F0F8FF;\"" >
<div style='padding:10px;border:#0000FF solid 2px;'> <br /><br />
Your email OTP is:<h3>" + sotp + @" </h3>
If you didn't make this request, <a href='http://154.120.237.198:52800'>click here</a> to cancel.
<br/>
<br/>
Warm regards,<br>
PAYSMART Customer Service Team<br/><br />
</div>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</table>";
mail.Body = verifcodeMail;
//SmtpServer.Port = 465;
//SmtpServer.Port = 587;
SmtpServer.Port = Convert.ToInt32(port);
SmtpServer.UseDefaultCredentials = false;
SmtpServer.Credentials = new System.Net.NetworkCredential(username, pwd);
SmtpServer.EnableSsl = true;
//SmtpServer.TargetName = "STARTTLS/smtp.gmail.com";
SmtpServer.Send(mail);
}
catch (Exception ex)
{
//throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
//send mobile otp
// return dt;
#endregion email otp
// traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveMandUserDocs completed.");
}
catch (Exception ex)
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
//string st = ex.Message;
dt.Columns.Add("Code");
dt.Columns.Add("description");
DataRow dr = dt.NewRow();
dr[0] = "ERR001";
dr[1] = ex.Message;
dt.Rows.Add(dr);
//traceWriter.Trace(Request, "1", TraceLevel.Info, "{0}", "Error in SaveMandUserDocs:" + ex.Message);
}
return(dt);
}
