private void BAddToPayroll_Click(object sender, EventArgs e) //Fires upon clicking the "Add" button
{
try
{
float test = 0.0f;
Employee temp = new Employee(); //making employee to add to payroll
temp.FirstName = TBEmployeeNameFirst.Text;
temp.LastName = TBEmployeeNameLast.Text;
temp.PhoneNumber = TBPhoneNumber.Text;
temp.Address.StreetAddress = TBAddress.Text;
temp.Address.ApartmentNumber = TBApartmentNumber.Text;
temp.Address.City = TBCity.Text;
temp.Address.State = TBState.Text;
temp.Address.ZipCode = TBZipCode.Text;
temp.Title = TBJobTitle.Text;
if (float.TryParse(TBWage.Text, out test)) //sanity check for wage
{
temp.Wage = float.Parse(TBWage.Text);
}
temp.IsOnPayroll = CBIsOnPayroll.Checked;
if (float.TryParse(TBHoursWorked.Text, out test)) //sanity check for hours worked
{
temp.HoursWorked = float.Parse(TBHoursWorked.Text);
}
payroll[employeeIndex] = temp; //adds employee to payroll
PayrollList.Items.Add(payroll[employeeIndex]); //adds employee to visible payroll
employeeIndex++; //increment index
}
catch (PhoneNumberException) //Exception handling!
{
MessageBox.Show("Phone numbers must be ten digits!");
}
catch (WageException)
{
MessageBox.Show("Can't have negative wages!");
}
catch (TimeWorkedException)
{
MessageBox.Show("Can't have negative hours worked!");
}
catch (Exception)
{
MessageBox.Show("Something is wrong.\nThat's all we know.");
}
TBEmployeeNameFirst.Clear(); //returning fields to their default state
TBEmployeeNameLast.Clear();
TBPhoneNumber.Clear();
TBAddress.Clear();
TBApartmentNumber.Clear();
TBCity.Clear();
TBState.Clear();
TBZipCode.Clear();
TBJobTitle.Clear();
TBWage.Clear();
CBIsOnPayroll.Checked = false;
TBHoursWorked.Clear();
}
protected void LinkBtnCityInsert_Click(object sender, EventArgs e)
{
if (TBCity.Text == "")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "isActive", "myModalCity();", true);
TBCity.Focus();
BindDll();
}
else
{
string query = "select * from City where City_ ='" + TBCity.Text + "'";
SqlCommand cmdcity = new SqlCommand(query, con);
DataTable dtcity = new DataTable();
SqlDataAdapter adpcity = new SqlDataAdapter(cmdcity);
adpcity.Fill(dtcity);
if (dtcity.Rows.Count > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "isActive", "Alert();", true);
lblalert.Text = "City is already Exits!!";
BindDll();
}
else
{
try
{
City city = new City();
city.CityID = HFCity.Value;
city.City_ = string.IsNullOrEmpty(TBCity.Text) ? null : TBCity.Text;
CityManager citymanag = new CityManager(city);
citymanag.Save();
BindDll();
clearcity();
ScriptManager.RegisterStartupScript(this, this.GetType(), "isActive", "showsupplier();", true);
}
catch (Exception ex)
{
// throw;
ScriptManager.RegisterStartupScript(this, this.GetType(), "isActive", "Alert();", true);
lblalert.Text = ex.Message;
}
}
}
}
private int ImportCity(string name, int idProvince, int idCountry, string cityType)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
var existData = db.TBCities.Where(x => !x.Deflag && x.Name.ToLower() == name.ToLower()).FirstOrDefault();
if (existData == null)
{
TBCity newData = new TBCity();
newData.IDProvince = idProvince;
newData.Name = name;
newData.CityType = cityType;
newData.Deflag = false;
newData.DateInsert = DateTime.Now;
newData.DateLastUpdate = DateTime.Now;
db.TBCities.InsertOnSubmit(newData);
db.SubmitChanges();
existCity = false;
return(newData.IDCity);
}
else
{
if (existData.IDProvince == idProvince)
{
return(existData.IDCity);
}
else
{
TBCity newData = new TBCity();
newData.IDProvince = idProvince;
newData.Name = name;
newData.CityType = cityType;
newData.Deflag = false;
newData.DateInsert = DateTime.Now;
newData.DateLastUpdate = DateTime.Now;
db.TBCities.InsertOnSubmit(newData);
db.SubmitChanges();
existCity = false;
return(newData.IDCity);
}
}
}
catch (Exception)
{
throw;
}
}
private void BModifyDone_Click(object sender, EventArgs e) //fires on clicking the "Done" button
{
int index = PayrollList.Items.IndexOf(PayrollList.SelectedItem); //gets the index of the selected employee in the visible payroll
Employee emp = (Employee)PayrollList.SelectedItem; //copies the selected employee from the visible payroll to the backend
PayrollList.Items.Remove(PayrollList.SelectedItem); //removes the selected visible employee
try
{ //alters the employee's data in the backend payroll using same methods as creating
float test = 0.0f;
emp.FirstName = TBEmployeeNameFirst.Text;
emp.LastName = TBEmployeeNameLast.Text;
emp.PhoneNumber = TBPhoneNumber.Text;
emp.Address.StreetAddress = TBAddress.Text;
emp.Address.ApartmentNumber = TBApartmentNumber.Text;
emp.Address.City = TBCity.Text;
emp.Address.State = TBState.Text;
emp.Address.ZipCode = TBZipCode.Text;
emp.Title = TBJobTitle.Text;
if (float.TryParse(TBWage.Text, out test))
{
emp.Wage = float.Parse(TBWage.Text);
}
emp.IsOnPayroll = CBIsOnPayroll.Checked;
if (float.TryParse(TBHoursWorked.Text, out test))
{
emp.HoursWorked = float.Parse(TBHoursWorked.Text);
}
BModifyDone.Visible = false; //hides the "Done" button
BAddToPayroll.Visible = true; //shows the "Add" button
BModifyEmployee.Visible = true; //shows the "Edit" button
BPayEmployee.Visible = true; //shows the "Pay" button
}
catch (PhoneNumberException) //Exception handling!
{
MessageBox.Show("Phone numbers must be ten digits!");
}
catch (WageException)
{
MessageBox.Show("Can't have negative wages!");
}
catch (TimeWorkedException)
{
MessageBox.Show("Can't have negative hours worked!");
}
catch (Exception)
{
MessageBox.Show("Something is wrong.\nThat's all we know.");
}
PayrollList.Items.Insert(index, emp); //"refreshes" the visible employee with the correct info
TBEmployeeNameFirst.Clear(); //returns fields to the default state
TBEmployeeNameLast.Clear();
TBPhoneNumber.Clear();
TBAddress.Clear();
TBApartmentNumber.Clear();
TBCity.Clear();
TBState.Clear();
TBZipCode.Clear();
TBJobTitle.Clear();
TBWage.Clear();
CBIsOnPayroll.Checked = false;
TBHoursWorked.Clear();
}
protected void btnImport_Click(object sender, EventArgs e)
{
if (fuFile.HasFile)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
fuFile.SaveAs(Server.MapPath("~/assets/import/region/" + fuFile.FileName));
StreamReader sr = new StreamReader(Server.MapPath("~/assets/import/region/" + fuFile.FileName));
try
{
CsvReader csvread = new CsvReader(sr);
csvread.Configuration.Delimiter = ";";
csvread.Configuration.HasHeaderRecord = true;
List <CSV_City> record = csvread.GetRecords <CSV_City>().ToList();
int totalRead = 0;
int totalInsert = 0;
foreach (var item in record)
{
totalRead++;
if (db.TBProvinces.Where(X => X.IDProvince == item.IDProvince).FirstOrDefault() != null)
{
if (db.TBCities.Where(x => x.Name.ToLower() == item.Name.ToLower()).FirstOrDefault() == null)
{
TBCity newCity = new TBCity {
IDProvince = item.IDProvince, Name = item.Name, CityType = item.CityType, Deflag = false, DateInsert = DateTime.Now, DateLastUpdate = DateTime.Now
};
db.TBCities.InsertOnSubmit(newCity);
totalInsert++;
}
else
{
lblSuccess.Text += item.Name + "--";
}
}
else
{
lblSuccess.Text += item.Name + "(" + item.IDProvince + ")--";
}
}
db.SubmitChanges();
foreach (TBCity item in db.TBCities)
{
if (item.CityType == "KO")
{
item.Name = ("KOTA " + item.Name).Trim();
}
else if (item.CityType == "KA")
{
item.Name = ("KAB " + item.Name).Trim();
}
//if (item.CityType == "KO")
// item.Name = item.Name.Substring(1);
//else if (item.CityType == "KA")
// item.Name = item.Name.Substring(1);
db.SubmitChanges();
}
sr.Close();
lblSuccess.Text += totalRead + " row(s) read, " + totalInsert + " row(s) inserted";
alertError.Style.Add(HtmlTextWriterStyle.Display, "none");
alertSuccess.Style.Add(HtmlTextWriterStyle.Display, "block");
}
catch (Exception ex)
{
sr.Close();
lblError.Text = ex.Message;
alertError.Style.Add(HtmlTextWriterStyle.Display, "block");
alertSuccess.Style.Add(HtmlTextWriterStyle.Display, "none");
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
alertError.Style.Add(HtmlTextWriterStyle.Display, "block");
alertSuccess.Style.Add(HtmlTextWriterStyle.Display, "none");
}
}
}
