public ActionResult Register(SYS_USER_PUBLIC sysuser_public, SYS_USER sysuser, string jawaban = "", string browser = "")
{
var DATAUSER = new VIEW_USERS_PUBLIC();
string username = sysuser.USER_NAME;
//var DATAUSER = portaldb.Database.SqlQuery<decimal>("SELECT COUNT(*) FROM VIEW_USERS_PUBLIC WHERE USER_NAME = '" + username + "' AND USER_STATUS = 1 AND ACCESS_STATUS = 1").SingleOrDefault(); ;
DATAUSER = (from it in portaldb.VIEW_USERS_PUBLIC where it.USER_NAME == username && it.USER_STATUS == 1 && it.ACCESS_STATUS == 1 select it).FirstOrDefault();
//return Content(""+DATAUSER);
if (Session["Captcha"] == null || Session["Captcha"].ToString() != jawaban)
{
var MsgError = "Jawaban Captcha salah";
TempData["isError"] = 1;
TempData["MessageError"] = MsgError;
return(RedirectToAction("Register"));
}
else
{
if (DATAUSER != null)
{
var MsgError = "Username Sudah Terdaftar";
TempData["isError"] = 1;
TempData["MessageError"] = MsgError;
return(RedirectToAction("Register"));
}
else
{
var logcodePublic = MixHelper.GetLogCode();
var logcodeUser = MixHelper.GetLogCode();
int lastidUserPublic = MixHelper.GetSequence("SYS_USER_PUBLIC");
int lastIdUser = MixHelper.GetSequence("SYS_USER");
var datenow = MixHelper.ConvertDateNow();
//For Data User Public
var KodeActivasi = GenPassword(sysuser_public.USER_PUBLIC_KTPSIM);
var fNamePublic = "USER_PUBLIC_ID,USER_PUBLIC_KTPSIM,USER_PUBLIC_NOKK,USER_PUBLIC_NAMA_LENGKAP,USER_PUBLIC_EMAIL,USER_PUBLIC_TELPON,USER_PUBLIC_STAKEHOLDER,USER_PUBLIC_PROVINSI_ID,USER_PUBLIC_KOTAKAB_ID,USER_PUBLIC_CREATE_BY,USER_PUBLIC_CREATE_DATE,USER_PUBLIC_UPDATE_BY,USER_PUBLIC_UPDATE_DATE,USER_PUBLIC_TOKEN_KEY,USER_PUBLIC_ACTIVATION_KEY,USER_PUBLIC_LOG_CODE,USER_PUBLIC_STATUS,USER_PUBLIC_LINK_ACTIVATION";
var fValuePublic = "'" + lastidUserPublic + "', " +
"'" + sysuser_public.USER_PUBLIC_KTPSIM + "', " +
"'" + sysuser_public.USER_PUBLIC_NOKK + "', " +
"'" + sysuser_public.USER_PUBLIC_NAMA_LENGKAP + "', " +
"'" + sysuser_public.USER_PUBLIC_EMAIL + "', " +
"'" + sysuser_public.USER_PUBLIC_TELPON + "', " +
"'" + sysuser_public.USER_PUBLIC_STAKEHOLDER + "', " +
"'" + sysuser_public.USER_PUBLIC_PROVINSI_ID + "', " +
"'" + sysuser_public.USER_PUBLIC_KOTAKAB_ID + "', " +
"'" + lastidUserPublic + "'," +
datenow + "," +
"''," +
"''," +
"'" + RandomPassHelper.Generate(20) + "'," +
"'" + KodeActivasi + "'," +
"'" + logcodePublic + "'," +
"1," +
"'" + @Request.Url.GetLeftPart(UriPartial.Authority) + "/main/useraktivasi/" + KodeActivasi + "'";
//Insert to Tabel SYS_USER_PUBLIC
var insertPublic = portaldb.Database.ExecuteSqlCommand("INSERT INTO SYS_USER_PUBLIC (" + fNamePublic + ") VALUES (" + fValuePublic.Replace("''", "NULL") + ")");
String objekPublic = fValuePublic.Replace("'", "-");
//Insert Data User Public to Log SYS_LOG
MixHelper.InsertLogReg(logcodePublic, objekPublic, 1);
string pass = AuthHelper.GenPassword(sysuser.USER_PASSWORD);
//string pass = AuthHelper.GenPassword("sispk");
//For Data User
var fNameUser = "******";
var fValueUser = "******" + lastIdUser + "', " +
"4, " +
"'" + sysuser.USER_NAME + "', " +
"'" + pass + "', " +
"''," +
"''," +
"'" + lastIdUser + "'," +
datenow + "," +
"''," +
"''," +
"1, " +
"'" + logcodeUser + "'," +
"3, " +
"'" + lastidUserPublic + "'";
//Insert to Tabel SYS_USER_PUBLIC
//return Json(new { query = "INSERT INTO SYS_USER (" + fNameUser + ") VALUES (" + fValueUser.Replace("''", "NULL") + ")" });
var insertUser = portaldb.Database.ExecuteSqlCommand("INSERT INTO SYS_USER (" + fNameUser + ") VALUES (" + fValueUser.Replace("''", "NULL") + ")");
String objekUser = fValueUser.Replace("'", "-");
//Insert Data User to Log SYS_LOG
MixHelper.InsertLogReg(logcodeUser, objekUser, 1);
//Send Account Activation to Email
var email = (from t in db.SYS_EMAIL where t.EMAIL_IS_USE == 1 select t).SingleOrDefault();
SendMailHelper.MailUsername = email.EMAIL_NAME; //"*****@*****.**";
SendMailHelper.MailPassword = email.EMAIL_PASSWORD; //"r4h45143uy";
SendMailHelper mailer = new SendMailHelper();
mailer.ToEmail = sysuser_public.USER_PUBLIC_EMAIL;
mailer.Subject = "Registrasi Member Baru - Sistem Informasi SNI";
var isiEmail = "Terimakasih telah Melakukan Registrasi pada sistem kami. <br />";
isiEmail += "Username : "******"<br />";
isiEmail += "Password : "******"<br />";
//isiEmail += "Detail aktivasi akun anda sedang Menunggu Persetujuan administrator <br />";
//isiEmail += "Apabila data akun anda disetujui oleh administrator maka anda akan menerima email aktivasi <br />";
isiEmail += "Sekarang Anda bisa melakukan login di Sistem Informasi SNI <br />";
isiEmail += "Demikian Informasi yang kami sampaikan, atas kerjasamanya kami ucapkan terimakasih. <br />";
isiEmail += "<span style='text-align:right;font-weight:bold;margin-top:20px;'>Web Administrator</span>";
mailer.Body = isiEmail;
mailer.IsHtml = true;
mailer.Send();
TempData["MailMember"] = sysuser_public.USER_PUBLIC_EMAIL;
return(RedirectToAction("RegSukses"));
}
}
}