public DataTable UpdateBusinessAppUser(BusinessUserStafff ocr)
{
DataTable dt = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
StringBuilder str = new StringBuilder();
try
{
//traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "UpdateUser....");
str.Append("Mobilenumber:" + ocr.Mobilenumber + ",");
str.Append("Email:" + ocr.Email + ",");
str.Append("Username:"******",");
//traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString());
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PSUpdateBusinessUsersStaff";
cmd.Connection = conn;
SqlParameter f = new SqlParameter("@flag", SqlDbType.VarChar);
f.Value = ocr.flag;
cmd.Parameters.Add(f);
SqlParameter ii = new SqlParameter("@Id", SqlDbType.Int);
ii.Value = ocr.Id;
cmd.Parameters.Add(ii);
SqlParameter c = new SqlParameter("@Username", SqlDbType.VarChar, 20);
c.Value = ocr.Username;
cmd.Parameters.Add(c);
SqlParameter ce = new SqlParameter("@Email", SqlDbType.VarChar, 50);
ce.Value = ocr.Email;
cmd.Parameters.Add(ce);
SqlParameter cm = new SqlParameter("@Mobilenumber", SqlDbType.VarChar, 20);
cm.Value = ocr.Mobilenumber;
cmd.Parameters.Add(cm);
SqlParameter q1 = new SqlParameter("@Password", SqlDbType.VarChar, 50);
q1.Value = ocr.Password;
cmd.Parameters.Add(q1);
SqlParameter v = new SqlParameter("@Firstname", SqlDbType.VarChar, 50);
v.Value = ocr.Firstname;
cmd.Parameters.Add(v);
SqlParameter v1 = new SqlParameter("@lastname", SqlDbType.VarChar, 50);
v1.Value = ocr.lastname;
cmd.Parameters.Add(v1);
SqlParameter ct = new SqlParameter("@CountryId", SqlDbType.Int);
ct.Value = ocr.CountryId;
cmd.Parameters.Add(ct);
SqlParameter cts = new SqlParameter("@CurrentStateId", SqlDbType.Int);
cts.Value = ocr.CurrentStateId;
cmd.Parameters.Add(cts);
SqlParameter paym = new SqlParameter("@PaymentModeId", SqlDbType.Int);
paym.Value = ocr.PaymentModeId;
cmd.Parameters.Add(paym);
SqlParameter ccode = new SqlParameter("@CCode", SqlDbType.VarChar, 10);
ccode.Value = ocr.CCode;
cmd.Parameters.Add(ccode);
SqlParameter uaccno = new SqlParameter("@UserAccountNo", SqlDbType.VarChar, 15);
uaccno.Value = ocr.UserAccountNo;
cmd.Parameters.Add(uaccno);
SqlParameter utt = new SqlParameter("@UserTypeId", SqlDbType.Int);
utt.Value = ocr.UserTypeId;
cmd.Parameters.Add(utt);
SqlParameter active = new SqlParameter("@Active", SqlDbType.Int);
active.Value = ocr.Active;
cmd.Parameters.Add(active);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
// traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "UpdateUser successful....");
}
catch (Exception ex)
{
// traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "UpdateUser...." + ex.Message.ToString());
//throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, 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);
}
finally
{
conn.Close();
conn.Dispose();
SqlConnection.ClearPool(conn);
}
return(dt);
}
public DataTable RegisterBusinessAppUser(BusinessUserStafff ocr)
{
DataTable dt = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
StringBuilder str = new StringBuilder();
try
{
//traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "RegisterUser....");
str.Append("Mobilenumber:" + ocr.Mobilenumber + ",");
str.Append("Email:" + ocr.Email + ",");
str.Append("Username:"******",");
//traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString());
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PSInsUpdBusinessUsersStaff";
cmd.Connection = conn;
SqlParameter f = new SqlParameter("@flag", SqlDbType.VarChar);
f.Value = ocr.flag;
cmd.Parameters.Add(f);
SqlParameter c = new SqlParameter("@Username", SqlDbType.VarChar, 20);
c.Value = ocr.Username;
cmd.Parameters.Add(c);
SqlParameter ce = new SqlParameter("@Email", SqlDbType.VarChar, 50);
ce.Value = ocr.Email;
cmd.Parameters.Add(ce);
SqlParameter cm = new SqlParameter("@Mobilenumber", SqlDbType.VarChar, 20);
cm.Value = ocr.Mobilenumber;
cmd.Parameters.Add(cm);
SqlParameter q1 = new SqlParameter("@Password", SqlDbType.VarChar, 50);
q1.Value = ocr.Password;
cmd.Parameters.Add(q1);
SqlParameter v = new SqlParameter("@Firstname", SqlDbType.VarChar, 50);
v.Value = ocr.Firstname;
cmd.Parameters.Add(v);
SqlParameter v1 = new SqlParameter("@lastname", SqlDbType.VarChar, 50);
v1.Value = ocr.lastname;
cmd.Parameters.Add(v1);
SqlParameter v2 = new SqlParameter("@AuthTypeId", SqlDbType.VarChar, 50);
v2.Value = ocr.AuthTypeId;
cmd.Parameters.Add(v2);
SqlParameter u = new SqlParameter("@AltPhonenumber", SqlDbType.VarChar, 50);
u.Value = ocr.AltPhonenumber;
cmd.Parameters.Add(u);
SqlParameter u1 = new SqlParameter("@Altemail", SqlDbType.VarChar, 50);
u1.Value = ocr.Altemail;
cmd.Parameters.Add(u1);
SqlParameter i = new SqlParameter("@AccountNumber", SqlDbType.VarChar, 50);
i.Value = ocr.AccountNo;
cmd.Parameters.Add(i);
SqlParameter ct = new SqlParameter("@CountryId", SqlDbType.Int);
ct.Value = ocr.CountryId;
cmd.Parameters.Add(ct);
SqlParameter cts = new SqlParameter("@CurrentStateId", SqlDbType.Int);
cts.Value = ocr.CurrentStateId;
cmd.Parameters.Add(cts);
SqlParameter pd = new SqlParameter("@UserPhoto", SqlDbType.VarChar, 50);
pd.Value = ocr.UserPhoto;
cmd.Parameters.Add(pd);
SqlParameter paym = new SqlParameter("@PaymentModeId", SqlDbType.Int);
paym.Value = ocr.PaymentModeId;
cmd.Parameters.Add(paym);
SqlParameter ccode = new SqlParameter("@CCode", SqlDbType.VarChar, 10);
ccode.Value = ocr.CCode;
cmd.Parameters.Add(ccode);
SqlParameter uaccno = new SqlParameter("@UserAccountNo", SqlDbType.VarChar, 15);
uaccno.Value = ocr.UserAccountNo;
cmd.Parameters.Add(uaccno);
SqlParameter utt = new SqlParameter("@UserTypeId", SqlDbType.Int);
utt.Value = ocr.UserTypeId;
cmd.Parameters.Add(utt);
SqlParameter active = new SqlParameter("@Active", SqlDbType.Int);
active.Value = ocr.Active;
cmd.Parameters.Add(active);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
//[Mobileotp] ,[Emailotp]
//send email otp\
// #region email opt
// string eotp = dt.Rows[0]["Emailotp"].ToString();
// if (eotp != 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(ocr.Email);
// 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>" + eotp + @" </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
//send mobile otp as SMS
// #region Mobile OTP
// string motp = dt.Rows[0]["Mobileotp"].ToString();
// if (motp != 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(ocr.Email);
// mail.Subject = "User registration - Mobile 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 Mobile OTP is:<h3>" + motp + @" </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));
// }
// }
// #endregion Mobile OTP
//traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "RegisterUser successful....");
}
catch (Exception ex)
{
// traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "RegisterUser...." + ex.Message.ToString());
//throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, 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);
}
finally
{
conn.Close();
conn.Dispose();
SqlConnection.ClearPool(conn);
}
return(dt);
}
