//Confirm button confirms the user details that are Entered.
private void ConfirmButton_Click(object sender, EventArgs e)
{
//Calls the meathod to validat Email-Id.
EmailStatus = IsValidEmail(ClientMailIdTextBox.Text);
ClientName = ClientNameTextBox.Text;
ClientTelNo = ClientTelNoTextBox.Text;
ClientMailId = ClientMailIdTextBox.Text;
TransactionNo = TransactionNoDisplayLabel.Text;
//Check if all fields are valid and displays accordingly.
if (ClientName != "" && ClientTelNo != "" && ClientMailId != "")
{
if (EmailStatus == true)
{
ClientDetailGroupBox.Visible = false;
ConfirmButton.Enabled = false;
DetailsDisplayGroupBox.Visible = true;
FinalConfirmButton.Visible = true;
FinalConfirmButton.Enabled = true;
switch (TimeFrameListBox.SelectedIndex)
{
case 0:
Term = TIMEFRAME1;
break;
case 1:
Term = TIMEFRAME2;
break;
case 2:
Term = TIMEFRAME3;
break;
case 3:
Term = TIMEFRAME4;
break;
}
//Displays the details in details box.
ClientDisplayDetailsLabel.Text = ClientName;
ClientTelNoDisplayDetailsLabel.Text = ClientTelNo;
ClientMailIdDisplayDetailsLabel.Text = ClientMailId;
TransactionNoDisplayDetailsLabel.Text = TransactionNo;
decimal TempPrincipalAmount = decimal.Parse(InvestAmountTextBox.Text);
PrincipalAmountDisplayDetailsLabel.Text = TempPrincipalAmount.ToString("C4");
InterestRateDisplayDetailsLabel.Text = InterestRate.ToString("0.00");
FinalAmountDisplayDetailsLabel.Text = FinalAmount.ToString("C4");
TermDisplayDetailsLabel.Text = Term.ToString();
}
else
{
//If boolean value is false.
MessageBox.Show("Please Enter a valid Email ID", "Invalid Field", MessageBoxButtons.OK, MessageBoxIcon.Error);
ClientMailIdTextBox.Focus();
ClientMailIdTextBox.SelectAll();
}
}
else
{
MessageBox.Show("Enter all fields", "Invalid/Blank Fields", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static List <CalculateResulte> CalaulateThePayment(int id, DateTime date)
{
var faid = db.sp_travel_Order();
var fa = db.FinalAmounts.Where(t => t.fUserID == id).FirstOrDefault();
if (fa != null)
{
finalAmount = fa;
}
travelUsed.Clear();
calculateResultes.Clear();
calculateResultes.Add(new CalculateResulte(new List <TravelsDTO>(), false, "נסיעות בודדות", 0, 0));
GetTravelsAndContractsByIdAndMonth(id, date);
//free month
type = "freeMounth";
travelsByDate = travelsById;
if (travelsByDate.Count() == 0)
{
return(null);
}
ContractBase(id);
ContractExtention(id);
addToCalculateResulte();
contractUsed.Clear();
type = "freeDay";
for (int i = 0; i < DateTime.DaysInMonth(date.Year, date.Month); i++)
{
contractUsed.Clear();
travelUsed.Clear();
travelsByDate = travelsById.Where(x => x.date.Day == i).ToList();
if (travelsByDate.Count() == 0)
{
continue;
}
ContractBase(id);
ContractExtention(id);
addToCalculateResulte();
}
if (calculateResultes[0].price == 0)
{
calculateResultes.Remove(calculateResultes[0]);
}
double finalprice = 0;
foreach (var item in calculateResultes)
{
finalprice += item.price;
}
finalAmount.finalAmount1 = finalprice;
return(calculateResultes);
}
private void searchbtn_Click(object sender, EventArgs e)
{
string Cnx1 = @"Data Source=.\SQLEXPRESS;AttachDbFilename=E:\data 3 new\Final project\print\controller.mdf;Integrated Security=True;User Instance=True";
SqlConnection conx1 = new SqlConnection(Cnx1);
conx1.Open();
if (facultyCmbBox.Text == "CSE")
{
//This code is susceptible to SQL injection attacks.
string Qry1 = "SELECT * FROM CSEBillRemunerationExm WHERE TeacherName = '" + this.TeacherNamtxt.Text + "'AND CourseCode ='" + this.coursecodetxt.Text + "'";
SqlCommand comd1 = new SqlCommand(Qry1, conx1);
SqlDataReader dtr1 = comd1.ExecuteReader();
dtr1.Read();
try
{
// DesigCmbBox.Hide();
//Addresstxt.Hide();
Sessiontxt.Hide();
NoOfStdtxt.Hide();
noofgrptxt.Hide();
MidTherAmount.Hide();
MidPracAmn.Hide();
FinalExmAmount.Hide();
ClassTestAmount.Hide();
FinalAmount.Hide();
QusModAmount.Hide();
tabulationAmount.Hide();
totalAmount.Hide();
//String n1 = dtr1["Designtion"].ToString(); DesigCmbBox.Show();
//String n2 = dtr1["Address"].ToString(); Addresstxt.Show();
String n3 = dtr1["Session"].ToString(); Sessiontxt.Show();
String n4 = dtr1["NoOfStudent"].ToString(); NoOfStdtxt.Show();
String n5 = dtr1["NoOfPactGroup"].ToString(); noofgrptxt.Show();
String n6 = dtr1["MidTherAmn"].ToString(); MidTherAmount.Show();
String n7 = dtr1["MidPracAmn"].ToString(); MidPracAmn.Show();
String n8 = dtr1["ClassTestAmn"].ToString(); ClassTestAmount.Show();
String n9 = dtr1["FinalAmn"].ToString(); FinalAmount.Show();
String n10 = dtr1["QusAmn"].ToString(); QusModAmount.Show();
String n11 = dtr1["TbulAmn"].ToString(); tabulationAmount.Show();
String n12 = dtr1["totelAmn"].ToString(); totalAmount.Show();
String n13 = dtr1["FinalExmAmn"].ToString(); FinalExmAmount.Show();
//txtbx
//DesigCmbBox.Text = n1;
//Addresstxt.Text = n2;
Sessiontxt.Text = n3;
NoOfStdtxt.Text = n4;
noofgrptxt.Text = n5;
MidTherAmount.Text = n6;
MidPracAmn.Text = n7;
FinalExmAmount.Text = n13;
ClassTestAmount.Text = n8;
FinalAmount.Text = n9;
QusModAmount.Text = n10;
tabulationAmount.Text = n11;
totalAmount.Text = n12;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (facultyCmbBox.Text == "BBA")
{
//This code is susceptible to SQL injection attacks.
string Qry1 = "SELECT * FROM BBABillRemunerationExm WHERE TeacherName = '" + this.TeacherNamtxt.Text + "'AND CourseCode ='" + this.coursecodetxt.Text + "'";
SqlCommand comd1 = new SqlCommand(Qry1, conx1);
SqlDataReader dtr1 = comd1.ExecuteReader();
dtr1.Read();
try
{
//DesigCmbBox.Hide();
//Addresstxt.Hide();
Sessiontxt.Hide();
NoOfStdtxt.Hide();
noofgrptxt.Hide();
MidTherAmount.Hide();
MidPracAmn.Hide();
FinalExmAmount.Hide();
ClassTestAmount.Hide();
FinalAmount.Hide();
QusModAmount.Hide();
tabulationAmount.Hide();
totalAmount.Hide();
//String n1 = dtr1["Designtion"].ToString(); DesigCmbBox.Show();
//String n2 = dtr1["Address"].ToString(); Addresstxt.Show();
String n3 = dtr1["Session"].ToString(); Sessiontxt.Show();
String n4 = dtr1["NoOfStudent"].ToString(); NoOfStdtxt.Show();
String n5 = dtr1["NoOfPactGroup"].ToString(); noofgrptxt.Show();
String n6 = dtr1["MidTherAmn"].ToString(); MidTherAmount.Show();
String n7 = dtr1["MidPracAmn"].ToString(); MidPracAmn.Show();
String n8 = dtr1["ClassTestAmn"].ToString(); ClassTestAmount.Show();
String n9 = dtr1["FinalAmn"].ToString(); FinalAmount.Show();
String n10 = dtr1["QusAmn"].ToString(); QusModAmount.Show();
String n11 = dtr1["TbulAmn"].ToString(); tabulationAmount.Show();
String n12 = dtr1["totelAmn"].ToString(); totalAmount.Show();
String n13 = dtr1["FinalExmAmn"].ToString(); FinalExmAmount.Show();
//txtbx
//DesigCmbBox.Text = n1;
//Addresstxt.Text = n2;
Sessiontxt.Text = n3;
NoOfStdtxt.Text = n4;
noofgrptxt.Text = n5;
MidTherAmount.Text = n6;
MidPracAmn.Text = n7;
FinalExmAmount.Text = n13;
ClassTestAmount.Text = n8;
FinalAmount.Text = n9;
QusModAmount.Text = n10;
tabulationAmount.Text = n11;
totalAmount.Text = n12;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
conx1.Close();
}
