private void Get_Student_TC_Details()
{
string Academic_Year = string.Empty;
string Academic_Year_Format = string.Empty;
_student_TC = new Student_TC();
_student_TC_Model = _student_TC.Get_Student_TC_Details(_student_ID);
if (_student_TC_Model.Sequence_No != null)
{
txtTCNumber.Text = Convert.ToString(_student_TC_Model.TC_Number);
ddlTCReason.SelectedValue = _student_TC_Model.Reason_ID;
txtMaskedDate.Text = String.Format("{0:dd.MM.yyyy}", _student_TC_Model.TC_Date);
Academic_Year = Convert.ToString(_student_TC_Model.Academic_Year);
Academic_Year_Format = Academic_Year.Left(4) + "-" + Academic_Year.Right(4);
txtMaskedAcademicYear.Text = Academic_Year_Format;
btnDelete.Visible = true;
_sequence_No = _student_TC_Model.Sequence_No;
txtTCAmount.Text = Convert.ToString(_student_TC_Model.TC_Fee_Amount);
}
else
{
Academic_Year = Convert.ToString(Common.Get_Current_Academic_Year());
Academic_Year_Format = Academic_Year.Left(4) + "-" + Academic_Year.Right(4);
txtMaskedDate.Text = String.Format("{0:dd.MM.yyyy}", DateTime.Today);
txtMaskedAcademicYear.Text = Academic_Year_Format;
btnDelete.Visible = false;
}
}
public short USP_Save_Student_TC_Info(Student_TC_Model_Info model)
{
short result;
try
{
using (SqlService sqlService = new SqlService(ConnectionString.ConnectionStrings))
{
sqlService.AddParameter("@Sequence_No", model.Sequence_No);
sqlService.AddParameter("@Student_ID", model.Student_ID);
sqlService.AddParameter("@Reason_ID", model.Reason_ID);
sqlService.AddParameter("@TC_Number", model.TC_Number);
sqlService.AddParameter("@TC_Date", model.TC_Date);
sqlService.AddParameter("@Academic_Year", model.Academic_Year);
sqlService.AddParameter("@TC_Fee_Amount", model.TC_Fee_Amount);
sqlService.AddOutputParameter("@Result_OUT", SqlDbType.SmallInt);
sqlService.ExecuteSPNonQuery("dbo.USP_Save_Student_TC_Info");
result = (short)sqlService.Parameters["@Result_OUT"].Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
private void btnSave_Click(object sender, EventArgs e)
{
// Search_Student_Details();
if (Validate_Controls())
{
_student_TC = new Student_TC();
_student_TC_Model = new Student_TC_Model_Info()
{
Academic_Year = Convert.ToInt32(txtMaskedAcademicYear.Text.Replace("-", "")),
Sequence_No = _sequence_No,
Student_ID = _student_ID,
TC_Date = Common.Convert_String_To_Date(txtMaskedDate.Text),
Reason_ID = Convert.ToInt32(ddlTCReason.SelectedValue),
TC_Number = Convert.ToInt32(txtTCNumber.Text),
TC_Fee_Amount = Convert.ToInt32(txtTCAmount.Text),
};
short result = _student_TC.USP_Save_Student_TC_Info(_student_TC_Model);
switch (result)
{
case 1:
MessageBox.Show("Record saved successfully.", "Student TC", MessageBoxButtons.OK, MessageBoxIcon.Information);
Reset_Controls();
txtRegistrationNo.Text = string.Empty;
break;
case -1:
MessageBox.Show("Error in saving record.\n Please contact support team.", "Student TC", MessageBoxButtons.OK, MessageBoxIcon.Error);
break;
case 0:
MessageBox.Show("TC Number already exists.", "Student TC", MessageBoxButtons.OK, MessageBoxIcon.Error);
break;
}
}
}
