// Bind Class
#region [Bind Class]
public DataSet DL_BindBranch(EWA_Admission objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[6];
prmList[0] = "@Action";
prmList[1] = "FetchBranch";
prmList[2] = "@OrgID";
prmList[3] = Convert.ToString(objEWA.OrgID);
prmList[4] = "@CourseId";
prmList[5] = Convert.ToString(objEWA.Course);
ds = ObjHelper.FillControl(prmList, "SP_AdmissionForm");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
}
return(ds);
}
catch (Exception)
{
// GeneralErr(exp.Message.ToString());
throw;
}
}
public int InsertEnquiryInfo(EWA_Admission objBEL)
{
try
{
int flag = objDAL.SaveEnquiryInfo(objBEL);
return(flag);
}
catch (Exception)
{
throw;
}
}
public int UpgradeYear(EWA_Admission objBEL, string[] AdmissionID)
{
try
{
int flag = objDAL.UpgradeYear(objBEL, AdmissionID);
return(flag);
}
catch (Exception)
{
throw;
}
}
//
//Added by Ashwini 9-OCT-2020
public DataSet InsertPromoteStudentData(EWA_Admission objEWA)
{
try
{
DL_Common objDL = new DL_Common();
DataSet ds = objDL.InsertPromoteStudentData(objEWA);
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
public string SaveStudentFeesHistrory(EWA_Admission objEWA)
{
try
{
//DL_Admission objDL = new DL_Admission();
string flag = objDAL.SaveStudentFeesHistrory(objEWA);
return(flag);
}
catch (Exception ex)
{
throw;
}
}
//Update Addmission Status
#region [Update Admission Status]
public int UpdateAdmissionStatus(EWA_Admission objEWA)
{
try
{
//DL_Admission objDL = new DL_Admission();
int flag = objDAL.DL_UpdateAdmissionStatus(objEWA);
return(flag);
}
catch (Exception ex)
{
throw;
}
}
//Select Student Addmission
#region [Select Student Addmission]
public DataSet SelectStudentAdmission(EWA_Admission objEWA)
{
try
{
DL_Admission objDL = new DL_Admission();
DataSet ds = objDL.DL_SelectStudentAdmission(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
}
//Bind Caste Category
#region [Bind Caste Category]
public DataSet BindCasteCategory_BL(EWA_Admission objEWA)
{
try
{
DL_Admission objDL = new DL_Admission();
DataSet ds = objDL.BindCasteCategory_DL(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
}
//Bind Class
#region [Bind Region]
public DataSet BL_BindClass(EWA_Admission objEWA)
{
try
{
DL_Admission objDL = new DL_Admission();
DataSet ds = objDL.DL_BindClass(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
}
// Select Data
#region [Select Data]
public DataSet DL_SelectStudentAdmission(EWA_Admission objEWA)
{
DataSet ds = new DataSet();
try
{
// DateTime dt = DateTime.Parse(objEWA.FromDate);
prmList = new string[16];
prmList[0] = "@Action";
prmList[1] = "FetchAdmissionDetails";
prmList[2] = "@OrgId";
prmList[3] = Convert.ToString(objEWA.OrgID);
prmList[4] = "@CourseId";
prmList[5] = Convert.ToString(objEWA.Course);
prmList[6] = "@BranchId";
prmList[7] = Convert.ToString(objEWA.Branch_ID);
prmList[8] = "@ClassId";
prmList[9] = Convert.ToString(objEWA.Class1);
prmList[10] = "@FromDate";
prmList[11] = objEWA.FromDate;
prmList[12] = "@ToDate";
prmList[13] = objEWA.ToDate;
prmList[14] = "@Status";
prmList[15] = "Pending";
ds = ObjHelper.FillControl(prmList, "SP_AdmissionForm");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
}
return(ds);
}
catch (Exception)
{
// GeneralErr(exp.Message.ToString());
throw;
}
}
//SaveAdmission
#region [Save Admission]
public int UpgradeYear(EWA_Admission objBEL, string[] _AdmissionID)
{
int flag = 0;
try
{
SqlCommand cmd = new SqlCommand("SP_AdmissionForm", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
foreach (string AdmissionID in _AdmissionID)
{
cmd.Parameters.AddWithValue(@"Action", objBEL.TransationAction);
cmd.Parameters.AddWithValue(@"AdmissionID", AdmissionID);
cmd.Parameters.AddWithValue(@"OrgId", objBEL.OrgID);
cmd.Parameters.AddWithValue(@"CourseId", objBEL.Course);
cmd.Parameters.AddWithValue(@"BranchId", objBEL.Branch_ID);
cmd.Parameters.AddWithValue(@"ClassId", objBEL.Class1);
//cmd.Parameters.AddWithValue(@"CasteCategoryId", objBEL.CasteCategory);
cmd.Parameters.AddWithValue(@"Status", objBEL.Status);
flag = cmd.ExecuteNonQuery();
}
return(flag);
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
}
private void SaveAdmissionDetails(string strAction)
{
try
{
EWA_Admission objEWA = new EWA_Admission();
BL_Admission objBAL = new BL_Admission();
// Get College ID And Name From Session
// Panel 1
objEWA.TransationAction = strAction.ToString();
objEWA.AdmissionID = txtFormNo.Text.ToString();
objEWA.AdmissionDate = txtAdmissionDate.Text;
objEWA.OrgID = Convert.ToInt32(DDL_SelectCollege.SelectedValue);
objEWA.GRNo = txtGRNo.Text;
objEWA.AdharNo = txtAdhar.Text;
objEWA.FirstName = txtFirstName.Text.Trim();
objEWA.MiddleName = txtMiddleName.Text.Trim();
objEWA.LastName = txtLastName.Text.Trim();
objEWA.Course = ddlCourse.SelectedValue.Trim().Trim();
objEWA.Branch_ID = Convert.ToInt32(ddlBranch.SelectedValue);
objEWA.Class1 = ddlClass.SelectedValue.Trim().Trim();
objEWA.BirthDate = txtBirthDate.Text;
objEWA.BirthPlace = txtBirthPlace.Text.Trim();
objEWA.Country1 = ddlCountry.SelectedValue.ToString();
objEWA.State1 = ddlState.SelectedValue.ToString();
objEWA.District1 = ddlDistrict.SelectedValue.ToString();
objEWA.Taluka1 = txtTal.Text.Trim();
objEWA.City1 = txtCity.Text.Trim();
objEWA.LastInstitute = txtLastSchool.Text.Trim();
objEWA.Gender1 = rbtGender.SelectedItem.ToString();
objEWA.BloodGroup = ddlBloodGroup.SelectedValue.ToString();
objEWA.Religion1 = ddlReligion.SelectedValue.ToString();
objEWA.Subcaste = txtSubcaste.Text;
objEWA.MotherTongue = txtMotherTongue.Text;
objEWA.Nationality1 = ddlNationality.SelectedValue.ToString();
objEWA.AddressLine1 = txtAddress1.Text.Trim();
objEWA.AddressLine2 = txtAddress2.Text.Trim();
objEWA.FeesCategory = ddlFeeCategory.SelectedValue.ToString().Trim();
objEWA.CasteCategory = ddlCaste.SelectedValue.Trim();
objEWA.ParentName = txtFather.Text.Trim();
objEWA.MotherName = txtMother.Text.Trim();
objEWA.ParentMobile = txtFatherMobile.Text.Trim();
objEWA.ParentEmail = txtFatherEmail.Text.Trim();
objEWA.Parent_Education = txtFatherEdu.Text.Trim();
objEWA.Parent_Occupation = txtFatherOccu.Text.Trim();
objEWA.MobileNo = txtFatherMobile.Text.Trim();
objEWA.E_Mail = txtFatherEmail.Text.Trim();
objEWA.AdmissionYear = System.DateTime.Now.ToString("yyyy");
objEWA.GuardianName = txtMother.Text.ToString();
objEWA.Relation1 = "Mother";
objEWA.GuardianMobile = txtMotherMobile.Text.Trim();
objEWA.GuardianEmail = txtMotherEmail.Text.Trim();
objEWA.Guardian_Education = txtMotherEdu.Text.Trim();
objEWA.Guardian_Occupation = txtMotherOccu.Text.Trim();
// Panel Parent information
objEWA.StudentUserName = txtFormNo.Text.Trim();
objEWA.StudentPassword = txtFormNo.Text.Trim();
// Iamage Store
int length = 0;
byte[] imgPhotobyte = null;
if (fileupload_StudentPhoto.HasFile)
{
length = fileupload_StudentPhoto.PostedFile.ContentLength;
imgPhotobyte = new byte[length];
HttpPostedFile img1 = fileupload_StudentPhoto.PostedFile;
img1.InputStream.Read(imgPhotobyte, 0, length);
ViewState["StudentPhoto"] = imgPhotobyte;
}
GridToDatatable();
objEWA.dtDocuments = ViewState["tempDocs"] as DataTable;
objEWA.StudentPhoto = (byte[])ViewState["StudentPhoto"];
objEWA.Status = "Pending";
if (Session["GRNO"] != null)
{
if (Session["GRNO"].ToString() == txtGRNo.Text)
{
//msgBox.ShowMessage("Record already present !!!", "Information", UserControls.MessageBox.MessageStyle.Successfull);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Information", "alert('Form Submitted Successfully')", true);
ClearControls();
return;
}
}
else
{
Session["GRNO"] = txtGRNo.Text;
}
int flag = objBAL.InsertInto(objEWA);
if (flag > 0)
{
if (strAction == "Save")
{
//string strSMS = null;
//string strEmail = null;
// strEmail = SendEmails();
msgBox.ShowMessage("Form Submitted Successfully", "Saved", UserControls.MessageBox.MessageStyle.Successfull);
print();
Button1.Visible = true;
btnSave.Visible = false;
// msgBox.ShowMessage(strSMS, "Saved", UserControls.MessageBox.MessageStyle.Successfull);
// msgBox.ShowMessage(strEmail, "Saved", UserControls.MessageBox.MessageStyle.Successfull);
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Form Sumitted Successfully Check Your Mail !!!')", true);
// Response.Redirect("~/College_Home.aspx");
ClearControls();
// Response.Redirect("~/Forms/Admin/College_Home.aspx");
}
else if (strAction == "Update")
{
msgBox.ShowMessage("Record Updated Successfully !!!", "Updated", UserControls.MessageBox.MessageStyle.Successfull);
}
else if (strAction == "Delete")
{
msgBox.ShowMessage("Record Deleted Successfully !!!", "Deleted", UserControls.MessageBox.MessageStyle.Successfull);
}
}
}
catch (Exception)
{
// throw;
}
}
private void SaveAdmissionDetails(string strAction)
{
try
{
EWA_Admission objEWA = new EWA_Admission();
BL_Admission objBAL = new BL_Admission();
// Get College ID And Name From Session
// Panel 1
objEWA.TransationAction = strAction.ToString();
objEWA.AdmissionID = lbl_ApplicationId.Text.ToString();
//System.Data.SqlTypes.SqlDateTime AdmissionDate = System.Data.SqlTypes.SqlDateTime.Parse(lblAdmissionDate.Text);
DateTime datetime1 = Convert.ToDateTime(lblAdmissionDate.Text);
objEWA.AdmissionDate = datetime1.ToString();
objEWA.OrgID = Convert.ToInt32(Session["OrgId"]);
objEWA.AdmissionType = ddl_AdmissionType.SelectedValue.ToString().Trim();
objEWA.Course = ddl_Course.SelectedValue.Trim().Trim();
objEWA.Branch_ID = Convert.ToInt32(ddl_Branch.SelectedValue);
objEWA.Class1 = ddl_Class.SelectedValue.Trim().Trim();
objEWA.PreviousRollNo = txt_PreviousRollNo.Text.Trim();
objEWA.FeesCategory = ddl_FeesCategory.SelectedItem.ToString().Trim();
objEWA.CasteCategory = ddl_CasteCategory.SelectedValue.Trim();
// Panel 2
objEWA.FirstName = txt_FirstName.Text.Trim();
objEWA.MiddleName = txt_MiddleName.Text.Trim();
objEWA.LastName = txt_LastName.Text.Trim();
objEWA.Gender1 = rbt_Gender.SelectedItem.ToString();
System.Data.SqlTypes.SqlDateTime birthdate = System.Data.SqlTypes.SqlDateTime.Parse(txt_BirthDate.Text);
// DateTime birthdate = DateTime.ParseExact(txt_BirthDate.Text, "yyyy-MM-dd", CultureInfo.InvariantCulture);
DateTime datetime = Convert.ToDateTime(txt_BirthDate.Text);
objEWA.BirthDate = datetime.ToString();
objEWA.BirthPlace = txt_BirthPlace.Text.Trim();
objEWA.AddressLine1 = txt_Address1.Text.Trim();
objEWA.AddressLine2 = txt_Address2.Text.Trim();
objEWA.Country1 = ddl_Country.SelectedValue.ToString();
objEWA.State1 = ddl_State.SelectedValue.ToString();
objEWA.District1 = ddl_District.SelectedValue.ToString();
objEWA.Taluka1 = TxtTaluka.Text.Trim();
objEWA.City1 = TxtCity.Text.Trim();
if (txt_Pincode.Text != string.Empty)
{
objEWA.PinCode1 = Convert.ToInt32(txt_Pincode.Text);
}
objEWA.MarriedStatus = rbt_MarriedStatus.SelectedValue.ToString();
objEWA.MobileNo = txt_PersonalMobile.Text.Trim();
objEWA.E_Mail = txt_Email.Text.Trim();
objEWA.Nationality1 = DDL_Nationality.SelectedValue.ToString();
objEWA.BloodGroup = ddl_BloodGroup.SelectedValue.ToString();
objEWA.Handicaped = ddl_Handicap.SelectedValue.ToString();
objEWA.Conveyanceuse = ddl_ConveyanceUse.SelectedValue.ToString();
objEWA.Religion1 = ddl_Religion.SelectedValue.ToString();
objEWA.Caste1 = ddl_Caste.SelectedItem.ToString();
objEWA.Subcaste = txtSubcast.Text.Trim();
objEWA.SportId = DDL_Sports.SelectedValue.ToString();
objEWA.AdharNo = DDL_SportLevel.SelectedItem.ToString();
// Panel 3
objEWA.GuardianName = txt_GuardianName.Text.ToString();
objEWA.Relation1 = ddl_Relation.SelectedItem.ToString();
objEWA.GuardianAddress1 = txt_GuardianAddress1.Text.ToString().Trim();
objEWA.GuardianAddress2 = txt_GuardianAddress2.Text.ToString().Trim();
objEWA.GuardianCountry = ddl_GuardianCountry.SelectedItem.ToString().Trim();
objEWA.GuardianState = ddl_GuardianState.SelectedItem.ToString();
objEWA.GuardianDistrict = ddl_GuardianDistrict.SelectedItem.ToString();
objEWA.GuardianTaluka = txtGuardianTaluka.Text.ToString().Trim();
objEWA.GuardianCity = txtGuardianCity.Text;
if (txt_GuardianPincode.Text != string.Empty)
{
objEWA.GuardianPinCode = Convert.ToInt32(txt_GuardianPincode.Text);
}
objEWA.GuardianMobile = txt_GuardianMobile.Text.Trim();
objEWA.GuardianEmail = txt_GuardianEmail.Text.Trim();
// Panel Parent information
objEWA.ParentName = txt_ParentName.Text.Trim();
objEWA.MotherName = txt_MotherName.Text.Trim();
objEWA.ParentAddress1 = txt_ParentAddress1.Text.Trim();
objEWA.ParentAddress2 = txt_ParentAddress2.Text.Trim();
objEWA.ParentCountry = ddl_ParentCountry.SelectedItem.ToString();
objEWA.ParentState = ddl_ParentState.SelectedItem.ToString();
objEWA.ParentTaluka = txt_ParentCity.Text.ToString().Trim();
if (txt_ParentPincode.Text != string.Empty)
{
objEWA.ParentPinCode = Convert.ToInt32(txt_ParentPincode.Text);
}
objEWA.ParentMobile = txt_PersonalMobile.Text.Trim();
objEWA.ParentEmail = txt_ParentEmail.Text.Trim();
// Panel Last Instituter information
objEWA.LastClass = txt_LastAttendedClass.Text.Trim();
objEWA.ResidentType = ddl_ResidentType.SelectedItem.ToString();
objEWA.LastInstitute = txt_LastAttendedClass.Text.Trim();
objEWA.PassingMonth = ddl_LastExamPassingMonth.SelectedValue.ToString();
objEWA.PassingYear = ddl_LastExamPassingYear.SelectedItem.ToString();
objEWA.Result1 = txt_Result.Text.Trim();
objEWA.Percentage1 = txt_Percentage.Text.Trim();
objEWA.Gap1 = ddl_Gap.SelectedItem.ToString();
objEWA.TcNo = txt_TcNo.Text.Trim();
objEWA.BankName = txtBankName.Text.Trim();
if (txt_AccountNo.Text != string.Empty)
{
objEWA.AccountNo = txt_AccountNo.Text.ToString().Trim();
}
objEWA.Branch1 = txt_BranchName.Text.Trim();
objEWA.IFSCCode = txt_IFSCCode.Text.Trim();
objEWA.StudentUserName = txt_UserName.Text.Trim();
objEWA.StudentPassword = txt_Password.Text.Trim();
// Iamage Store
int length = 0;
byte[] imgSignbyte = null;
byte[] imgPhotobyte = null;
if (fileupload_StudentPhoto.HasFile)
{
length = fileupload_StudentPhoto.PostedFile.ContentLength;
imgPhotobyte = new byte[length];
HttpPostedFile img1 = fileupload_StudentPhoto.PostedFile;
img1.InputStream.Read(imgPhotobyte, 0, length);
ViewState["StudentPhoto"] = imgPhotobyte;
}
objEWA.StudentPhoto = (byte[])ViewState["StudentPhoto"];;
if (fileupload_StudentSign.HasFile)
{
length = fileupload_StudentSign.PostedFile.ContentLength;
imgSignbyte = new byte[length];
HttpPostedFile img1 = fileupload_StudentSign.PostedFile;
img1.InputStream.Read(imgSignbyte, 0, length);
ViewState["StudentSign"] = imgSignbyte;
}
//objEWA.StudentSign = (byte[])ViewState["StudentSign"];
objEWA.StudentUserName = txt_UserName.Text;
objEWA.StudentPassword = txt_Password.Text;
objEWA.Status = "Pending";
int flag = objBAL.InsertInto(objEWA);
if (flag > 0)
{
if (strAction == "Save")
{
msgBox.ShowMessage("Form Sumitted Successfully Check Your Mail !!!", "Saved", UserControls.MessageBox.MessageStyle.Successfull);
string strSMS = null;
string strEmail = null;
msgBox.ShowMessage(strSMS, "Saved", UserControls.MessageBox.MessageStyle.Successfull);
strEmail = SendEmails();
msgBox.ShowMessage(strEmail, "Saved", UserControls.MessageBox.MessageStyle.Successfull);
Response.Redirect("~/College_Home.aspx");
}
else if (strAction == "Update")
{
msgBox.ShowMessage("Record Updated Successfully !!!", "Updated", UserControls.MessageBox.MessageStyle.Successfull);
}
else if (strAction == "Delete")
{
msgBox.ShowMessage("Record Deleted Successfully !!!", "Deleted", UserControls.MessageBox.MessageStyle.Successfull);
}
}
}
catch (Exception)
{
throw;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (TxtFirstName.Text == "" || TxtFirstName.Text == string.Empty)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Information", "alert('please Enter Child First Name')", true);
TxtFirstName.Focus();
return;
}
if (TxtLastName.Text == "" || TxtLastName.Text == string.Empty)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Information", "alert('please Enter Child Last Name')", true);
TxtLastName.Focus();
return;
}
if (TxtMiddleName.Text == "" || TxtMiddleName.Text == string.Empty)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Information", "alert('please Enter Child Middle Name')", true);
TxtMiddleName.Focus();
return;
}
if (TxtDOB.Text == "" || TxtDOB.Text == string.Empty)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Information", "alert('please Enter Child Date Of Birth')", true);
TxtMiddleName.Focus();
return;
}
if (TxtAdmissionDate.Text == "" || TxtAdmissionDate.Text == string.Empty)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Information", "alert('please Enter Enquiry Date for Admission ')", true);
TxtAdmissionDate.Focus();
return;
}
if (TxtAddress.Text == "" || TxtAddress.Text == string.Empty)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Information", "alert('please Enter Address')", true);
TxtAddress.Focus();
return;
}
if (TxtStandard.Text == "" || TxtStandard.Text == string.Empty)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Information", "alert('please Enter Child Standard')", true);
TxtStandard.Focus();
return;
}
if (TxtWhatsupNumber.Text == "" || TxtWhatsupNumber.Text == string.Empty)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Information", "alert('please Enter Whats app Number For Contact')", true);
TxtWhatsupNumber.Focus();
return;
}
EWA_Admission objEWA = new EWA_Admission();
BL_Admission objBAL = new BL_Admission();
objEWA.FirstName = TxtFirstName.Text;
objEWA.LastName = TxtLastName.Text;
objEWA.MiddleName = TxtMiddleName.Text;
objEWA.ParentEmail = TxtEmail.Text;
objEWA.MobileNo = TxtWhatsupNumber.Text;
objEWA.BirthDate = TxtDOB.Text;
objEWA.ApplicationDate = TxtAdmissionDate.Text;
objEWA.Branch1 = TxtStandard.Text;
objEWA.AddressLine1 = TxtAddress.Text;
int flag = objBAL.InsertEnquiryInfo(objEWA);
if (flag > 0)
{
Clear();
msgBox.ShowMessage("Form Submitted Successfully", "Saved", UserControls.MessageBox.MessageStyle.Successfull);
}
else
{
msgBox.ShowMessage("Some Problem Occured....", "Critical", UserControls.MessageBox.MessageStyle.Critical);
}
}
private void UpgradeAcademicyear(string strAction)
{
try
{
EWA_Admission objEWA = new EWA_Admission();
BL_Admission objBAL = new BL_Admission();
int Userid = Convert.ToInt32(Session["UserCode"]);
var count = GrdStudent.Rows.Count;
string[] AdmissionID = new string[count];
int i = 0;
int oldOrgId = Convert.ToInt32(Session["OrgId"].ToString());
foreach (GridViewRow gvrow in GrdStudent.Rows)
{
CheckBox chk = (CheckBox)gvrow.FindControl("chkbox");
if (chk != null && chk.Checked)
{
Label addmissionId = (Label)gvrow.FindControl("lbladdmissionid");
Label UserCode = (Label)gvrow.FindControl("lblUserCode");
Label Branch = (Label)gvrow.FindControl("lblBranch");
Label Class = (Label)gvrow.FindControl("LblClass");
Label AcademicYear = (Label)gvrow.FindControl("LblAcademicID");
string _drpcourse = drpcourse.SelectedValue;
string _drpbranch = drpbranch.SelectedValue;
string _drpclass = drpclass.SelectedValue;
float castcatergoryid = db.getDb_Value(" select feescategory FROM tbladmissiondetails WHERE admissionid='" + addmissionId.Text + "' and OrgID='" + oldOrgId + "' ");
float AcademicYearId = db.getDb_Value("SELECT AcademicYearId FROM tblStudent WHERE (UserCode = '" + UserCode.Text + "') and OrgID='" + oldOrgId + "' ");
float fessid = 0;
float FeesDetailsid = 0;
string FeesParticular;
float TotalAmt = 0;
DateTime currentDate = System.DateTime.Now.Date;
fessid = db.getDb_Value("SELECT top(1) dbo.tblFeesDetails.FeesId FROM dbo.tblFees INNER JOIN dbo.tblFeesDetails ON dbo.tblFees.FeesId = dbo.tblFeesDetails.FeesId where AcademicYearId='" + drpacedemicyear1.SelectedValue + "' and CourseId='" + _drpcourse + "' and BranchId='" + _drpbranch + "' and ClassId='" + _drpclass + "' and CasteCategoryId='" + castcatergoryid.ToString() + "' ");
FeesDetailsid = db.getDb_Value("SELECT top(1) dbo.tblFeesDetails.FeesDetailsId FROM dbo.tblFees INNER JOIN dbo.tblFeesDetails ON dbo.tblFees.FeesId = dbo.tblFeesDetails.FeesId where AcademicYearId='" + drpacedemicyear1.SelectedValue + "' and CourseId='" + _drpcourse + "' and BranchId='" + _drpbranch + "' and ClassId='" + _drpclass + "' and CasteCategoryId='" + castcatergoryid.ToString() + "' ");
if (fessid > 0)
{
DataTable dt = new DataTable();
cn.Close();
cn.Open();
using (SqlCommand cmd = new SqlCommand("SELECT top(1) dbo.tblFeesDetails.Particular FROM dbo.tblFees INNER JOIN dbo.tblFeesDetails ON dbo.tblFees.FeesId = dbo.tblFeesDetails.FeesId where AcademicYearId='" + drpacedemicyear1.SelectedValue + "' and CourseId='" + _drpcourse + "' and BranchId='" + _drpbranch + "' and ClassId='" + _drpclass + "' and CasteCategoryId='" + castcatergoryid.ToString() + "'", cn))
{
cmd.CommandType = CommandType.Text;
cmd.Connection = cn;
SqlDataReader dr = cmd.ExecuteReader();
dt.Load(dr);
FeesParticular = dt.Rows[0]["Particular"].ToString();
}
TotalAmt = db.getDb_Value("select sum(Amount) as TotalAmount from tblFeesDetails where FeesId='" + Convert.ToInt32(fessid) + "' ");
Shwmsg.Visible = false;
BtnAddFees.Visible = false;
}
else
{
Shwmsg.Visible = true;
Shwmsg.Text = "Please Add Fees For This Class";
BtnAddFees.Visible = true;
return;
}
float reciptno = db.getDb_Value("SELECT Max(ReceiptNo) FROM tblStudentFeesPaid where StudentId='" + UserCode.Text + "'");
db.insert("update tblAdmissionDetails set CourseId='" + _drpcourse + "', BranchId='" + _drpbranch + "', ClassId='" + _drpclass + "' where AdmissionID='" + addmissionId.Text + "' ");
db.insert("update tblStudent_Details set AcademicYearId=" + drpacedemicyear1.SelectedValue + " where AdmissionID='" + addmissionId.Text + "' ");
db.insert("update [dbo].[tblStudentFeesPaid] set StudentId='" + UserCode.Text + "',FeesId='" + Convert.ToInt32(fessid) + "',TotalAmount='" + Convert.ToInt32(TotalAmt) + "',PaidAmount=0,PendingAmount='" + Convert.ToInt32(TotalAmt) + "',UserId= '" + Convert.ToInt32(Userid) + "',TransDate= '" + currentDate + "',remark= '" + FeesParticular.ToString() + "',FeesDetailsId= '" + Convert.ToInt32(FeesDetailsid) + "' where StudentId ='" + UserCode.Text + "' and GroupReceiptNo=0 ");
objEWA.OrgID = Convert.ToInt32(Session["OrgId"].ToString());
objEWA.student_Code = UserCode.Text;
objEWA.CourseId = ddlCourse.SelectedValue;
objEWA.Branch_ID = Convert.ToInt32(Branch.Text);
objEWA.ClassId = Class.Text;
objEWA.AcademicYearID = AcademicYear.Text;
objEWA.PinCode1 = Convert.ToInt32(Userid);
string StatusSave = objBAL.SaveStudentFeesHistrory(objEWA);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", "alert('Student Promoted Successfully ..!!');window.location='NextAcademicYearSpecial.aspx';", true);
}
}
dvBranch = null;
dvClass = null;
dvStudentData = null;
dvdrpBranch = null;
dvdrpClass = null;
dvdrpStudentData = null;
GrdStudent.DataSource = null;
GrdStudent.DataBind();
BindCourse();
GetStudentData();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", "alert('SomeThing Is Wrong..!!');window.location='NextAcademicYearSpecial.aspx';", true);
}
catch (Exception)
{
throw;
}
}
//
//Added by Ashwini 30-sep-2020
public DataSet InsertPromoteStudentData(EWA_Admission ObjEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[10];
prmList[0] = "@OrgID";
prmList[1] = ObjEWA.OrgID.ToString();
prmList[2] = "@ApplicationDate";
prmList[3] = ObjEWA.ApplicationDate.ToString();
prmList[4] = "@AdmissionType";
prmList[5] = ObjEWA.AdmissionType.ToString();
prmList[6] = "@CourseId";
prmList[7] = ObjEWA.CourseId.ToString();
prmList[8] = "@ClassId";
prmList[9] = ObjEWA.ClassId.ToString();
prmList[10] = "@BranchId";
prmList[11] = ObjEWA.Branch_ID.ToString();
prmList[12] = "@FeesCategory";
prmList[13] = ObjEWA.FeesCategory.ToString();
prmList[14] = "@CasteCategoryId";
prmList[15] = ObjEWA.CasteCategoryId.ToString();
prmList[16] = "@FirstName";
prmList[17] = ObjEWA.FirstName.ToString();
prmList[18] = "@MiddleName";
prmList[19] = ObjEWA.MiddleName.ToString();
prmList[20] = "@LastName";
prmList[21] = ObjEWA.LastName.ToString();
prmList[22] = "@Gender";
prmList[23] = ObjEWA.Gender1.ToString();
prmList[24] = "@BirthDate";
prmList[25] = ObjEWA.BirthDate.ToString();
prmList[26] = "@BirthPlace";
prmList[27] = ObjEWA.BirthPlace.ToString();
prmList[28] = "@Address1";
prmList[29] = ObjEWA.AddressLine1.ToString();
prmList[30] = "@Address2";
prmList[31] = ObjEWA.AddressLine2.ToString();
prmList[32] = "@Country";
prmList[33] = ObjEWA.Country1.ToString();
prmList[34] = "@State";
prmList[35] = ObjEWA.State1.ToString();
prmList[36] = "@District";
prmList[37] = ObjEWA.District1.ToString();
prmList[38] = "@Taluka";
prmList[39] = ObjEWA.Taluka1.ToString();
prmList[40] = "@City";
prmList[41] = ObjEWA.City1.ToString();
prmList[42] = "@Pin_Code";
prmList[43] = ObjEWA.PinCode1.ToString();
prmList[44] = "@Mobile";
prmList[45] = ObjEWA.MobileNo.ToString();
prmList[46] = "@EMail";
prmList[47] = ObjEWA.E_Mail.ToString();
prmList[48] = "@Nationality";
prmList[49] = ObjEWA.Nationality1.ToString();
prmList[50] = "@BloodGroup";
prmList[51] = ObjEWA.BloodGroup.ToString();
prmList[52] = "@Handicap";
prmList[53] = ObjEWA.Handicaped.ToString();
prmList[54] = "@AdharNo";
prmList[55] = ObjEWA.AdharNo.ToString();
prmList[56] = "@Religion";
prmList[57] = ObjEWA.Religion1.ToString();
prmList[58] = "@SubCaste";
prmList[59] = ObjEWA.Subcaste.ToString();
prmList[60] = "@ParentName";
prmList[61] = ObjEWA.ParentName.ToString();
prmList[62] = "@Relation";
prmList[63] = ObjEWA.Relation1.ToString();
prmList[64] = "@LastInstitute";
prmList[65] = ObjEWA.LastInstitute.ToString();
prmList[66] = "@Photo";
prmList[67] = ObjEWA.Photo1.ToString();
prmList[68] = "@QualifiedExam";
prmList[69] = ObjEWA.QualifiedExam.ToString();
prmList[70] = "@Status";
prmList[71] = ObjEWA.Status.ToString();
prmList[72] = "@GRNo";
prmList[73] = ObjEWA.GRNo.ToString();
prmList[74] = "@MotherTongue";
prmList[75] = ObjEWA.MotherTongue.ToString();
prmList[76] = "@AdmissionDate";
prmList[77] = ObjEWA.AdmissionDate.ToString();
prmList[78] = "@RollNo";
prmList[79] = ObjEWA.PreviousRollNo.ToString();
prmList[80] = "@SaralId";
prmList[81] = ObjEWA.SaralId.ToString();
prmList[82] = "@MotherName";
prmList[83] = ObjEWA.MotherName.ToString();
ds = ObjHelper.FillControl(prmList, "ssp_SavePromoteStudentOverOrg");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
