private void button2_Click(object sender, EventArgs e)
{
masterForm objFrmMain = new masterForm();
this.Hide();
objFrmMain.Show();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection sqlcon = new SqlConnection(@"Data Source=celsa.database.windows.net;Initial Catalog=pos-mugdho;User ID=celsa;Password=Qwerty1@3$5");
string query = "Select * from Users Where Email='" + EmailTextBox.Text.Trim() + "' and password = '******'";
SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
using (SqlConnection connection = new SqlConnection(@"Data Source=celsa.database.windows.net;Initial Catalog=pos-mugdho;User ID=celsa;Password=Qwerty1@3$5"))
{
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader read = command.ExecuteReader();
while (read.Read())
{
Users.Name = (read["Name"].ToString());
Users.Email = (read["Email"].ToString());
Users.UserID = (read["UserID"].ToString());
}
read.Close();
}
DataTable dtbl = new DataTable();
sda.Fill(dtbl);
if (dtbl.Rows.Count == 1)
{
masterForm objFrmMain = new masterForm();
this.Hide();
objFrmMain.Show();
}
else
{
MessageBox.Show("Check your username and password");
}
}
private void button5_Click(object sender, EventArgs e)
{
int paidAmountDuringAddmissionForCheck;
int.TryParse(PaidAmountTextbox.Text, out paidAmountDuringAddmissionForCheck);
int addmissionFeeForCheck;
int.TryParse(AdmissionFeeDropdown.selectedValue, out addmissionFeeForCheck);
int rollNumberForDuplicacy;
int.TryParse(RollNumberTextBox.Text, out rollNumberForDuplicacy);
SqlConnection sqlcon = new SqlConnection(@"Data Source=celsa.database.windows.net;Initial Catalog=pos-mugdho;User ID=celsa;Password=Qwerty1@3$5");
string query = "Select * from Registration Where StudentRollNumber=" + rollNumberForDuplicacy;
SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
DataTable dtbl = new DataTable();
sda.Fill(dtbl);
if (dtbl.Rows.Count == 1)
{
MessageBox.Show("This RollNumber is duplicate");
}
else if (addmissionFeeForCheck > paidAmountDuringAddmissionForCheck)
{
MessageBox.Show("You have to pay full admission fee for Registration");
}
else
{
//if(AdmissionFeeDropdown.selectedValue<TotalPaybleTextbox.Text)
if (RollNumberTextBox.Text != "" && studentNameTextBox.Text != "")
{
cmd = new SqlCommand("insert into Registration(StudentName,StudentRollNumber," +
"GuardiansName,Address,DoB,School,Class,AdmissionFee," +
"MobileNumber,Version,Course,MonthlyFee,CourseStartDate,Status," +
"CreationDate,CreatedBy,RefrenceRollNumber," +
"Discount,TotalPayableDuringAdmission," +
"PaidAmountDuringAdmission) " +
"values(@StudentName," +
"@StudentRollNumber,@GuardiansName,@Address,@DoB,@School," +
"@Class,@AdmissionFee,@MobileNumber,@Version" +
",@Course,@MonthlyFee,@CourseStartDate,@Status,@CreationDate," +
"@CreatedBy,@RefrenceRollNumber,@Discount," +
"@TotalPayableDuringAdmission,@PaidAmountDuringAdmission)", con);
dmd = new SqlCommand(@"insert into StudentDue(RollNumber,TotalDue) values (@RollNumber,@TotalDue)", con);
fmd = new SqlCommand(@"insert into Reference(ReferenceRollNumber,ReferedFor,DiscountAmount) values (@ReferenceRollNumber,@ReferedFor,@DiscountAmount)", con);
gmd = new SqlCommand(@"insert into MoneyCollection(StudentRollNumber,
CollectedAmount,CollectorID,CollectionMonth,
StudentName,CollectionDate,CollectionType,OtherDiscount,TrxID) values(@StudentRollNumber,@CollectedAmount,@CollectorID,
@CollectionMonth,@StudentName,@CollectionDate,@CollectionType,@OtherDiscount,@TrxID)", con);
pmd = new SqlCommand(@"insert into MoneyCollection(StudentRollNumber,
CollectedAmount,CollectorID,CollectionMonth,
StudentName,CollectionDate,CollectionType,OtherDiscount,TrxID) values(@StudentRollNumber,@CollectedAmount,@CollectorID,
@CollectionMonth,@StudentName,@CollectionDate,@CollectionType,@OtherDiscount,@TrxID)", con);
con.Open();
cmd.Parameters.AddWithValue("@StudentName", studentNameTextBox.Text);
int rollNumber;
if (int.TryParse(RollNumberTextBox.Text, out rollNumber))
{
cmd.Parameters.AddWithValue("@StudentRollNumber", rollNumber);
fmd.Parameters.AddWithValue("@ReferedFor", rollNumber);
dmd.Parameters.AddWithValue("@RollNumber", rollNumber);
int due;
int.TryParse(DueTextbox.Text, out due);
dmd.Parameters.AddWithValue("@TotalDue", due);
cmd.Parameters.AddWithValue("@Discount", due);
fmd.Parameters.AddWithValue("@DiscountAmount", 500);
}
int totalpayableDuringAddmission;
int.TryParse(TotalPaybleTextbox.Text, out totalpayableDuringAddmission);
int paidAmountDuringAddmission;
int.TryParse(PaidAmountTextbox.Text, out paidAmountDuringAddmission);
int addmissionFee;
int.TryParse(AdmissionFeeDropdown.selectedValue, out addmissionFee);
int monthlyPayable = paidAmountDuringAddmission - addmissionFee;
cmd.Parameters.AddWithValue("@GuardiansName", GuardiansNameTextbox.Text);
cmd.Parameters.AddWithValue("@Address", AddressTexbox.Text);
cmd.Parameters.AddWithValue("@DoB", bunifuDatepicker2.Value);
cmd.Parameters.AddWithValue("@School", bunifuDropdown1.selectedValue);
cmd.Parameters.AddWithValue("@Class", bunifuDropdown3.selectedValue);
cmd.Parameters.AddWithValue("@AdmissionFee", AdmissionFeeDropdown.selectedValue);
cmd.Parameters.AddWithValue("@MobileNumber", MobileTextBox.Text);
cmd.Parameters.AddWithValue("@Version", bunifuDropdown2.selectedValue);
cmd.Parameters.AddWithValue("@Course", bunifuDropdown4.selectedValue);
cmd.Parameters.AddWithValue("@MonthlyFee", monthlyFeeDropDown.selectedValue);
cmd.Parameters.AddWithValue("@CourseStartDate", bunifuDatepicker3.Value);
cmd.Parameters.AddWithValue("@Status", bunifuDropdown7.selectedValue);
cmd.Parameters.AddWithValue("@CreationDate", DateTime.Today);
cmd.Parameters.AddWithValue("@CreatedBy", Users.UserID);
cmd.Parameters.AddWithValue("@TotalPayableDuringAdmission", totalpayableDuringAddmission);
cmd.Parameters.AddWithValue("@PaidAmountDuringAdmission", paidAmountDuringAddmission);
int referenceRollNumber;
if (int.TryParse(ReferenceRollTextBox.Text, out referenceRollNumber))
{
cmd.Parameters.AddWithValue("@RefrenceRollNumber", referenceRollNumber);
fmd.Parameters.AddWithValue("@ReferenceRollNumber", referenceRollNumber);
}
else
{
cmd.Parameters.AddWithValue("@RefrenceRollNumber", referenceRollNumber);
fmd.Parameters.AddWithValue("@ReferenceRollNumber", referenceRollNumber);
}
string trxID = RollNumberTextBox.Text + DateTime.Today.Day.ToString() + DateTime.Today.Month.ToString() +
DateTime.Today.Year.ToString();
gmd.Parameters.AddWithValue("@StudentRollNumber", rollNumber);
gmd.Parameters.AddWithValue("@CollectedAmount", AdmissionFeeDropdown.selectedValue.ToString());
gmd.Parameters.AddWithValue("@StudentName", studentNameTextBox.Text);
string monthName = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(bunifuDatepicker3.Value.Month);
gmd.Parameters.AddWithValue("@CollectionMonth", monthName + "," + bunifuDatepicker3.Value.Year.ToString());
gmd.Parameters.AddWithValue("@CollectorID", Users.UserID);
gmd.Parameters.AddWithValue("@CollectionDate", DateTime.Today);
gmd.Parameters.AddWithValue("@CollectionType", "Admission");
gmd.Parameters.AddWithValue("@OtherDiscount", DiscountTextbox.Text);
gmd.Parameters.AddWithValue("@TrxID", trxID);
pmd.Parameters.AddWithValue("@StudentRollNumber", rollNumber);
pmd.Parameters.AddWithValue("@CollectedAmount", monthlyPayable.ToString());
pmd.Parameters.AddWithValue("@StudentName", studentNameTextBox.Text);
// string monthName = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(bunifuDatepicker3.Value.Month);
pmd.Parameters.AddWithValue("@CollectionMonth", monthName + "," + bunifuDatepicker3.Value.Year.ToString());
pmd.Parameters.AddWithValue("@CollectorID", Users.UserID);
pmd.Parameters.AddWithValue("@CollectionDate", DateTime.Today);
pmd.Parameters.AddWithValue("@CollectionType", "MonthlyFee");
pmd.Parameters.AddWithValue("@OtherDiscount", DiscountTextbox.Text);
pmd.Parameters.AddWithValue("@TrxID", trxID);
cmd.ExecuteNonQuery();
dmd.ExecuteNonQuery();
fmd.ExecuteNonQuery();
gmd.ExecuteNonQuery();
pmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Inserted Successfully");
SendSMS(RollNumberTextBox.Text, paidAmountDuringAddmission.ToString(), trxID, MobileTextBox.Text, studentNameTextBox.Text);
masterForm NewForm = new masterForm();
NewForm.Show();
this.Dispose(false);
string collectionType = "AdmissionFee";
string date = monthName + "," + bunifuDatepicker3.Value.Year.ToString();
PrintableForm objFrmMain = new PrintableForm(rollNumber.ToString(), date, collectionType);
objFrmMain.Show();
}
else
{
MessageBox.Show("Please Provide Required Fields!");
}
}
}
