private void DoUpdate()
{
int id = ParseInt(TxtAccountNo.Text);
var data = new accounttbl
{
accountNo = id,
username = TxtUsername.Text,
password = Crypto.Encrypt(TxtPassword.Text),
roleName = TxtRoleName.SelectedValue,
modBy = currentUser,
modDate = DatetimeHelper.GetDatetimeNow()
};
var ret = accountControl.UpdateData(id.ToString(), data);
if (ret.Result)
{
ClearFields();
SetLayout(ModeForm.ViewData);
Alert("Data berhasil diubah");
}
else
{
Alert("Gagal mengubah data");
}
}
private void DoSave()
{
string pwd = Crypto.Encrypt(TxtPassword.Text);
var data = new accounttbl
{
username = TxtUsername.Text,
password = pwd,
roleName = TxtRoleName.SelectedValue,
isEmailVerified = "0",
creaBy = currentUser,
creaDate = DatetimeHelper.GetDatetimeNow()
};
var ret = accountControl.AddData(data);
if (ret.Result)
{
ClearFields();
SetLayout(ModeForm.ViewData);
Alert("data berhasil disimpan");
}
else
{
Alert("Gagal menyimpan data");
}
}
public async Task <bool> UpdateData(string id, accounttbl obj)
{
try
{
if (id != obj.accountNo.ToString())
{
return(false);
}
using (var context = new smlpobDB())
{
context.accounttbls.Attach(obj);
context.Entry(obj).Property(x => x.username).IsModified = true;
context.Entry(obj).Property(x => x.password).IsModified = true;
context.Entry(obj).Property(x => x.roleName).IsModified = true;
context.Entry(obj).Property(x => x.modBy).IsModified = true;
context.Entry(obj).Property(x => x.modDate).IsModified = true;
await context.SaveChangesAsync();
MembershipUser ms = Membership.GetUser(obj.username);
ms.ChangePassword(ms.ResetPassword(), Crypto.Decrypt(obj.password));
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.InnerException.ToString();
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
public async Task <bool> AddData(accounttbl obj)
{
try
{
using (var context = new smlpobDB())
{
var isExist = (from x in context.accounttbls
where x.username == obj.username
select x).SingleOrDefault();
if (isExist != null)
{
return(false);
}
context.accounttbls.Add(obj);
await context.SaveChangesAsync();
Membership.CreateUser(obj.username, Crypto.Decrypt(obj.password), obj.username);
Roles.AddUserToRole(obj.username, obj.roleName);
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.InnerException.ToString();
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
public async Task <bool> UpdateData(string id, accounttbl obj)
{
try
{
if (id != obj.username)
{
return(false);
}
using (var context = new smlpobDB())
{
context.accounttbls.Attach(obj);
context.Entry(obj).Property(x => x.accountNo).IsModified = true;
context.Entry(obj).Property(x => x.username).IsModified = true;
context.Entry(obj).Property(x => x.password).IsModified = true;
context.Entry(obj).Property(x => x.roleName).IsModified = true;
context.Entry(obj).Property(x => x.isEmailVerified).IsModified = true;
await context.SaveChangesAsync();
MembershipUser user = Membership.GetUser(obj.username);
if (user != null)
{
user.IsApproved = true;
user.UnlockUser();
Membership.UpdateUser(user);
}
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
public async Task <bool> AddData(accounttbl obj)
{
try
{
using (var context = new smlpobDB())
{
context.accounttbls.Add(obj);
await context.SaveChangesAsync();
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
private void DoContinue()
{
try
{
string userId = Request.QueryString["userId"];
if (userId.Contains("¡"))
{
userId = userId.Replace("¡", "@");
}
var result = registerControls.MasterData(userId);
var datas = result.Result;
var data = new accounttbl
{
accountNo = datas.accountNo,
username = datas.username,
password = datas.password,
roleName = datas.roleName,
isEmailVerified = "1"
};
var ret = registerControls.UpdateData(userId, data);
if (ret.Result)
{
Response.Redirect("Login.aspx");
}
else
{
CommonWeb.Alert(this, "Gagal mengubah data");
}
}
catch (Exception ex)
{
CommonWeb.Alert(this, "Terjadi kesalahan: " + ex.Message);
}
}
protected async void BtnDaftar_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(txtemail.Text))
{
var seldata = context.customertbls.Where(x => x.customerEmail == txtemail.Text).ToList();
if (seldata != null && seldata.Count > 0)
{
CommonWeb.Alert(this, "Email ini sudah terdaftar");
}
else
{
try
{
//register to asp membership first!
MembershipUser user = Membership.CreateUser(txtemail.Text, txtpassword.Text, txtemail.Text);
//account
string pwd = Crypto.Encrypt(txtpassword.Text);
var NewItem = new accounttbl()
{
username = txtemail.Text,
password = pwd,
roleName = "pelanggan",
creaBy = "registration system",
creaDate = DatetimeHelper.GetDatetimeNow(),
isEmailVerified = "0"
};
//customers
var IDS = txtemail.Text;
var idacc = (from x in context.accounttbls
where x.username == IDS
select x.accountNo).FirstOrDefault();
var NewItem2 = new customertbl()
{
customerName = txtusername.Text,
customerEmail = txtemail.Text,
companyName = txtcompanyname.Text,
companyAddress = txtaddress.Text,
companyPhone = txtphone.Text,
companyEmail = txtcompanyemail.Text,
accountNo = idacc,
creaBy = "registration system",
creaDate = DatetimeHelper.GetDatetimeNow()
};
context.accounttbls.Add(NewItem);
context.customertbls.Add(NewItem2);
context.SaveChanges();
var roleFromAccountTable = registerControls.GetRole(txtemail.Text);
string role = roleFromAccountTable;
Roles.AddUserToRole(txtemail.Text, role);
//kirim email
var subject = "Aktivasi Akun untuk Sistem Informasi Pelayanan Online Balitanah";
var mainMessage = "Silahkan klik link berikut untuk mengaktivasi akun anda:";
var message = mainMessage + $"<br> <a href='{ConfigurationManager.AppSettings["RootWebUrl"]}/Pages/Public/Activation.aspx?userId={txtemail.Text}'>Aktivasi Akun</a>";
var msgPhone = mainMessage + $" { ConfigurationManager.AppSettings["RootWebUrl"]}/Pages/Public/Activation.aspx?userId={txtemail.Text}";
var ret = EmailService.SendEmail(subject, message, txtemail.Text);
await SmsService.SendSms(msgPhone, txtphone.Text);
//var userAdded = Membership.GetUser(txtemail.Text);
//if (userAdded != null)
//{
// userAdded.IsApproved = true;
// userAdded.UnlockUser();
// Membership.UpdateUser(userAdded);
//}
Response.Redirect("RegisterDone.aspx", false);
Context.ApplicationInstance.CompleteRequest();
}
catch (Exception ex)
{
TxtStatus.Text = "Gagal menyimpan data registrasi, silakan isi dengan lengkap data-data yang diperlukan.";
LogHelpers.source = this.GetType().ToString();
LogHelpers.message = "fail to register user:"******"Gagal menyimpan data registrasi, silakan isi dengan lengkap data-data yang diperlukan.";
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
try
{
//update
if (!string.IsNullOrEmpty(TxtID.Value))
{
var IDS2 = int.Parse(TxtID.Value);
var NewItem2 = (from x in context.customertbls
where x.customerNo == IDS2
select x).FirstOrDefault();
NewItem2.customerName = txtNama.Text;
NewItem2.customerEmail = txtEmail.Text;
NewItem2.companyName = txtPerusahaan.Text;
NewItem2.companyAddress = txtPerusahaan.Text;
NewItem2.companyPhone = txtNoTelepon.Text;
NewItem2.companyEmail = txtCompanyEmail.Text;
NewItem2.creaBy = "Coba";
NewItem2.modBy = "Cobaa";
NewItem2.creaDate = DateTime.Now;
NewItem2.modDate = DateTime.Now;
//NewItem2.customerNo = Convert.ToInt32(TxtcustomerNo.Text);
var IDS = txtEmail.Text;
var idacc1 = (from x in context.customertbls
where x.customerEmail == IDS
select x.accountNo).FirstOrDefault();
var NewItem = (from x in context.accounttbls
where x.accountNo == idacc1
select x).FirstOrDefault();
//var IDS = txtemai;
//var NewItem = (from x in context.accounttbls
// where x.accountNo == IDS
// select x).FirstOrDefault();
NewItem.username = txtEmail.Text;
NewItem.password = txtPassword.Text;
NewItem.roleName = "Customer";
NewItem.creaBy = "Coba";
NewItem.modBy = "Cobaaa";
NewItem.creaDate = DateTime.Now;
NewItem.modDate = DateTime.Now;
NewItem.isEmailVerified = "0";
//NewItem.accountNo = Convert.ToInt32(TxtAccountNo.Text);
}
else //add new
{
var seldata2 = context.customertbls.Select(x => x.customerEmail).ToList();
foreach (var item in seldata2)
{
if (txtEmail.Text == item)
{
TxtStatus.Text = "Email Sudah Terdaftar";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Email Sudah Terdaftar')", true);
}
else if (txtEmail.Text != item)
{
//account
var NewItem = new accounttbl()
{
};
NewItem.username = txtEmail.Text;
NewItem.password = txtPassword.Text;
NewItem.roleName = "Customer";
NewItem.creaBy = "Coba";
NewItem.modBy = "Cobaaa";
NewItem.creaDate = DateTime.Now;
NewItem.modDate = DateTime.Now;
NewItem.isEmailVerified = "0";
context.accounttbls.Add(NewItem);
//customor
var IDS = txtEmail.Text;
var idacc = (from x in context.accounttbls
where x.username == IDS
select x.accountNo).FirstOrDefault();
var NewItem2 = new customertbl()
{
};
NewItem2.customerName = txtNama.Text;
NewItem2.customerEmail = txtEmail.Text;
NewItem2.companyName = txtPerusahaan.Text;
NewItem2.companyAddress = txtPerusahaan.Text;
NewItem2.companyPhone = txtNoTelepon.Text;
NewItem2.companyEmail = txtCompanyEmail.Text;
NewItem2.accountNo = idacc;
NewItem2.creaBy = "Coba";
NewItem2.modBy = "Cobaa";
NewItem2.creaDate = DateTime.Now;
NewItem2.modDate = DateTime.Now;
//data2.accountNo = Convert.ToInt32(txtAccountNo.Text);
context.customertbls.Add(NewItem2);
}
else
{
TxtStatus.Text = "gagal save";
}
}
}
context.SaveChanges();
PanelGrid.Visible = true;
PanelInput.Visible = false;
RefreshGrid();
}
catch (Exception ex)
{
TxtStatus.Text = "gagal save --> " + ex.Message;
}
}