private void addButton_Click(object sender, EventArgs e)
{
if (comboBox1.Text.Length == 0)
{
MessageBox.Show("Please select a type of claim.");
return;
}
if (distanceNum.Value == 0 || destinationText.Text.Length == 0 || reasonText.Text.Length == 0)
{
MessageBox.Show("Insufficient information.");
return;
}
Database.Command("INSERT INTO travellingclaims(entryDate, numericValue, descriptionValue, reason, cost, `type`, employeeID) " +
"VALUES(" + entryDate.Value.ToString("yyyyMMdd") + "," + distanceNum.Value + ",'" + clsFunctions.fixApostrophes(destinationText.Text) +
"','" + clsFunctions.fixApostrophes(reasonText.Text) + "'," +
(comboBox1.Text.Contains("Travel")?
String.Format("{0:F2}", priceNum.Value * distanceNum.Value):
String.Format("{0:F2}",distanceNum.Value)) +
",'" + comboBox1.Text + "'," + employeeID + ")");
clsFunctions.WriteLog("New " + comboBox1.Text + " claim submitted for " + employeeCombo.Text);
distanceNum.Value = 0;
destinationText.Clear();
reasonText.Clear();
var id = Database.Retrieve("travellingClaims", "entryDate = " + entryDate.Value.ToString("yyyyMMdd") + " AND employeeID = " + employeeID +
" ORDER BY id Desc LIMIT 1", "id");
var theRow = Database.Query("SELECT * FROM travellingClaims tc JOIN employees e on e.id = tc.EmployeeId WHERE tc.id = " +
id);
//theRow.WriteXml(@"C:\LAD_DATA_DUMP\singleTravelClaim.xml", XmlWriteMode.WriteSchema);
var Report = new Reports.rptTravelClaimSingle();
Report.DataSource = theRow;
Report.headerLabel.Text = comboBox1.Text;
FileInfo exportFile = new FileInfo(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\tempClaim" + DateTime.Now.ToString("ddMMyyyyhhmmss") + ".rtf");
var stream = exportFile.Create();
Report.ExportToRtf(stream);
stream.Close();
var email = Database.Retrieve("travellingClaimTypes", "Name = '" + comboBox1.Text + "'", "emailAddress");
clsFunctions.SendEmailAttachment(email,
comboBox1.Text + " : " + employeeCombo.Text, "Please find attached claim", exportFile);
//exportFile.Delete();
loadEntries();
}
private void approveButton_Click(object sender, EventArgs e)
{
if (comboBox1.Text.Contains("Marketing"))
{
var colleges = Database.Retrieve("division", "divisionName");
ArrayList myList = new ArrayList();
foreach (DataRow theRows in colleges.Tables[0].Rows)
{
myList.Add(theRows["divisionName"]);
}
frmSelectSingle myForm = new frmSelectSingle("Select College","Select college to reflect on marketing budget",myList);
myForm.ShowDialog();
if (myForm.Selection == "***") return;
DateTime entrydate = new DateTime();
var split = entryList.FocusedItem.Text.Split(new char[] { '/' });
if (!DateTime.TryParse(split[1] + "/" + split[0] + "/" + split[2], out entrydate) || entrydate.ToString("dd/MM/yyyy") != entryList.FocusedItem.Text)
{
// MessageBox.Show("Date was not detected properly from the first method.");
DateTime.TryParse(split[0] + "/" + split[1] + "/" + split[2], out entrydate);
//MessageBox.Show("Date now detected as " + entrydate.ToString("dd/MM/yyyy"));
}
else
{
//MessageBox.Show("Date WAS detected properly from the first method.");
}
Database.Command("INSERT INTO marketingentries(division, entryDate,details1,details2,cost,marketingTypeID,`status`) VALUES('" +
clsFunctions.GetDivisionAbrev(myForm.Selection) + "'," + entrydate.ToString("yyyyMMdd") +
",'" + destinationText.Text + "','" + reasonText.Text + "'," + entryList.FocusedItem.SubItems[4].Text +
"," + Database.Retrieve("marketingTypes", "Name = '" + comboBox1.Text.Replace("Marketing ","") + "'", "id") + ",'Planned')");
}
entryList.FocusedItem.SubItems[5].Text = "Approved";
Database.Command("UPDATE travellingclaims SET approved = 'Approved' WHERE id = " + entryList.FocusedItem.SubItems[6].Text);
var theRow = Database.Query("SELECT * FROM travellingClaims tc JOIN employees e on e.id = tc.EmployeeId WHERE tc.id = " +
entryList.FocusedItem.SubItems[6].Text);
//theRow.WriteXml(@"C:\LAD_DATA_DUMP\singleTravelClaim.xml", XmlWriteMode.WriteSchema);
var Report = new Reports.rptTravelClaimSingle();
Report.headerLabel.Text = comboBox1.Text;
Report.DataSource = theRow;
FileInfo exportFile = new FileInfo(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\tempClaim" + DateTime.Now.ToString("ddMMyyyyhhmmss") + ".rtf");
var stream = exportFile.Create();
Report.ExportToRtf(stream);
stream.Close();
clsFunctions.SendEmailAttachment("*****@*****.**",
"Approved " + comboBox1.Text + " : " + employeeCombo.Text, "Please find attached Travel Claim", exportFile);
clsFunctions.WriteLog(comboBox1.Text + " Approved for " + employeeCombo.Text);
//exportFile.Delete();
loadEntries();
}
private void sendButton_Click(object sender, EventArgs e)
{
var theRow = Database.Query("SELECT * FROM travellingClaims tc JOIN employees e on e.id = tc.EmployeeId WHERE tc.id = " +
entryList.FocusedItem.SubItems[6].Text);
//theRow.WriteXml(@"C:\LAD_DATA_DUMP\singleTravelClaim.xml", XmlWriteMode.WriteSchema);
var Report = new Reports.rptTravelClaimSingle();
Report.DataSource = theRow;
FileInfo exportFile = new FileInfo(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\tempClaim" + DateTime.Now.ToString("ddMMyyyyhhmmss") + ".rtf");
var stream = exportFile.Create();
Report.ExportToRtf(stream);
stream.Close();
clsFunctions.SendEmailAttachment(Database.Retrieve("travellingClaimTypes","name = '" + comboBox1.Text + "'","emailAddress"),
comboBox1.Text + employeeCombo.Text, "Please find attached Employee Claim", exportFile);
//exportFile.Delete();
MessageBox.Show("Your claim has been sent for Approval.");
}
private void printSingleButton_Click(object sender, EventArgs e)
{
if (entryList.FocusedItem == null)
{
MessageBox.Show("Please select a claim to print first.");
return;
}
var theRow = Database.Query("SELECT * FROM travellingClaims tc JOIN employees e on e.id = tc.EmployeeId WHERE tc.id = " +
entryList.FocusedItem.SubItems[6].Text);
//theRow.WriteXml(@"C:\LAD_DATA_DUMP\singleTravelClaim.xml", XmlWriteMode.WriteSchema);
var Report = new Reports.rptTravelClaimSingle();
Report.headerLabel.Text = comboBox1.Text;
Report.DataSource = theRow;
Report.ShowPreviewDialog();
}