public HttpResponseMessage CreateOTPRegistraion(dynamic SearchForm)
{
try
{
string Email = string.Empty;
Email = (string)SearchForm.Email;
string OTPType = string.Empty;
OTPType = (string)SearchForm.OTPType;
UserClass CLE = new UserClass();
DataTable dt = new DataTable();
dt = CLE.FN_CreateOTPRegistraion(Email, OTPType);
string OTPCode = "";
if (dt.Rows.Count > 0)
{
OTPCode = dt.Rows[0]["OPTCode"].ToString();
string Emails = dt.Rows[0]["email"].ToString();
string OTPtext = "Use below code to " + OTPType + " your Account (The below otp is only for " + OTPType + " Account)";
ClassEmail OBJ = new ClassEmail();
string EmailText = OBJ.GetTemplate("otp.htm");
EmailText = EmailText.Replace("XXXOTPTypeXX", OTPtext).Replace("XXOTPXX", OTPCode);
try { OBJ.sendMail(Emails, "OTP code for registration", EmailText); } catch { }
}
return(Request.CreateResponse(HttpStatusCode.OK, OTPCode));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "500_Internal_Server_Error"));
}
}
public string FN_Register(RegisterShape LoginUser, string IPAddress, out string RegNO)
{
string status = "";
string AppMstRegNo = "";
SqlConnection con = new SqlConnection(method.str);
SqlCommand com = new SqlCommand("Insertdata5", con);
com.CommandType = CommandType.StoredProcedure;
com.CommandTimeout = 99999999;
com.Parameters.AddWithValue("@SessionID", LoginUser.SponsorId.Trim());
com.Parameters.AddWithValue("@sponserID", LoginUser.SponsorId.Trim());
com.Parameters.AddWithValue("@AppMstFName", LoginUser.Name.Trim());
com.Parameters.AddWithValue("@mobile", "NA");
com.Parameters.AddWithValue("@emailid", LoginUser.Email.Trim());
com.Parameters.AddWithValue("@AppMstleftright", LoginUser.Position.Trim());
com.Parameters.AddWithValue("@BTCAddres", "NA");
com.Parameters.AddWithValue("@country", LoginUser.country.Trim());
com.Parameters.AddWithValue("@Pwd", LoginUser.Password.Trim());
com.Parameters.AddWithValue("@IPAddress", IPAddress);
com.Parameters.AddWithValue("@Key", LoginUser.Password.Trim());
com.Parameters.AddWithValue("@OTP", LoginUser.OTP.Trim());
com.Parameters.Add("@regDisplay", SqlDbType.VarChar, 50).Direction = ParameterDirection.Output;
com.Parameters.Add("@flag", SqlDbType.VarChar, 50).Direction = ParameterDirection.Output;
com.Parameters.Add("@flagpwd", SqlDbType.VarChar, 50).Direction = ParameterDirection.Output;
try
{
con.Open();
com.CommandTimeout = 999999;
com.ExecuteNonQuery();
RegNO = com.Parameters["@regDisplay"].Value.ToString();
string flagpwd = com.Parameters["@flagpwd"].Value.ToString();
status = com.Parameters["@flag"].Value.ToString();
if (status == "1")
{
AppMstRegNo = status;
ClassEmail OBJ = new ClassEmail();
string EmailText = OBJ.GetTemplate("successful.htm");
EmailText = EmailText.Replace("XXNameXX", LoginUser.Name.Trim().ToUpper()).Replace("XXusernameXX", RegNO).Replace("XXpasswordXX", flagpwd);
try { OBJ.sendMail(LoginUser.Email.Trim(), "Welcome To XS COIN", EmailText); } catch { }
}
else
{
AppMstRegNo = status;
}
}
catch (Exception ex)
{
RegNO = "";
AppMstRegNo = status;
}
return(AppMstRegNo);
}
public IHttpActionResult CreateNewEmail(ClassEmail email)
{
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls;
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
mail.From = new MailAddress(email.From);
mail.To.Add("*****@*****.**");
mail.Subject = email.Subject;
mail.Body = email.Body;
SmtpServer.Port = 25;
SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "j123456e");
SmtpServer.EnableSsl = true;
SmtpServer.Send(mail);
return(Ok());
}
private void btnAceptar_Click(object sender, EventArgs e)
{
this._inscrialu.idcuota = this.dgvHistorialCuotas[0, this.dgvHistorialCuotas.CurrentCell.RowIndex].Value.ToString();
this._inscrialu.numcuota = int.Parse(this.dgvHistorialCuotas[1, this.dgvHistorialCuotas.CurrentCell.RowIndex].Value.ToString()) + 1;
this._inscrialu.idcurso = this._idcurso;
this._inscrialu.fecharealpago = DateTime.Parse(this.txtFechaRealPago.Text).ToString("yyyy/MM/dd");
this._inscrialu.fechaproximopago = DateTime.Parse(this.txtFechaPago.Text).AddMonths(1).ToString("yyyy/MM/dd");
this._inscrialu.montocuota = Decimal.Parse(this.txtMontoCuota.Text);
this._inscrialu.montopagado = Decimal.Parse(this.txtAlumnoPaga.Text);
this._inscrialu.montosaldo = Decimal.Parse(this.txtMontoDeuda.Text);
this._inscrialu.accion = "N";
this._inscrialu.fechaaccion = DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss");
this._inscrialu.idempleadoaccion = 1; //Viene del login
this._inscrialu.idpuntoaccion = 1; //Viene del login
this.dgvHistorialCuotas.DataSource = this._inscrialu.ABMCuotasSocios(this._inscrialu, "CuotasSocio");
this.dgvHistorialCuotas.DataMember = "CuotasSocio";
if (this.dgvHistorialCuotas.Rows.Count > 0)
{
//Idcurso
this.dgvHistorialCuotas.Columns[0].Visible = false;
//Fecha real pago
this.dgvHistorialCuotas.Columns[2].Visible = false;
//se inicio proceso de notificación de envio por mail del pago de cuota
this.email = new ClassEmail();
if (this.email.PagoCuota(this.txtEmail.Text, this.txtPunto.Text, this.txtFechaRealPago.Text, this.txtApellido.Text + ", " + this.txtNombre.Text, this.txtTipoClase.Text, this.txtNombreClase.Text, this.txtMontoCuota.Text, this.dgvHistorialCuotas[1, this.dgvHistorialCuotas.CurrentCell.RowIndex].Value.ToString(), this.txtDebePagar.Text, this.txtAlumnoPaga.Text, this.txtMontoSaldo.Text, DateTime.Parse(this.txtFechaPago.Text).AddMonths(1).ToString("dd/MM/yyyy")) == true)
{
//se finaliza notificación del envio de mail de pago de cuota
MessageBox.Show("Acción realizada con exito!!!", "Atención!!!");
}
else
{
MessageBox.Show("No se pudo enviar mail a cliente!!!", "Error!!!");
}
}
}
public HttpResponseMessage ForgetPassword(dynamic LoginUser)
{
try
{
string Login = string.Empty;
Login = (string)LoginUser.LoginID;
ClassUserAccount Resp = new ClassUserAccount();
DataTable dt = new DataTable();
string Password = "";
string Email = "";
string Name = "";
dt = Resp.FN_ForgetPassword(Login);
if (dt.Rows.Count > 0)
{
Password = dt.Rows[0]["AppMstPassword"].ToString();
Email = dt.Rows[0]["email"].ToString();
Name = dt.Rows[0]["AppMstFName"].ToString();
ClassEmail OBJ = new ClassEmail();
string EmailText = OBJ.GetTemplate("forgotpass.htm");
EmailText = EmailText.Replace("XXNameXX", Name.ToUpper()).Replace("XXUserIDXX", Login).Replace("XXPaswordIDXX", Password);
try { OBJ.sendMail(Email, "Password", EmailText); } catch { }
return(Request.CreateResponse(HttpStatusCode.OK, new { USERID = Email }));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "UserID and Passwrod invalid"));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "500_INTERNAL_SERVER_ERROR"));
}
}
protected void btnallocate_Click(object sender, EventArgs e)
{
try
{
if (grvRequest.SelectedIndex < 0)
{
lblmsg.Text = "Please select request to allocate."; return;
}
if (ddlallocateto.SelectedIndex == 0)
{
lblmsg.Text = "Please select Allocate To."; ddlallocateto.Focus(); return;
}
string strUpdateReq = "Update RequestMaster set AlloToEmpCode='" + ddlallocateto.SelectedItem.Value + "',AlloDate=getdate(),AlloByEmpCode='" + Session["EmpCode"].ToString() + "',ReqStatus='Progress' where reqID=" + lblReqID.Text;
strUpdateReq = objdb.ExecuteInsertUpdate(strUpdateReq);
if (strUpdateReq != "" && strUpdateReq != null && strUpdateReq != "0")
{
lblmsg.Text = "Request allocated."; tblAllocateto.Visible = false;
//send email
if (ConfigurationManager.AppSettings["sendemail"] == "Y")
{
//get request details
DataSet ds = new DataSet();
ds = new DataSet();
ds = objdb.GetDataset("select * from RequestMaster where reqID=" + lblReqID.Text, "RequestMaster");
DataRow rrm;
rrm = ds.Tables["RequestMaster"].Rows[0];
//get req by employee details
ds = new DataSet();
ds = objdb.GetDataset("select * from empmaster where empcode='" + rrm["reqbyempcode"].ToString() + "'", "empmaster");
DataRow remp;
remp = ds.Tables["empmaster"].Rows[0];
//get allocate emp details
ds = new DataSet();
ds = objdb.GetDataset("select * from empmaster where empcode='" + rrm["AlloToEmpCode"].ToString() + "'", "empmaster");
DataRow raemp;
raemp = ds.Tables["empmaster"].Rows[0];
//get request tat
ds = new DataSet();
ds = objdb.GetDataset("select * from ReqTypeMaster where ReqIypeId=" + rrm["ReqTypeMasterID"].ToString() + "", "ReqTypeMaster");
DataRow r;
r = ds.Tables["ReqTypeMaster"].Rows[0];
int tat;
tat = int.Parse(r["ReqTat"].ToString());
string dt = DateTime.Now.AddDays(tat).ToString("dd-MMM-yy hh:mm");
//send email
string strbody = "Dear " + remp["empname"].ToString() + ",<br><br> Your request no " + lblReqID.Text + " is allocated to " + raemp["empname"].ToString() + ". Your request will be completed on or before " + dt.ToString() + "<br><hr>" +
"<b>Request Id : </b>" + lblReqID.Text + "<br>" +
"<b>Request Date : </b>" + DateTime.Parse(rrm["ReqDate"].ToString()).ToString("dd-MMM-yy hh:mm") + "<br>" +
"<b>Request Type : </b>" + r["reqtype"].ToString() + "<br>" +
"<b>Request :</b> " + rrm["request"].ToString() + "<hr>" +
"<br><br>Regards<br>RMS Team.";
string tomail;
tomail = remp["email"].ToString() + "," + raemp["email"].ToString();
String Ans = ClassEmail.SendMail(tomail, tomail, "RMS - Request No " + lblReqID.Text + " Allocated", strbody);
if (Ans == "OK")
{
}
}
ShowRequestGrid();
}
else
{
lblmsg.Text = "Error :" + objdb.returnMsg;
}
}
catch (Exception ex) { lblmsg.Text = "Error : " + ex.Message.ToString(); }
}
