public ActionResult Login(Model_Login model)
{
if (User.Identity.IsAuthenticated)
{
return(RedirectToAction("index", "Dashboard"));
}
if (!ModelState.IsValid)
{
ViewBag.State = "Error";
return(View("Login", model));
}
var q = db.Tbl_Login.Where(a => a.Login_Email == model.Username || a.Login_Mobile == model.Username).SingleOrDefault();
if (q == null)
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "کاربر یافت نشد !";
return(View());
}
var SaltPassword = model.Password + q.Login_PasswordSalt;
var SaltPasswordBytes = Encoding.UTF8.GetBytes(SaltPassword);
var SaltPasswordHush = Convert.ToBase64String(SHA512.Create().ComputeHash(SaltPasswordBytes));
if (q.Login_PasswordHash == SaltPasswordHush)
{
string s = string.Empty;
s = Rep_UserRole.Get_RoleNameWithID(q.Login_RoleID);
var Ticket = new FormsAuthenticationTicket(0, model.Username, DateTime.Now, model.RemenberMe ? DateTime.Now.AddDays(30) : DateTime.Now.AddDays(1), true, s);
var EncryptedTicket = FormsAuthentication.Encrypt(Ticket);
var Cookie = new HttpCookie(FormsAuthentication.FormsCookieName, EncryptedTicket)
{
Expires = Ticket.Expiration
};
Response.Cookies.Add(Cookie);
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "خوش آمدید";
return(RedirectToAction("index", "Dashboard"));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "پسورد نادرست است !";
return(View());
}
}
public void loginUser(String username, String password)
{
ConnectDatabase connectBase = new ConnectDatabase();
SqlCommand selectUser = new SqlCommand();
selectUser.CommandText = "Select p.Patient_id, p.Firstname, p.Lastname, p.Nickname, p.Birth, p.Gender, p.Address, p.Email, p.Tel, p.Id_card," +
"p.ChronicD, p.Bloodtype, p.Rh, p.Allergydrug, p.Cousin, p.Cousintell, p.username, p.password From PATIENT p " +
"Where username = @TextBoxUN and password = @TextBoxPW";
selectUser.Parameters.AddWithValue("@TextBoxUN", username);
selectUser.Parameters.AddWithValue("@TextBoxPW", password);
selectUser.Connection = connectBase.getConnectDatabase();
connectBase.OpenDatabase();
SqlDataReader dataUser = selectUser.ExecuteReader();
Model_Login modelLogin = new Model_Login();
if (dataUser.HasRows)
{
modelLogin.return_code = Return.RETURN_CODE_SUCCESS;
modelLogin.return_description = Return.RETURN_DESCRIPTION_SUCCESS;
modelLogin.user_profile = new Model_User();
while (dataUser.Read())
{
modelLogin.user_profile.Patient_id = Int32.Parse(dataUser[0].ToString());
modelLogin.user_profile.Firstname = (dataUser[1].ToString());
modelLogin.user_profile.Lastname = (dataUser[2].ToString());
modelLogin.user_profile.Nickname = (dataUser[3].ToString());
modelLogin.user_profile.Birth = (dataUser[4].ToString());
modelLogin.user_profile.Gender = (dataUser[5].ToString());
modelLogin.user_profile.Address = (dataUser[6].ToString());
modelLogin.user_profile.Email = (dataUser[7].ToString());
modelLogin.user_profile.Tel = (dataUser[8].ToString());
modelLogin.user_profile.Id_card = Int64.Parse(dataUser[9].ToString());
modelLogin.user_profile.ChronicD = (dataUser[10].ToString());
modelLogin.user_profile.Bloodtype = (dataUser[11].ToString());
modelLogin.user_profile.Rh = (dataUser[12].ToString());
modelLogin.user_profile.Allergydrug = (dataUser[13].ToString());
modelLogin.user_profile.Cousin = (dataUser[14].ToString());
modelLogin.user_profile.Cousintell = (dataUser[15].ToString());
modelLogin.user_profile.username = (dataUser[16].ToString());
modelLogin.user_profile.password = (dataUser[17].ToString());
}
dataUser.Close();
}
else
{
modelLogin.return_code = Return.RETURN_CODE_ERROR;
modelLogin.return_description = Return.RETURN_DESCRIPTION_ERROR;
}
connectBase.CloseDatabase();
Context.Response.Write(JsonConvert.SerializeObject(modelLogin));
Context.Response.End();
}
public void loginUser(String username, String password)
{
ConnectDatabase connectBase = new ConnectDatabase();
SqlCommand selectUser = new SqlCommand();
selectUser.CommandText = "Select Patient_id,username,password" +
"From PATIENT Where username = @TextBoxUN and password = @TextBoxPW";
selectUser.Parameters.AddWithValue("@TextBoxUN", username);
selectUser.Parameters.AddWithValue("@TextBoxPW", password);
selectUser.Connection = connectBase.getConnectDatabase();
connectBase.OpenDatabase();
SqlDataReader dataUser = selectUser.ExecuteReader();
Model_Login modelLogin = new Model_Login();
if (dataUser.HasRows)
{
//modelLogin.return_code = Return.RETURN_CODE_SUCCESS;
//modelLogin.return_description = Return.RETURN_DESCRIPTION_SUCCESS;
modelLogin.user_profile = new Model_User();
while (dataUser.Read())
{
modelLogin.user_profile.Patient_id = Int32.Parse(dataUser[0].ToString());
modelLogin.user_profile.username = (dataUser[1].ToString());
modelLogin.user_profile.password = (dataUser[2].ToString());
}
dataUser.Close();
}
else
{
//modelLogin.return_code = Return.RETURN.CODE_ERROR;
//modelLogin.return_description = Return.RETURN_DESCRIPTION_ERROR;
}
connectBase.CloseDatabase();
Context.Response.Write(JsonConvert.SerializeObject(modelLogin));
Context.Response.End();
}
private void TampilDaftarKodenota()
{
Model_Login m = new Model_Login();
bool stat = false;
bool ada = false;
list_daftar_kodenota.Clear();
grid_progress.Visibility = Visibility.Visible;
BackgroundWorker worker = new BackgroundWorker();
worker.WorkerReportsProgress = true;
worker.ProgressChanged += delegate
{
};
worker.DoWork += delegate
{
try
{
using (SqlConnection connection = new SqlConnection(Setting_variabel.mykoneksi_sql))
{
connection.Open();
String sqlQuery = "select m.KodeNota,m.TglBerangkat,m.isClose,m.SudahKembali, " +
"(select COUNT(1) from DetailPerjalanan dp join " +
"(select kode = min(kode) from pelanggan " +
"group by cif) p on dp.cust = p.kode where dp.kodenota = m.kodenota and " +
"(dp.Checkin is not null and dp.Checkin > '2000-01-01')) as JmlTerkunjungi, " +
"(select COUNT(1) from DetailPerjalanan dp join " +
"(select kode = min(kode) from pelanggan " +
"group by cif) p on dp.cust = p.kode where dp.kodenota = m.kodenota) as JmlKunjungan " +
"from masterperjalanan m " +
"where m.tglberangkat >= '" + TGLSEKARANG + "' and " +
"m.tglberangkat < '" + TGLBESOK + "' and " +
"m.Sales = '" + KODESALES + "' order by m.TglBerangkat desc";
using (SqlCommand command = new SqlCommand(sqlQuery, connection))
{
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Model_Kodenota item = new Model_Kodenota();
item.Kodenota = reader.GetString(0);
try
{
item.TglBerangkat = "" + reader.GetDateTime(1);
}
catch (Exception e) { }
try
{
item.IsClose = reader.GetBoolean(2);
}
catch (Exception e) { }
try
{
item.IsSudahKembali = reader.GetBoolean(3);
}
catch (Exception e) { }
item.JmlTerkunjungi = reader.GetInt32(4);
item.JmlKunjungan = reader.GetInt32(5);
App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
{
list_daftar_kodenota.Add(item);
});
ada = true;
}
stat = true;
reader.Close();
}
m.Keterangan = "Unable to process your request";
connection.Close();
}
}
catch (Exception e)
{
m.Keterangan = "Unable to process your request: " + e.Message;
Console.WriteLine("" + e.Message + " " + e.StackTrace);
}
};
//worker.ProgressChanged += worker_ProgressChanged;
worker.RunWorkerCompleted += delegate
{
grid_progress.Visibility = Visibility.Collapsed;
m.IsSukses = stat;
if (m.IsSukses == true)
{
if (ada == false)
{
MessageBox.Show("Could not found travel code for sales \"" + KODESALES + "\" at " + TGLSEKARANG + " ",
"Information", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
else
{
MessageBox.Show("" + m.Keterangan, "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
}
};
worker.RunWorkerAsync();
}
private void TampilDaftarSearch(string input)
{
Model_Login m = new Model_Login();
bool stat = false;
bool ada = false;
list_daftar_sales.Clear();
grid_progress.Visibility = Visibility.Visible;
BackgroundWorker worker = new BackgroundWorker();
worker.WorkerReportsProgress = true;
worker.ProgressChanged += delegate
{
};
worker.DoWork += delegate
{
try
{
using (SqlConnection connection = new SqlConnection(Setting_variabel.mykoneksi_sql))
{
connection.Open();
String sqlQuery = "select Kode,Nama from SalesPerson where username like '%" + input + "%' or nama like '%" + input + "%' or Kode like '%" + input + "%' and Aktif=1";
using (SqlCommand command = new SqlCommand(sqlQuery, connection))
{
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Model_Sales item = new Model_Sales();
item.KodeSales = reader.GetString(0);
item.NamaSales = reader.GetString(1);
App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
{
list_daftar_sales.Add(item);
});
ada = true;
}
stat = true;
reader.Close();
}
m.Keterangan = "Unable to process your request";
connection.Close();
}
}
catch (Exception e)
{
m.Keterangan = "Unable to process your request: " + e.Message;
Console.WriteLine("" + e.Message + " " + e.StackTrace);
}
};
//worker.ProgressChanged += worker_ProgressChanged;
worker.RunWorkerCompleted += delegate
{
grid_progress.Visibility = Visibility.Collapsed;
m.IsSukses = stat;
if (m.IsSukses == true)
{
if (ada == false)
{
MessageBox.Show("Could not found \"" + input + "\"",
"Information", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
else
{
MessageBox.Show("" + m.Keterangan, "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
}
};
worker.RunWorkerAsync();
}
