private void Add_Click(object sender, EventArgs e)
{
correct = true;
Email_Notice_Template newTemplate = new Email_Notice_Template();
if (txtDescription.Text == "")
{
MessageBox.Show("Please enter a Template Description");
correct = false;
}
if (txtText.Text == "")
{
MessageBox.Show("Please enter Template Text");
correct = false;
}
if (correct == true)
{
newTemplate.Template_Description = txtDescription.Text;
newTemplate.Template_Text = txtText.Text;
db.Email_Notice_Template.Add(newTemplate);
db.SaveChanges();
int Template_ID = newTemplate.Template_Id;
string Template_Value = Convert.ToString(newTemplate);
Audit_Log Current_Audit = new Audit_Log();
Current_Audit.Table_Name = "Notification Template";
Current_Audit.Active_User_ID = clsGlobals.Userlogin.Active_User_Id;
Current_Audit.Date_Time = DateTime.Now;
db.Audit_Log.Add(Current_Audit);
db.SaveChanges();
int Log_ID = Current_Audit.Audit_Log_Id;
Audit_Create_Delete Current_Create = new Audit_Create_Delete();
Current_Create.Audit_Log_Id = Log_ID;
Current_Create.Created = true;
Current_Create.PK_Row_Effected = Template_ID;
Current_Create.Value = Template_Value;
db.Audit_Create_Delete.Add(Current_Create);
db.SaveChanges();
MessageBox.Show("Notification template created successfully");
this.Close();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Would you like to delete this Template?", "Delete Template", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
try
{
Email_Notice_Template template = new Email_Notice_Template();
template = db.Email_Notice_Template.Find(tempID);
db.Email_Notice_Template.Remove(template);
db.SaveChanges();
int Marketing_Template_ID = template.Template_Id;
string Marketing_Template_Value = Convert.ToString(template);
Audit_Log Current_Audit = new Audit_Log();
Current_Audit.Table_Name = "Marketing_Template";
Current_Audit.Active_User_ID = clsGlobals.Userlogin.Active_User_Id;
Current_Audit.Date_Time = DateTime.Now;
db.Audit_Log.Add(Current_Audit);
db.SaveChanges();
int Log_ID = Current_Audit.Audit_Log_Id;
Audit_Create_Delete Current_Create = new Audit_Create_Delete();
Current_Create.Audit_Log_Id = Log_ID;
Current_Create.Created = false;
Current_Create.PK_Row_Effected = Marketing_Template_ID;
Current_Create.Value = Marketing_Template_Value;
db.Audit_Create_Delete.Add(Current_Create);
db.SaveChanges();
MessageBox.Show("Notification Template Successfully Deleted");
this.Close();
}
catch (Exception)
{
MessageBox.Show("Error has occured, and template was not deleted successfully");
}
}
}
private void btnAddUser_Click(object sender, EventArgs e)
{
if (txtUsername.Text == "" || txtPassword.Text == "")
{
MessageBox.Show("Please enter all fields");
}
else if (txtPassword.Text == txtConfirmPassword.Text)
{
try
{
SHA1CryptoServiceProvider sh = new SHA1CryptoServiceProvider();
UTF8Encoding utf8 = new UTF8Encoding();
string hash = BitConverter.ToString(sh.ComputeHash(utf8.GetBytes(txtConfirmPassword.Text)));
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=SP;Integrated Security=True");
SqlCommand cmd = new SqlCommand("insert into Active_User(Username,pass, Access)values(@User_Name,@Password,@access)", con);
cmd.Parameters.AddWithValue("@User_Name", txtUsername.Text);
cmd.Parameters.AddWithValue("@Password", hash);
cmd.Parameters.AddWithValue("@access", (cbAccessLevelName.SelectedValue));
con.Open();
//var q = db.Access_L.Where(u => u.Access_Level_Name == cbAccessLevelName.Text).FirstOrDefault();
//int Aid = Convert.ToInt32(q.Access_Level_Id.ToString());
//NewUser.Access = Aid;
//db.Active_User.Add(NewUser);
string check = @"(Select count(*) from Active_User where Username='******')";
SqlCommand cmda = new SqlCommand(check, con);
int count = (int)cmda.ExecuteScalar();
if (count > 0)
{
MessageBox.Show("A user with that username already exists");
}
else
{
try
{
//int description = 0;
//var AccessL = db.Access_L.Where(emp => emp.Access_Level_Name == cbAccessLevelName.Text).Select(u => u.Access_Level_Id).FirstOrDefault();
//description = AccessL;
//NewUser.Access = AccessL;
//NewAccess.Access_Level_Id = description;
//NewUser.Access = NewAccess.Access_Level_Id;
cmd.ExecuteNonQuery();
//db.Active_User.Add(NewUser);
//int myUser = NewUser.Active_User_Id;
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
Active_User newuser = new Active_User();
MessageBox.Show("User successfully registered!");
this.Hide();
this.Close();
//Audit Log
int accessidz = newuser.Active_User_Id;
string user_Value = Convert.ToString(newuser);
Audit_Log Current_Audit6 = new Audit_Log();
Current_Audit6.Table_Name = "User";
// Current_Audit3.Users_Id = Globals.Users_Id;
Current_Audit6.Date_Time = DateTime.Now;
db.Audit_Log.Add(Current_Audit6);
db.SaveChanges();
int Log_ID6 = Current_Audit6.Audit_Log_Id;
Audit_Create_Delete Current_Create6 = new Audit_Create_Delete();
Current_Create6.Audit_Log_Id = Log_ID6;
Current_Create6.Created = true;
Current_Create6.PK_Row_Effected = accessidz;
Current_Create6.Value = user_Value;
db.Audit_Create_Delete.Add(Current_Create6);
db.SaveChanges();
this.Close();
this.Hide();
}
}
catch (SqlException ex)
{
if (ex.Number == 2627)
{
}
else
{
MessageBox.Show("An Error:" + ex.Message);
}
}
}
else if (txtPassword.Text != txtConfirmPassword.Text)
{
MessageBox.Show("Password and confirm Password fields do not match");
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
correct = true;
Vehicle vehicle = new Vehicle();
try
{
if (ValidateIfVehicleExists(txtRegNo.Text) == true)
{
MessageBox.Show("Vehicles registration number already exists");
correct = false;
}
if (txtMake.Text == "" || txtModel.Text == "" || txtRegNo.Text == "" || txtVIN.Text == "")
{
MessageBox.Show("Please Enter Vehicles details");
correct = false;
}
if (txtRegNo.Text == "")
{
lblReg.Visible = true;
correct = false;
}
if (txtModel.Text == "")
{
lblModel.Visible = true;
correct = false;
}
if (txtVIN.Text == "")
{
lblVIN.Visible = true;
correct = false;
}
if (txtMake.Text == "")
{
lblMake.Visible = true;
correct = false;
}
if (correct == true)
{
vehicle.Vehicle_Make = txtMake.Text;
vehicle.Vehicle_Model = txtModel.Text;
vehicle.Vehicle_Registration_Number = txtRegNo.Text;
Vehicle_Status st = cbxStatus.SelectedItem as Vehicle_Status;
vehicle.Vehicle_Status_ID = st.Vehicle_Status_ID;
vehicle.Last_Serviced = dtpLastServiced.Value;
//vehicle.Vehicle_Status.Vehicle_Status_Description = "Active";// cbxStatus.Text;
vehicle.VIN_Number = txtVIN.Text;
db.Vehicles.Add(vehicle);
string Vehicle_value = Convert.ToString(vehicle);
db.SaveChanges();
MessageBox.Show("Vehicles Added Successfully");
//Audit Log
int avehicle = vehicle.Vehicle_ID;
string vehicle_Value = Convert.ToString(vehicle);
Audit_Log Current_Audit5 = new Audit_Log();
Current_Audit5.Table_Name = "Vehicle";
// Current_Audit3.Users_Id = Globals.Users_Id;
Current_Audit5.Date_Time = DateTime.Now;
db.Audit_Log.Add(Current_Audit5);
db.SaveChanges();
int Log_ID5 = Current_Audit5.Audit_Log_Id;
Audit_Create_Delete Current_Create5 = new Audit_Create_Delete();
Current_Create5.Audit_Log_Id = Log_ID5;
Current_Create5.Created = true;
Current_Create5.PK_Row_Effected = avehicle;
Current_Create5.Value = vehicle_Value;
db.Audit_Create_Delete.Add(Current_Create5);
db.SaveChanges();
this.Close();
this.Hide();
this.Close();
}
}
catch
{
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (txtAccessName.Text == "")
{
MessageBox.Show("Please enter Access Level Name");
}
else
{
try
{
if (cbxAdminScreen.Checked == true || cbxUserAccessLevelScreen.Checked == true || cbxEmployeeScreen.Checked == true || cbxSupplierOrderScreen.Checked == true || cbxPurchaseOrderScreen.Checked == true || cbxProductScreen.Checked == true || cbxClient.Checked == true || cbxReportsScreen.Checked == true || cbxSaleScreen.Checked == true || cbxVehicleScreen.Checked == true)
{
if (db.Access_Level.Where(al => al.Access_Level_Name == txtAccessName.Text.ToUpper()).Count() == 0)
{
NewRole.Admin_Role = cbxAdminScreen.Checked;
NewRole.Client_Role = cbxClient.Checked;
NewRole.Employee_Role = cbxEmployeeScreen.Checked;
NewRole.Product_Role = cbxProductScreen.Checked;
NewRole.Reports_Role = cbxReportsScreen.Checked;
NewRole.Sale_Role = cbxSaleScreen.Checked;
NewRole.Supplier_Order_Role = cbxSupplierOrderScreen.Checked;
NewRole.Client_Order_Role = cbxPurchaseOrderScreen.Checked;
NewRole.Vehicle_Role = cbxVehicleScreen.Checked;
NewRole.User_And_Access_Level_Role = cbxUserAccessLevelScreen.Checked;
NewRole.Website_Role = false;
db.User_Role.Add(NewRole);
NewAccess.Access_Level_Name = txtAccessName.Text.ToUpper();
NewAccess.Role_Id = NewRole.User_Role_Id;
db.Access_Level.Add(NewAccess);
db.SaveChanges();
MessageBox.Show("Access level added successfully");
//Audit Log
int accessidz = NewAccess.Access_Level_Id;
string access_Value = Convert.ToString(NewAccess);
Audit_Log Current_Audit4 = new Audit_Log();
Current_Audit4.Table_Name = "Access Level";
// Current_Audit3.Users_Id = Globals.Users_Id;
Current_Audit4.Date_Time = DateTime.Now;
db.Audit_Log.Add(Current_Audit4);
db.SaveChanges();
int Log_ID4 = Current_Audit4.Audit_Log_Id;
Audit_Create_Delete Current_Create4 = new Audit_Create_Delete();
Current_Create4.Audit_Log_Id = Log_ID4;
Current_Create4.Created = true;
Current_Create4.PK_Row_Effected = accessidz;
Current_Create4.Value = access_Value;
db.Audit_Create_Delete.Add(Current_Create4);
db.SaveChanges();
this.Close();
this.Hide();
}
else
{
MessageBox.Show("Access level already exists");
}
}
else
{
MessageBox.Show("Please select atleast one access level");
}
}
catch (Exception ex)
{
MessageBox.Show("Whoops, An Error Occured, Please try again" + ex);
}
}
}
