private void button1_Click(object sender, EventArgs e)
{
dashboard dash = new dashboard(); //go to login form
dash.Show(); //show login form
this.Hide(); //hide app form
}
public ActionResult Approve(int id)
{
dashboard data = context.dashboards.Find(id);
data.BookingStatus = "Approved";
int ID = (int)data.EmpID;
var employee = context.employees.FirstOrDefault(x => x.EmpID == ID);
var Email = employee.Email;
MailMessage mailcontext = new MailMessage("*****@*****.**", Email);
mailcontext.Subject = "Booking Status";
mailcontext.Body = "Your Booking has benn confirmed";
mailcontext.IsBodyHtml = false;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.EnableSsl = true;
NetworkCredential nc = new NetworkCredential("*****@*****.**", "DXCGREADMIN");
smtp.UseDefaultCredentials = true;
smtp.Credentials = nc;
smtp.Send(mailcontext);
context.SaveChanges();
return(RedirectToAction("Dashboard"));
}
public void DailyFeesUpdate()
{
dashboard db = new dashboard();
dashboardMain dmain = new dashboardMain();
Task t1, t2, t3, t4;
t1 = Task.Factory.StartNew(() => db.bank_received = dmain.bank_received());
t2 = Task.Factory.StartNew(() => db.cash_received = dmain.cash_received());
t3 = Task.Factory.StartNew(() => db.total_bank_received = dmain.total_bank_received());
t4 = Task.Factory.StartNew(() => db.total_cash_received = dmain.total_cash_received());
var tasklist = new List <Task> {
t1, t2, t3, t4
};
Task.WaitAll(tasklist.ToArray());
db.fees_received = db.bank_received + db.cash_received;
db.total_cash_bank_received = db.total_bank_received + db.total_cash_received;
decimal[] fees = { db.fees_received, db.cash_received, db.bank_received, db.total_cash_bank_received, db.total_cash_received, db.total_bank_received };
var context = GlobalHost.ConnectionManager.GetHubContext <DashboardHub>();
Task.Factory.StartNew(() => context.Clients.All.DashBoadDailyFeesUpdate(fees));
DashboardClassWiseDuesChart();
}
private void bunifuThinButton21_Click(object sender, EventArgs e)
{
try
{
string con = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Database\DB.mdf;Integrated Security=True";
SqlConnection sqlConn = new SqlConnection(con);
String query = "SELECT * FROM dbo.[User] WHERE Username ='******' AND Password ='******'";
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(query, sqlConn);
DataTable data = new DataTable();
sqlDataAdapter.Fill(data);
if (data.Rows.Count == 1)
{
dashboard dash = new dashboard();
dash.Show();
this.Hide();
}
else
{
MessageBox.Show("Wrong username/ password !!");
}
}
catch (Exception ex)
{
MessageBox.Show("Please Connect To The database");
}
}
public IActionResult Continue()
{
if (!_db.Person.Any(c => c.UserId == User.Claims.First().Value))
{
try
{
return(RedirectToAction("CompleteRegistration"));
}
catch (Exception)
{
throw;
}
}
ViewData.Add("Title", "dashbaord");
dashboard d = new dashboard(_db);
d.init(User.Claims.First().Value);
if (d.CurrentUser == null)
{
return(RedirectToAction("CompleteRegistration"));
}
return(View(d));
}
private void button1_Click(object sender, EventArgs e)
{
this.Hide();
dashboard dashhhh = new dashboard();
dashhhh.Show();
}
private void Button2_Click(object sender, EventArgs e)
{
if (dash.IsDisposed == true)
{
dash = new dashboard();
}
dash.Show();
}
private void button1_Click(object sender, EventArgs e)
{
dashboard dash = new dashboard(); //next to app form
dash = new dashboard();
dash.Show(); //show app form
this.Hide(); //login form hide
}
public ActionResult RemoveBooking(int id)
{
dashboard data = context.dashboards.Find(id);
context.dashboards.Remove(data);
context.SaveChanges();
return(RedirectToAction("ServicesBooked"));
}
private void button1_Click(object sender, EventArgs e)
{
//Application.Exit(); // this is not good for this
dashboard dash = new dashboard(); //next to app form
dash = new dashboard();
dash.Show(); //show app form
this.Hide(); //login form hide
}
public ActionResult In()
{
var myrole = new Class1();
var userID = User.Identity.GetUserId();
ViewBag.currentrole = myrole.a(userID);
var users = from u in context.Users
from ur in u.Roles
join r in context.Roles on ur.RoleId equals r.Id
select new
{
UserId = u.Id,
Name = u.UserName,
Email = u.Email,
Role = r.Name
};
int counterAdmin = 0, counterUser = 0, counterPending = 0, counterBanned = 0;
foreach (var item in users)
{
if (item.Role == "Admin")
{
counterAdmin = counterAdmin + 1;
}
else if (item.Role == "User")
{
counterUser = counterUser + 1;
}
else if (item.Role == "Pending")
{
counterPending = counterPending + 1;
}
else if (item.Role == "Banned")
{
counterBanned = counterBanned + 1;
}
}
ViewBag.counterAdmin = counterAdmin;
ViewBag.counterUser = counterUser;
ViewBag.counterPending = counterPending;
ViewBag.counterBanned = counterBanned;
//dashboard mod1 = new dashboard();
//var ann = from m in db.announcements select m;
//ann = ann.OrderByDescending(ca => ca.date).Take(4);
//var pcprob= from m in db.PcProblems select m;
//pcprob = pcprob.OrderByDescending(ca => ca.date).Take(4);
var cm = new dashboard
{
announcements = db.announcements.OrderByDescending(ca => ca.date).Take(4).ToList(),
PcProblems = db.PcProblems.OrderByDescending(ca => ca.date).Take(4).ToList()
};
//mod1.announcements = ann.ToList();
//mod1.PcProblems = pcprob.ToList();
return(View(cm));
}
private void loginloginlogin()
{
try
{
if (bunifuMaterialTextbox1.Text == string.Empty && bunifuMaterialTextbox2.Text == string.Empty)
{
bunifuCustomLabel8.Visible = true;
bunifuCustomLabel6.Visible = true;
bunifuCustomLabel7.Visible = true;
timer1.Start();
}
else
{
//bunifuCircleProgressbar1.Visible = true;
string stringcon = System.Configuration.ConfigurationManager.ConnectionStrings["residenceBDcon"].ConnectionString;
SqlConnection con = new SqlConnection(stringcon);
SqlCommand cmd = new SqlCommand("select * from echipa where email=@LEMAIL and parola=@LPAROLA", con);
cmd.Parameters.AddWithValue("@LEMAIL", bunifuMaterialTextbox1.Text);
cmd.Parameters.AddWithValue("@LPAROLA", bunifuMaterialTextbox2.Text);
Email = bunifuMaterialTextbox1.Text;
SqlDataAdapter dt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
dt.Fill(ds);
int count = ds.Tables[0].Rows.Count;
if (count == 1)
{
bunifuCircleProgressbar1.Visible = true;
dashboard dash = new dashboard(); //next to app form
dash = new dashboard();
dash.Show(); //show app form
this.Hide(); //login form hide
//bunifuCircleProgressbar1.Visible = false;
}
else
{
bunifuCustomLabel8.Visible = true;
bunifuCustomLabel6.Visible = true;
bunifuCustomLabel7.Visible = true;
bunifuCircleProgressbar1.Visible = false;
timer1.Start();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\muhammad\Documents\data.mdf;Integrated Security=True;Connect Timeout=30");
SqlDataAdapter sda = new SqlDataAdapter("select count(*) from logic where username= "******"and password" + textBox1.Text + "'", con);
this.Hide();
dashboard ss = new dashboard();
ss.Show();
}
public App()
{
InitializeComponent();
if (App.Current.Properties.ContainsKey("username") && App.Current.Properties.ContainsKey("password"))
{
MainPage = new dashboard(); //dashboard
}
else
{
MainPage = new login(); //login
}
}
private void button2_Click(object sender, EventArgs e)
{
DBConnect db = new DBConnect();
db.insertBatch(eventname.Text);
MessageBox.Show("EVENT HAS BEEN ADDED SUCCESSFULLY");
this.Hide();
barscanner b = new barscanner();
b.BringToFront();
dashboard d = new dashboard();
d.Reset();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
if (ConfigurationManager.AppSettings["token"] != null) // Si tenemos guardado un token de inicio de sesion
{
ConfigurationHandler Config = new ConfigurationHandler();
String host = Config.getSetting("host", "Connection");
String port = Config.getSetting("port", "Connection");
String database = Config.getSetting("database", "Connection");
String user = Config.getSetting("username", "Connection");
String pass = Config.getSetting("password", "Connection");
String ruta = "Data Source=" + host + ";port=" + port + ";Database=" + database + ";Uid=" + user + ";Password="******"SELECT token from users where username= ?username;";
MySqlCommand cmd;
MySqlConnection con = null;
try {
con = new MySqlConnection(ruta);
con.Open();
cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("?username", ConfigurationManager.AppSettings["username"]);
System.Data.IDataReader dr;
dr = cmd.ExecuteReader();
if (dr.Read())
{
String token = dr.GetString(0);
if (token == ConfigurationManager.AppSettings["token"])
{
dashboard form = new dashboard();
this.Hide();
form.ShowDialog();
}
else
{
var configFile = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
var settings = configFile.AppSettings.Settings;
settings.Remove("token");
configFile.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection(configFile.AppSettings.SectionInformation.Name);
}
}
} catch (Exception exc) {
MessageBox.Show("Ups! Ha habido un error de conexión con la base de datos:\n" + exc.Message.ToString(), "Error de conexión", MessageBoxButton.OK, MessageBoxImage.Exclamation);
} finally {
if (con != null)
{
con.Close();
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
DBConnect db = new DBConnect();
db.insertColor(color.Text);
MessageBox.Show("COLOUR HAS BEEN ADDED SUCCESSFULLY");
this.Hide();
barscanner b = new barscanner();
b.BringToFront();
dashboard d = new dashboard();
d.Reset();
}
public IActionResult success()
{
if (UserSession == null)
{
return(RedirectToAction("Index"));
}
User user = dbContext.Users.FirstOrDefault(q => q.UserId == UserSession);
List <Wedding> allW = dbContext.Weddings.Include(w => w.CreatedRsvp).Include(q => q.Creator).ToList();
dashboard model = new dashboard();
model.userLogged = user;
model.weddingList = allW;
return(View(model));
}
public void refreshCB()
{
dashboard db = new dashboard();
db.access_prisoner.IsChecked = false;
db.access_visitor.IsChecked = false;
db.access_cell.IsChecked = false;
db.access_case.IsChecked = false;
db.access_escort.IsChecked = false;
db.access_prisonerreport.IsChecked = false;
db.access_visitorreport.IsChecked = false;
db.access_cellreport.IsChecked = false;
db.access_casereport.IsChecked = false;
db.access_jailofficerreport.IsChecked = false;
}
public ActionResult CleaningServices(dashboard data, FormCollection form)
{
ViewBag.Rooms = Rooms();
ViewBag.ServiceType = ServiceType();
dashboard dbdata = new dashboard();
dbdata.EmpID = ID;
dbdata.RoomName = form["RoomName"].ToString();
dbdata.BookingType = form["BookingType"].ToString();
dbdata.BookingStatus = "Pending";
dbdata.DateTo = data.DateFrom;
dbdata.DateFrom = data.DateFrom;
context.dashboards.Add(dbdata);
context.SaveChanges();
return(RedirectToAction("EmployeeDashboard"));
}
public void DashboardClassWiseDuesChart()
{
dashboard db = new dashboard();
dashboardMain dmain = new dashboardMain();
Task t1, t2, t3;
// Dashboard dues chart live update
t1 = Task.Factory.StartNew(() => db.name = dmain.school_class());
t2 = Task.Factory.StartNew(() => db.dues = dmain.dues());
t3 = Task.Factory.StartNew(() => db.recovered = dmain.recovered());
var context = GlobalHost.ConnectionManager.GetHubContext <DashboardHub>();
Task.Factory.StartNew(() => context.Clients.All.DashboardClassWiseDuesChart(db.name, db.dues, db.recovered));
}
public void DashboardSchoolStrength()
{
dashboard db = new dashboard();
dashboardMain dmain = new dashboardMain();
Task t1, t2, t3, t4, t5, t6, t7, t8;
t1 = Task.Factory.StartNew(() => db.school_strength = dmain.school_strength());
t2 = Task.Factory.StartNew(() => db.male_std = dmain.school_Male_std());
t3 = Task.Factory.StartNew(() => db.female_std = dmain.school_Female_std());
t4 = Task.Factory.StartNew(() => db.newAdmission = dmain.new_admission());
t5 = Task.Factory.StartNew(() => db.newAdmission_male = dmain.new_admission_male_std());
t6 = Task.Factory.StartNew(() => db.newAdmission_female = dmain.new_admission_female_std());
t7 = Task.Factory.StartNew(() => db.transport_male_std = dmain.transport_Male_std());
t8 = Task.Factory.StartNew(() => db.transport_female_std = dmain.transport_Female_std());
var tasklist = new List <Task> {
t1, t2, t3, t4, t5, t6, t7, t8
};
Task.WaitAll(tasklist.ToArray());
db.transport_std = db.transport_male_std + db.transport_female_std;
var context = GlobalHost.ConnectionManager.GetHubContext <DashboardHub>();
int[] strength = { db.school_strength, db.male_std, db.female_std, db.newAdmission, db.newAdmission_male, db.newAdmission_female, db.transport_std, db.transport_male_std, db.transport_female_std };
Task.Factory.StartNew(() => context.Clients.All.DashboardSchoolStrength(strength));
}
private void button1_Click(object sender, EventArgs e)
{
DBConnect db = new DBConnect();
string eventname = this.eventid.Text.ToString();
string colorname = this.colorid.Text.ToString();
string no = this.nooftickets.Text;
int n = db.CountTickets();
for (int i = 0; i < Convert.ToInt32(no); i++)
{
db.InsertTickets(eventname, "101" + n + i, colorname);
}
MessageBox.Show("TICKETS HAVE BEEN SAVED SUCCESSFULLY");
this.Hide();
barscanner b = new barscanner();
b.BringToFront();
dashboard d = new dashboard();
d.Reset();
d.Notifier("TICKETS HAVE BEEN SAVED SUCCESSFULLY");
}
public void SMSCreditLeft()
{
dashboard db = new dashboard();
dashboardMain dmain = new dashboardMain();
Task t1, t2;
t1 = Task.Factory.StartNew(() => db.sms_credit_left = dmain.SMSCredit());
t2 = Task.Factory.StartNew(() => db.today_consumption = dmain.today_consumption().ToString());
var tasklist = new List <Task> {
t1, t2
};
Task.WaitAll(tasklist.ToArray());
var context = GlobalHost.ConnectionManager.GetHubContext <DashboardHub>();
string[] sms = { db.sms_credit_left, db.today_consumption };
Task.Factory.StartNew(() => context.Clients.All.DashBoadSMSCreditLeft(sms));
}
// GET: Home
//[Authorize(Roles = "superadmin,admin,principal,faculty")]
public ActionResult Dashboard()
{
string wedget = Request.Cookies["wedget"].Value.ToString();
var list = wedget.Split(',');
dashboard db = new dashboard();
dashboardMain dmain = new dashboardMain();
//Task t1, t2 ,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16,t17,t18,t19,t20,t21,t22,t23,t24;
Task t1 = Task.FromResult <object>(null);
Task t2 = Task.FromResult <object>(null);
Task t3 = Task.FromResult <object>(null);
Task t4 = Task.FromResult <object>(null);
Task t5 = Task.FromResult <object>(null);
Task t6 = Task.FromResult <object>(null);
Task t7 = Task.FromResult <object>(null);
Task t8 = Task.FromResult <object>(null);
Task t9 = Task.FromResult <object>(null);
Task t10 = Task.FromResult <object>(null);
Task t11 = Task.FromResult <object>(null);
Task t12 = Task.FromResult <object>(null);
Task t13 = Task.FromResult <object>(null);
Task t14 = Task.FromResult <object>(null);
Task t15 = Task.FromResult <object>(null);
Task t16 = Task.FromResult <object>(null);
Task t17 = Task.FromResult <object>(null);
Task t18 = Task.FromResult <object>(null);
Task t19 = Task.FromResult <object>(null);
Task t20 = Task.FromResult <object>(null);
Task t21 = Task.FromResult <object>(null);
Task t22 = Task.FromResult <object>(null);
Task t23 = Task.FromResult <object>(null);
Task t24 = Task.FromResult <object>(null);
Task t25 = Task.FromResult <object>(null);
Task t26 = Task.FromResult <object>(null);
Task t27 = Task.FromResult <object>(null);
Task t28 = Task.FromResult <object>(null);
Task t29 = Task.FromResult <object>(null);
if (list.Contains("fees_received") || User.IsInRole("superadmin"))
{
t1 = Task.Factory.StartNew(() => db.bank_received = dmain.bank_received());
t2 = Task.Factory.StartNew(() => db.cash_received = dmain.cash_received());
}
if (list.Contains("school_strength") || User.IsInRole("superadmin"))
{
t3 = Task.Factory.StartNew(() => db.school_strength = dmain.school_strength());
t4 = Task.Factory.StartNew(() => db.male_std = dmain.school_Male_std());
t5 = Task.Factory.StartNew(() => db.female_std = dmain.school_Female_std());
}
if (list.Contains("transport_std") || User.IsInRole("superadmin"))
{
t5 = Task.Factory.StartNew(() => db.transport_male_std = dmain.transport_Male_std());
t6 = Task.Factory.StartNew(() => db.transport_female_std = dmain.transport_Female_std());
}
if (list.Contains("newAdmission") || User.IsInRole("superadmin"))
{
t7 = Task.Factory.StartNew(() => db.newAdmission = dmain.new_admission());
t8 = Task.Factory.StartNew(() => db.newAdmission_male = dmain.new_admission_male_std());
t9 = Task.Factory.StartNew(() => db.newAdmission_female = dmain.new_admission_female_std());
}
if (list.Contains("class_wise_dues_chart") || User.IsInRole("superadmin"))
{
t10 = Task.Factory.StartNew(() => db.name = dmain.school_class());
}
else
{
db.name = new string[] { "" };
}
if (list.Contains("class_wise_dues_chart") || list.Contains("total_recovery") || User.IsInRole("superadmin"))
{
t11 = Task.Factory.StartNew(() => db.dues = dmain.dues());
t12 = Task.Factory.StartNew(() => db.recovered = dmain.recovered());
}
else
{
db.dues = new decimal[] { 0 };
db.recovered = new decimal[] { 0 };
db.total_dues = db.dues.Sum();
db.total_recovered = db.recovered.Sum();
}
if (list.Contains("sms_credit_left") || User.IsInRole("superadmin"))
{
t13 = Task.Factory.StartNew(() => db.sms_credit_left = dmain.SMSCredit());
t14 = Task.Factory.StartNew(() => db.today_consumption = dmain.today_consumption().ToString());
}
if (list.Contains("class_wise_attendance_chart") || list.Contains("attendance_summary") || User.IsInRole("superadmin"))
{
if (User.IsInRole("superadmin") || User.IsInRole("principal"))
{
t15 = Task.Factory.StartNew(() => db.name_attendance = dmain.school_class_for_attendance(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true));
t16 = Task.Factory.StartNew(() => db.present = dmain.present(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true));
t17 = Task.Factory.StartNew(() => db.absent = dmain.absent(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true));
}
else
{
t15 = Task.Factory.StartNew(() => db.name_attendance = dmain.school_class_for_attendance(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false));
t16 = Task.Factory.StartNew(() => db.present = dmain.present(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false));
t17 = Task.Factory.StartNew(() => db.absent = dmain.absent(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false));
}
}
else
{
db.name_attendance = new string[] { "" };
db.present = new int[] { 0 };
db.absent = new int[] { 0 };
}
if (list.Contains("date_wise_attendance_chart") || User.IsInRole("superadmin"))
{
if (User.IsInRole("superadmin") || User.IsInRole("principal"))
{
t18 = Task.Factory.StartNew(() => db.date_list = dmain.date_list_for_attendance(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true));
t19 = Task.Factory.StartNew(() => db.thirty_day_present = dmain.thirty_day_present(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true));
t20 = Task.Factory.StartNew(() => db.thirty_day_absent = dmain.thirty_day_absent(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true));
}
else
{
t18 = Task.Factory.StartNew(() => db.date_list = dmain.date_list_for_attendance(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false));
t19 = Task.Factory.StartNew(() => db.thirty_day_present = dmain.thirty_day_present(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false));
t20 = Task.Factory.StartNew(() => db.thirty_day_absent = dmain.thirty_day_absent(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false));
}
}
else
{
db.date_list = new string[] { "" };
db.thirty_day_present = new int[] { 0 };
db.thirty_day_absent = new int[] { 0 };
}
if (list.Contains("finalize_list") || User.IsInRole("superadmin"))
{
if (User.IsInRole("superadmin") || User.IsInRole("principal"))
{
t21 = Task.Factory.StartNew(() => db.finalize_list = dmain.finalizer_list(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true));
}
else
{
t21 = Task.Factory.StartNew(() => db.finalize_list = dmain.finalizer_list(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false));
}
}
if (list.Contains("list_att_left_class") || User.IsInRole("superadmin"))
{
if (User.IsInRole("superadmin") || User.IsInRole("principal"))
{
t22 = Task.Factory.StartNew(() => db.list_att_left_class = dmain.att_left_classess(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true));
}
else
{
t22 = Task.Factory.StartNew(() => db.list_att_left_class = dmain.att_left_classess(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false));
}
}
if (list.Contains("total_cash_bank_received") || User.IsInRole("superadmin"))
{
t23 = Task.Factory.StartNew(() => db.total_bank_received = dmain.total_bank_received());
t24 = Task.Factory.StartNew(() => db.total_cash_received = dmain.total_cash_received());
}
if (list.Contains("std_birthday_list") || User.IsInRole("superadmin"))
{
if (User.IsInRole("superadmin") || User.IsInRole("principal"))
{
t25 = Task.Factory.StartNew(() => db.std_birthday_list = dmain.std_birthday_list(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), true));
}
else
{
t26 = Task.Factory.StartNew(() => db.std_birthday_list = dmain.std_birthday_list(int.Parse(Request.Cookies["loginUserId"].Value.ToString()), false));
}
}
if (list.Contains("staff_birthday_list") || User.IsInRole("superadmin"))
{
t27 = Task.Factory.StartNew(() => db.staff_birthday_list = dmain.staff_birthday());
}
if (list.Contains("session_wise_dues_chart") || User.IsInRole("superadmin"))
{
t28 = Task.Factory.StartNew(() => db.session = dmain.session());
t29 = Task.Factory.StartNew(() => db.session_dues = dmain.session_dues());
}
else
{
db.session = new string[] { "" };
db.session_dues = new decimal[] { 0 };
}
var tasklist = new List <Task> {
t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12, t13, t14, t15, t16, t17, t18, t19, t20, t21, t22, t23, t24, t25, t26, t27, t28, t29
};
Task.WaitAll(tasklist.ToArray());
if (list.Contains("fees_received") || User.IsInRole("superadmin"))
{
db.fees_received = db.bank_received + db.cash_received;
}
if (list.Contains("transport_std") || User.IsInRole("superadmin"))
{
db.transport_std = db.transport_male_std + db.transport_female_std;
}
if (list.Contains("class_wise_dues_chart") || list.Contains("total_recovery") || User.IsInRole("superadmin"))
{
db.total_dues = db.dues.Sum();
db.total_recovered = db.recovered.Sum();
}
else
{
db.total_dues = db.dues.Sum();
db.total_recovered = db.recovered.Sum();
}
if (list.Contains("class_wise_attendance_chart") || list.Contains("attendance_summary") || User.IsInRole("superadmin"))
{
db.daily_absent = db.absent.Sum();
db.daily_present = db.present.Sum();
}
else
{
db.name_attendance = new string[] { "" };
db.present = new int[] { 0 };
db.absent = new int[] { 0 };
}
if (list.Contains("finalize_list") || User.IsInRole("superadmin"))
{
foreach (var item in db.finalize_list)
{
item.absent = dmain.absent_finalizer(item.session, item.att_date.ToString("yyyy-MM-dd"), item.section_id);
item.present = dmain.present_finalizer(item.session, item.att_date.ToString("yyyy-MM-dd"), item.section_id);
}
}
if (list.Contains("list_att_left_class") || User.IsInRole("superadmin"))
{
foreach (var item in db.list_att_left_class)
{
item.class_teacher = dmain.class_teacher(item.class_id, item.section_id);
item.finalizer = dmain.finalizer(item.class_id, item.section_id);
}
}
if (list.Contains("total_cash_bank_received") || User.IsInRole("superadmin"))
{
db.total_cash_bank_received = db.total_bank_received + db.total_cash_received;
}
return(View("Dashboard", db));
}
private void editbutton_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(stringcon);
MemoryStream ms = new MemoryStream();
pictureBox2.Image.Save(ms, pictureBox2.Image.RawFormat);
byte[] a = ms.GetBuffer();
ms.Close();
MemoryStream ms1 = new MemoryStream();
pictureBox3.Image.Save(ms1, pictureBox3.Image.RawFormat);
byte[] a2 = ms1.GetBuffer();
ms1.Close();
MemoryStream ms2 = new MemoryStream();
pictureBox4.Image.Save(ms2, pictureBox4.Image.RawFormat);
byte[] a3 = ms2.GetBuffer();
ms2.Close();
cmd.Parameters.Clear();
cmd.Connection = con;
cmd.CommandText = "Insert into proprietati(numeproiect,numeproprietate,pretlista,moneda,data_ora,suprafatatotala,clasaenergetica,tipproprietate,numarbai,suprafataconstruita,suprafatautila,suprafatabalcon ,numarapartament,etaj,finisaje,compartimente,parcare,utilitati,descriere,img1,img2,img3,numeagent,id_proiecte) values(@numeproiect,@numeproprietate,@pretlista,@moneda,@data_ora,@suprafatatotala,@clasaenergetica,@tipproprietate,@numarbai,@suprafataconstruita,@suprafatautila,@suprafatabalcon,@numarapartament,@etaj,@finisaje,@compartimente,@parcare,@utilitati,@descriere, @img1, @img2, @img3,(select CONCAT(nume,' ',prenume) from echipa where email=@EMAIL),(select proiecte.id_proiecte from proiecte inner join proprietati on proiecte.numeproiect = proprietati.numeproiect where proprietati.numeproiect = @b group by proiecte.id_proiecte))";
cmd.Parameters.AddWithValue("@numeproiect", bunifuDropdown2.selectedValue);
cmd.Parameters.AddWithValue("@numeproprietate", nameofproject.Text);
cmd.Parameters.AddWithValue("@pretlista", bunifuMaterialTextbox1.Text);
cmd.Parameters.AddWithValue("@suprafatatotala", bunifuMaterialTextbox2.Text);
cmd.Parameters.AddWithValue("@clasaenergetica", bunifuMaterialTextbox3.Text);
cmd.Parameters.AddWithValue("@tipproprietate", bunifuDropdown1.selectedValue);
cmd.Parameters.AddWithValue("@numarbai", bunifuDropdown3.selectedValue);
cmd.Parameters.AddWithValue("@suprafataconstruita", bunifuMaterialTextbox6.Text);
cmd.Parameters.AddWithValue("@suprafatautila", bunifuMaterialTextbox5.Text);
cmd.Parameters.AddWithValue("@suprafatabalcon", bunifuMaterialTextbox4.Text);
cmd.Parameters.AddWithValue("@etaj", bunifuDropdown5.selectedValue);
cmd.Parameters.AddWithValue("@finisaje", bunifuDropdown4.selectedValue);
cmd.Parameters.AddWithValue("@compartimente", bunifuDropdown6.selectedValue);
cmd.Parameters.AddWithValue("@parcare", bunifuDropdown7.selectedValue);
cmd.Parameters.AddWithValue("@utilitati", bunifuDropdown8.selectedValue);
cmd.Parameters.AddWithValue("@descriere", richTextBox2.Text);
cmd.Parameters.AddWithValue("@data_ora", DateTime.Now.ToString("yyyy-MM-dd HH: mm:ss"));
cmd.Parameters.AddWithValue("@numarapartament", bunifuMaterialTextbox7.Text);
cmd.Parameters.AddWithValue("@EMAIL", loginform.Email);
cmd.Parameters.AddWithValue("@b", bunifuDropdown2.selectedValue);
cmd.Parameters.AddWithValue("@moneda", bunifuDropdown9.selectedValue);
cmd.Parameters.AddWithValue("@img1", a);
cmd.Parameters.AddWithValue("@img2", a2);
cmd.Parameters.AddWithValue("@img3", a3);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
//Application.Exit(); // this is not good for this
dashboard dash = new dashboard(); //next to app form
dash = new dashboard();
dash.Show(); //show app form
this.Hide(); //login form hide
dash.bunifuCustomLabel6.Visible = true;
dash.popupsuccesdatainsert.Start();
}
public ActionResult TrainingRooms(dashboard data, FormCollection form)
{
ViewBag.Rooms = Rooms();
data.EmpID = ID;
data.BookingStatus = "Pending";
data.BookingType = "Training Room";
int daysdifference = ((TimeSpan)(data.DateTo - data.DateFrom)).Days;
if (data.DateTo >= data.DateFrom && daysdifference <= 93)
{
bool svalid = context.dashboards.Any(x => x.RoomName == data.RoomName);
if (svalid)
{
if (data.DateFrom == data.DateTo)
{
bool evalid = context.dashboards.Any(x => x.DateFrom == data.DateFrom);
if (!evalid)
{
context.dashboards.Add(data);
context.SaveChanges();
return(RedirectToAction("EmployeeDashboard"));
}
}
bool zcalid = context.dashboards.Any(x => x.DateFrom == data.DateFrom || x.DateFrom == data.DateTo || x.DateTo == data.DateFrom || x.DateTo == data.DateTo);
if (zcalid)
{
ModelState.AddModelError("RoomName", " training room " + data.RoomName + " has already been booked on " + data.DateFrom + " or " + data.DateTo);
}
else
{
bool fvalid = context.dashboards.Any(x => x.DateFrom <data.DateFrom && x.DateTo> data.DateFrom || x.DateFrom <data.DateTo && x.DateTo> data.DateTo);
bool dvalid = context.dashboards.Any(x => x.DateFrom > data.DateFrom && x.DateFrom <data.DateTo && x.DateTo> data.DateFrom && x.DateTo < data.DateTo);
if (dvalid)
{
ModelState.AddModelError("RoomName", "Training Room " + data.RoomName + "already been booked in between the given dates");
return(View());
}
else if (fvalid)
{
ModelState.AddModelError("RoomName", "Training Room " + data.RoomName + "already been booked in between the given dates");
}
else
{
context.dashboards.Add(data);
context.SaveChanges();
return(RedirectToAction("EmployeeDashboard"));
}
}
}
else
{
context.dashboards.Add(data);
context.SaveChanges();
return(RedirectToAction("EmployeeDashboard"));
}
}
else
{
ModelState.AddModelError("RoomName", "*Invalid Dates OR Booking Period Must Be Less Than 3 Months");
}
return(View());
}
public ActionResult Index()
{
ViewBag.Message = "Welcome to Safety Patrol Management System!";
ViewBag.pagename = "Dashboard";
if (HttpContext.Session.Count > 0)
{
var islogin = HttpContext.Session["islogin"].ToString();
if (islogin == "1")
{
ViewBag.currentuser = HttpContext.Session["fname"];
ViewBag.Message = "";
if (HttpContext.Session["userlevel"].ToString() == "0")
{
return(RedirectToAction("Index", "Findings"));
}
else
{
int y;
int month;
string smonth;
if (HttpContext.Request["year"] != null && HttpContext.Request["year"] != "")
{
y = int.Parse(HttpContext.Request["year"]);
}
else
{
y = 0;
}
if (HttpContext.Request["month"] != null && HttpContext.Request["month"] != "")
{
smonth = HttpContext.Request["month"].ToString();
if (CheckDate(smonth))
{
month = Convert.ToDateTime(HttpContext.Request["month"].ToString() + "01, 1900").Month;
}
else
{
ViewBag.Message = "Invalid Month Selection!";
month = 0;
smonth = "";
}
}
else
{
month = 0;
smonth = "";
}
if (y == 0 && month > 0)
{
ViewBag.Message = "Please Select Year!";
}
List <string> lDept = db.dept.Select(s => s.department).Distinct().ToList();
List <BarChartValue> bc = new List <BarChartValue>();
List <catcount> c3 = new List <catcount>();
dashboard d = new dashboard();
if (y == 0)
{
ViewBag.syear = ""; //DateTime.Today.Year;
ViewBag.smonth = "";
foreach (string l in lDept)
{
var temp = db.dataFindings.Where(s => s.department == l).Where(s => s.ignore == 0).ToList();
var c = db.dataFindings.Where(s => s.status == 3).Where(s => s.department == l).Where(s => s.ignore == 0).ToList();
var r = db.dataFindings.Where(s => s.status == 2).Where(s => s.department == l).Where(s => s.ignore == 0).ToList();
var p = db.dataFindings.Where(s => s.status == 1).Where(s => s.department == l).Where(s => s.ignore == 0).ToList();
BarChartValue x = new BarChartValue();
x.ChartValue = temp.Count;
x.completed = c.Count;
x.review = r.Count;
x.pending = p.Count;
x.DeptName = l;
bc.Add(x);
}
}
else
{
ViewBag.syear = y;
ViewBag.smonth = smonth;
if (month > 0)
{
foreach (string l in lDept)
{
var temp = db.dataFindings.Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.recdate.Month == month).Where(s => s.ignore == 0).ToList();
var c = db.dataFindings.Where(s => s.status == 3).Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.recdate.Month == month).Where(s => s.ignore == 0).ToList();
var r = db.dataFindings.Where(s => s.status == 2).Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.recdate.Month == month).Where(s => s.ignore == 0).ToList();
var p = db.dataFindings.Where(s => s.status == 1).Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.recdate.Month == month).Where(s => s.ignore == 0).ToList();
BarChartValue x = new BarChartValue();
x.ChartValue = temp.Count;
x.completed = c.Count;
x.review = r.Count;
x.pending = p.Count;
x.DeptName = l;
bc.Add(x);
}
}
else
{
foreach (string l in lDept)
{
var temp = db.dataFindings.Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.ignore == 0).ToList();
var c = db.dataFindings.Where(s => s.status == 3).Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.ignore == 0).ToList();
var r = db.dataFindings.Where(s => s.status == 2).Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.ignore == 0).ToList();
var p = db.dataFindings.Where(s => s.status == 1).Where(s => s.department == l).Where(s => s.recdate.Year == y).Where(s => s.ignore == 0).ToList();
BarChartValue x = new BarChartValue();
x.ChartValue = temp.Count;
x.completed = c.Count;
x.review = r.Count;
x.pending = p.Count;
x.DeptName = l;
bc.Add(x);
}
}
}
List <tbl_classification> categories = db.classification.ToList();
foreach (var cat in categories)
{
//d.cc.count.Add(db.dataFindings.Where(e => e.classification == cat.classification).Count());
int cnt = db.dataFindings.Where(e => e.classification == cat.classification).Count();
string c1 = cat.classification.ToString();
catcount cat1 = new catcount();
cat1.categories = c1;
cat1.count1 = cnt;
c3.Add(cat1);
}
d.bcv = bc;
d.bcc = c3;
ViewBag.noOfFindings = db.dataFindings.Where(m => m.ignore == 0).Count();
ViewBag.F_pending = db.dataFindings.Where(m => m.status == 1).Where(m => m.ignore == 0).Count();
ViewBag.F_review = db.dataFindings.Where(m => m.status == 2).Where(m => m.ignore == 0).Count();
ViewBag.F_completed = db.dataFindings.Where(m => m.status == 3).Where(m => m.ignore == 0).Count();
return(View(d));
}
}
}
return(RedirectToAction("Index", "Login"));
}
public dashboard Admin()
{
dashboard d = new dashboard();
//Purchase and Sale
d.LastMonthSales = context.Order.OrderBy(x => x.Date).Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Products != null? x.Products.Select(t => t.price).Sum(): 0);
d.LastMonthPurchasing = context.Purchasings.OrderBy(x => x.Date).Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Amount);
d.TotalSalesCount = context.Order.Count();
d.TotalPurchasingCount = context.Purchasings.Count();
d.TotalSales = context.Order.Sum(x => x.Products.Select(p => p.price).Sum());
d.TotalPurchasing = context.Purchasings.Sum(x => x.Amount);
d.MonthlyProfit = d.LastMonthSales - d.LastMonthPurchasing;
d.TotalProfit = d.TotalSales - d.TotalPurchasing;
#region Recent Orders and Purchase
//Recent Orders
var result = (from v in context.Order
join
c in context.Customer
on v.cus_id equals c.cus_id
join
s in context.Stores
on v.store_id equals s.store_id
select new OrderViewModel()
{
order_id = v.order_id,
Date = v.Date,
StoreName = s.StoreName + s.Ref_No,
cus_id = v.cus_id,
cus_name = c.cus_name,
orderStatus = v.status,
TakenBy = v.TakenBy,
CustRef = c.CustRef,
Products = (from p in context.Products
where p.order_id == v.order_id
select new Products()
{
id = p.id,
modelId = p.modelId,
model_name = p.BrandModel.model_name,
Phoneid = p.BrandModel.PhoneId,
com_Name = p.BrandModel.model.Com_name,
price = p.price,
Quantity = p.Quantity
}).ToList()
}).OrderBy(x => x.Date).Take(10).ToList();
d.Orders = result;
//Recent Purchase
var Purchase = (from p in context.Purchasings
join
b in context.BrandModel
on p.modelId equals b.modelId
join
v in context.Vendor
on p.vendor_id equals v.ven_id
join
c in context.CompanyModel
on b.PhoneId equals c.Phoneid
join
s in context.Stores
on p.store_id equals s.store_id
select new PurchasingViewModel()
{
purchase_id = p.purchase_id,
Date = p.Date,
Quantity = p.Quantity,
Amount = p.Amount,
modelId = p.modelId,
modelName = b.model_name,
Com_name = c.Com_name,
vendor_id = p.vendor_id,
VendorName = v.ven_name,
store_id = s.store_id,
StoreName = s.StoreName + '#' + s.Ref_No,
takenBy = p.user.FullName,
}).OrderBy(x => x.Date).Take(10).ToList();
d.Purchasing = Purchase;
#endregion
//Graphs
var DailyGraphSale = context.Order.Select(x => new { x.Date, x.Products }).Where(x => (x.Date - DateTime.Now).TotalDays <= 30).ToList()
.GroupBy(x => x.Date.ToString("yyyy/MM/dd"))
.Select(pr => new Graph()
{
Day = pr.Key.ToString(),
Amount = pr.Select(x => x.Products.Select(t => t.price).Sum()).Sum()
});
// var json = JsonConvert.SerializeObject(DailyGraphSale);
//d.Sales = json;
d.Sales = DailyGraphSale.ToList();
var DailyGraphPurchasing = context.Purchasings.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).ToList()
.GroupBy(x => x.Date.ToString("yyyy/MM/dd"))
.Select(pr => new Graph()
{
Day = pr.Key.ToString(),
Amount = pr.Sum(x => x.Amount)
});
//d.Purchasings= JsonConvert.SerializeObject(DailyGraphPurchasing);
d.Purchasings = DailyGraphPurchasing.ToList();
//Brands
d.CompaniesData = context.BrandModel
.GroupBy(x => x.PhoneId)
.Select(pr => new GroupByCompany()
{
PhoneID = pr.Key,
ComapanyName = pr.Select(x => new { x.PhoneId, x.model.Com_name }).FirstOrDefault(r => r.PhoneId == pr.Key).Com_name,
BrandsTotal = pr.Where(x => x.PhoneId == pr.Key).Count()
}).ToList();
//Users
d.User = userManager.Users.Take(5).ToList();
d.TotalUsers = userManager.Users.Count();
d.Employees = userManager.Users.Where(x => x.store_id != null && x.isactive == true).Select(x => new RegisterEmployeeViewModel()
{
id = x.Id,
Email = x.Email,
StoreName = x.Store.StoreName,
}).Take(5).ToList();
d.TotalEmployees = userManager.Users.Where(x => x.store_id != null && x.isactive == true).Count();
//Store Statistics
var stats = context.Stores.Select(s => new StoreStats()
{
StoreID = s.store_id,
StoreName = s.StoreName + s.Ref_No,
RefNo = s.Ref_No,
MonthPurchasing = s.Purchasing != null ? s.Purchasing.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Amount) : 0,
MonthPurchasingCount = s.Purchasing != null ? s.Purchasing.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Count() : 0,
AverageMonthlyPurchasing = s.Purchasing != null ? Math.Round((double)s.Purchasing.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Amount) / 30, 2) : 0,
MonthSales = s.Order != null ? s.Order.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Products.Select(t => t.price).Sum()) : 0,
MonthSalesCount = s.Purchasing != null ? s.Purchasing.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Count() : 0,
AverageMonthlySale = s.Order != null ? Math.Round(s.Order.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Products.Select(t => t.price).Sum()) / 30, 2): 0,
MonthlyProfit = (s.Purchasing != null ? s.Purchasing.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Amount) : 0) - (s.Order != null ? s.Order.Where(x => (x.Date - DateTime.Now).TotalDays <= 30).Sum(x => x.Products.Select(t => t.price).Sum()) : 0),
AnnualPurchasing = s.Purchasing != null ? s.Purchasing.Where(x => (x.Date - DateTime.Now).TotalDays <= 360).Sum(x => x.Amount) : 0,
AnnualSales = s.Order != null ? s.Order.Where(x => (x.Date - DateTime.Now).TotalDays <= 360).Sum(x => x.Products.Select(t => t.price).Sum()) : 0,
AnnualProfit = (s.Purchasing != null ? s.Purchasing.Where(x => (x.Date - DateTime.Now).TotalDays <= 360).Sum(x => x.Amount) : 0) - (s.Order != null ? s.Order.Where(x => (x.Date - DateTime.Now).TotalDays <= 360).Sum(x => x.Products.Select(t => t.price).Sum()) : 0),
CompletedOrders = s.Order != null ? s.Order.Where(x => x.status == Model.Order.Status.Completed).Count() : 0,
ProcessOrders = s.Order != null ? s.Order.Where(x => x.status == Model.Order.Status.Processing).Count() : 0,
PendingOrders = s.Order != null ? s.Order.Where(x => x.status == Model.Order.Status.Pending).Count() : 0,
TotalEmployees = s.Employees != null ? userManager.Users.Where(x => x.store_id != null && x.store_id == s.store_id).Count() : 0,
TotalBrands = s.Stock != null ? s.Stock.Where(x => x.store_id == s.store_id).Count() : 0,
}).ToList();
d.Stores = stats;
d.Stores = stats;
return(d);
}
private void editbutton_Click(object sender, EventArgs e)
{
dashboard dh = new dashboard();
SqlConnection con = new SqlConnection(stringcon);
if (pictureBox1.Image != null)
{
MemoryStream ms = new MemoryStream();
pictureBox1.Image.Save(ms, pictureBox1.Image.RawFormat);
byte[] a = ms.GetBuffer();
ms.Close();
MemoryStream ms1 = new MemoryStream();
pictureBox2.Image.Save(ms1, pictureBox2.Image.RawFormat);
byte[] a2 = ms1.GetBuffer();
ms1.Close();
MemoryStream ms2 = new MemoryStream();
pictureBox3.Image.Save(ms2, pictureBox3.Image.RawFormat);
byte[] a3 = ms2.GetBuffer();
ms2.Close();
MemoryStream ms3 = new MemoryStream();
pictureBox4.Image.Save(ms3, pictureBox4.Image.RawFormat);
byte[] a4 = ms3.GetBuffer();
ms3.Close();
cmd.Parameters.Clear();
cmd.Connection = con;
cmd.CommandText = "Insert into proiecte(numeproiect,judet,oras,strada,data_ora,numaretajeimobil,clasaenergetica,parcare,mezanin,demisol,mansarda ,descriereproiect ,img1,img2,img3,img4,id_echipa,numeagent) values(@numeproiect , @judet , @oras , @strada , @data_ora , @numaretajeimobil, @clasaenergetica, @parcare , @mezanin , @demisol , @mansarda , @descriereproiect , @img1 , @img2 , @img3 , @img4,(select id_echipa from echipa where email=@email),(select CONCAT(nume,' ',prenume) from echipa where email=@email))";
cmd.Parameters.AddWithValue("@numeproiect", nameofproject.Text);
cmd.Parameters.AddWithValue("@judet", district_text.Text);
cmd.Parameters.AddWithValue("@oras", city_text.Text);
cmd.Parameters.AddWithValue("@strada", street_text.Text);
cmd.Parameters.AddWithValue("@data_ora", DateTime.Now.ToString("yyyy-MM-dd HH: mm:ss"));
cmd.Parameters.AddWithValue("@numaretajeimobil", bunifuDropdown2.selectedValue);
cmd.Parameters.AddWithValue("@clasaenergetica", bunifuMaterialTextbox1.Text);
cmd.Parameters.AddWithValue("@parcare", bunifuMaterialTextbox1.Text);
cmd.Parameters.AddWithValue("@mezanin", mezanine);
cmd.Parameters.AddWithValue("@demisol", semibasement);
cmd.Parameters.AddWithValue("@mansarda", mansard);
cmd.Parameters.AddWithValue("@descriereproiect", richTextBox1.Text);
cmd.Parameters.AddWithValue("@img1", a);
cmd.Parameters.AddWithValue("@img2", a2);
cmd.Parameters.AddWithValue("@img3", a3);
cmd.Parameters.AddWithValue("@img4", a4);
cmd.Parameters.AddWithValue("@EMAIL", loginform.Email);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
//Application.Exit(); // this is not good for this
dashboard dash = new dashboard(); //next to app form
dash = new dashboard();
dash.Show(); //show app form
this.Hide(); //login form hide
dash.bunifuCustomLabel6.Visible = true;
dash.popupsuccesdatainsert.Start();
}
