protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string applicationID = Request.QueryString["ApplicationID"].ToString();
// ScriptManager.RegisterStartupScript(this.Page, GetType(), "ClosePopup", "alertNew('Application Submitted Successfully !','0');", true);
DatabaseFunctions db = new DatabaseFunctions();
db.updateApplicationStatus_Submit(Convert.ToInt32(applicationID));
DataSet appData = db.getApplication_ID((applicationID));
if (appData != null)
{
int programID = Convert.ToInt32(appData.Tables[0].Rows[0]["ProgramID"].ToString());
DataSet pDate = db.getProgramByID(programID);
if (pDate.Tables[0].Rows.Count > 0)
{
int instantadmission = Convert.ToInt16(pDate.Tables[0].Rows[0]["InstantAdmission"].ToString());
if (instantadmission == 1)
{
string programName = appData.Tables[0].Rows[0]["programName"].ToString();
string CourseName = appData.Tables[0].Rows[0]["Course1"].ToString();
string campus = appData.Tables[0].Rows[0]["Campus"].ToString();
string regno = appData.Tables[0].Rows[0]["formnumber"].ToString();
db.insertInstantAdmissiondata(regno, programName, CourseName, campus);
//db.AssignAcceptanceFee()
ScriptManager.RegisterStartupScript(this.Page, GetType(), "ClosePopup2", "alertNew('You have been successfully awarded admission !','0');", true);
DatabaseFunctions d = new DatabaseFunctions();
d.AssignAcceptanceFee(StudentID, programID, 0);
///// Generate acceptance fee and send a message.
d.InsertIntoStudentInfoTableNew(programID, "ND1", StudentID, 0, 1, "0", DateTime.Now.Year.ToString());
int BatchID = d.GetBatchID(DateTime.Now.Year.ToString());
string matricno=DateTime.Now.Year+"-"+programName+"-"+StudentID;
d.InsertIntoAddmissionTableNew(programID, StudentID, 0, "Merit", matricno, BatchID);
double AcceptanceFee = d.GetAcceptanceFeeForProgram(programID);
///// Update Admission Status to 1 .
///// Insert Values to StudentInfo_tbl and AddmissionList (New One)
if(AcceptanceFee!=-1)
{
string Message = "Acceptence Fee Of " +AcceptanceFee+ " Has Been Assigned to You <br> Please Submit This Fees with in One Week";
d.SendMessage(StudentID, Message, "Acceptance Fee", 0);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, GetType(), "ClosePopup", "alertNew('Application Submitted Successfully !','0');", true);
}
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, GetType(), "ClosePopup", "alertNew('Error Submiting Application!','1');", true);
}
}
public void formPreview()
{
btnSave.Visible = false;
btnNext.Visible = false;
btnPrevious.Visible = false;
btnPreview.Visible = false;
DataSet ds = new DataSet();
DatabaseFunctions db = new DatabaseFunctions();
ds = db.getProgramIDbyApplicationID(Convert.ToInt32(Request.QueryString["ApplicationID"].ToString()));
if (ds.Tables[0].Rows.Count > 0)
{
int JambForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasJambData"].ToString()); //1
int BioForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasBioDataSection"].ToString());//2
int OlevelForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasOlevelResult"].ToString());//3
int PreviousRecordForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasPreviousRecord"].ToString());//4
int CbtScheduleForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasCBTSchedule"].ToString());//5
if (OlevelForm == 0)
{
HasOlevelResult.Visible = false;
}
if (PreviousRecordForm == 0)
{
panelpreview_PreviousRecord.Visible = false;
}
if (CbtScheduleForm == 0)
{
HasCBTSchedule.Visible = false;
}
}
string previousColName = ViewState["CurrentPanelName"].ToString();
Panel panelprev = this.Master.FindControl("ContentPlaceHolder1").FindControl(previousColName) as Panel;
if (panelprev != null)
{
panelprev.Visible = false;
}
panelPreview.Visible = true;
ds = new DataSet();
ds = db.getAlluserRelatedInfo((Membership.GetUser().ProviderUserKey.ToString()));
if (ds.Tables[0].Rows.Count > 0)
{
string programName = string.Empty;
string img = ds.Tables[0].Rows[0]["profilepic"].ToString();
string course = string.Empty;
if (img != "")
{
imgDp.Src = "profilepics/" + img.ToString(); ;
imgDp.Visible = true;
}
else
{
imgDp.Visible = false;
}
DataSet pgName = db.getProgramByID(Convert.ToInt32(ViewState["programID"]));
if (pgName.Tables[0].Rows.Count > 0)
{
programName = pgName.Tables[0].Rows[0]["ProgramName"].ToString();
}
lblSuname.Text = ds.Tables[0].Rows[0]["surname"].ToString();
lblFname.Text = ds.Tables[0].Rows[0]["firstname"].ToString();
lblOtherName.Text = ds.Tables[0].Rows[0]["othername"].ToString();
lblGender.Text = ds.Tables[0].Rows[0]["gender"].ToString();
lblPhonenum.Text = ds.Tables[0].Rows[0]["phonenumber"].ToString();
lblProgram.Text = programName;
lblCourse.Text = db.getApplication_Courses(Convert.ToInt32(ViewState["programID"]), Convert.ToInt32(Request.QueryString["ApplicationID"]));
lblstateoforigin.Text = ds.Tables[0].Rows[0]["statenew"].ToString();
lblLocalGotArea.Text = ds.Tables[0].Rows[0]["govtnew"].ToString();
lblJambRegno.Text = ds.Tables[0].Rows[0]["JAMBRegno"].ToString();
lblJambExamyear.Text = ds.Tables[0].Rows[0]["JambExamyear"].ToString();
lblJambFullName.Text = ds.Tables[0].Rows[0]["JambFullName"].ToString();
lblInstitutionAttended.Text = ds.Tables[0].Rows[0]["institutionNew"].ToString();
lblCourseName.Text = ds.Tables[0].Rows[0]["CourseName"].ToString();
courseType.Text = ds.Tables[0].Rows[0]["CourseType"].ToString();
lblCourseGrade.Text = ds.Tables[0].Rows[0]["CourseGrade"].ToString();
yearCompleted.Text = ds.Tables[0].Rows[0]["YearCompleted"].ToString();
lblIndustrialStart.Text = ds.Tables[0].Rows[0]["IndTrainingStart"].ToString();
lblIndustrialEnd.Text = ds.Tables[0].Rows[0]["IndTrainingEnd"].ToString();
lblCbtSchedule.Text = ds.Tables[0].Rows[0]["ScheduleDate"].ToString() + ", " + ds.Tables[0].Rows[0]["ScheduleTime"].ToString();
labelCbtUser.Text = ds.Tables[0].Rows[0]["CbtUserName"].ToString();
lblCbtPass.Text = ds.Tables[0].Rows[0]["CbtPassword"].ToString();
lblRegistrationNum.Text = ViewState["formnum"].ToString(); ;
}
}
