public int GetApprovalCount()
{
HttpClient hclient = new HttpClient();
hclient.BaseAddress = new Uri(DataAcces.Url);
hclient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
objPlSecondLevel = new PL_SecondLevel();
var uri = string.Format("api/SecondLevel/GetApprovalCount/?ind={0}&applicationid={1}&isconfirm={2}&doctype={3}", 4, lngapplicationId, 1, DocTypeID);
var response = hclient.GetAsync(uri).Result;
var getdata = response.Content.ReadAsAsync <IEnumerable <PL_SecondLevel> >().Result;
if (getdata.Count() > 0)
{
foreach (var a in getdata)
{
acnt = Convert.ToInt32(a.acnt);
}
}
else
{
acnt = 0;
}
getdata = null; response = null; uri = null;
return(acnt);
}
protected void btnCorrection_Click(object sender, EventArgs e)
{
lblCancelSuccessMSG.Text = "";
HttpClient HClient = new HttpClient();
HClient.BaseAddress = new Uri(DataAcces.Url);
HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
objPlSecondLevel = new PL_SecondLevel();
objPlSecondLevel.Ind = 1;
objPlSecondLevel.ApplicationID = Convert.ToInt32(ApplicatioID);
objPlSecondLevel.Rollno = txtRollNo.Text;
objPlSecondLevel.SName = txtStudentName.Text;
objPlSecondLevel.ExamName = txtExamName.Text;
objPlSecondLevel.BranchName = txtBranchName.Text;
objPlSecondLevel.ExamSession = Convert.ToString(0);
objPlSecondLevel.EnrollmentNo = txtEnrollmentlNo.Text;
objPlSecondLevel.College = txtCollege.Text;
objPlSecondLevel.CGPA = txtCGPA.Text;
objPlSecondLevel.Division = txtDivision.Text;
objPlSecondLevel.UserID = Session["UserId"].ToString();
objPlSecondLevel.EntryByIP = (IpAddress = GetIpAddress());
var uri = "api/SecondLevel/PostCorrectionRecord";
var response = HClient.PostAsJsonAsync(uri, objPlSecondLevel).Result;
if (response.IsSuccessStatusCode)
{
var getdata = response.Content.ReadAsAsync <IEnumerable <PL_SecondLevel> >().Result;
if (getdata != null)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Notify", "alert('Data Send to Correction.');window.location='FrmZeroLevel.aspx';", true);
}
getdata = null;
}
response = null; uri = null;
}
protected void btnReject_Click1(object sender, EventArgs e)
{
lblCancelSuccessMSG.Text = "";
HttpClient HClient = new HttpClient();
HClient.BaseAddress = new Uri(DataAcces.Url);
HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
objPlSecondLevel = new PL_SecondLevel();
objPlSecondLevel.Ind = 1;
objPlSecondLevel.ApplicationID = Convert.ToInt32(ApplicatioID);
objPlSecondLevel.Rollno = txtRollNo.Text;
objPlSecondLevel.SName = txtStudentName.Text;
objPlSecondLevel.ExamName = txtExamName.Text;
objPlSecondLevel.BranchName = txtBranchName.Text;
objPlSecondLevel.ExamSession = Convert.ToString(0);
objPlSecondLevel.EnrollmentNo = txtEnrollmentlNo.Text;
objPlSecondLevel.College = txtCollege.Text;
objPlSecondLevel.CGPA = txtCGPA.Text;
objPlSecondLevel.Division = txtDivision.Text;
objPlSecondLevel.UserID = Session["UserId"].ToString();
objPlSecondLevel.EntryByIP = (IpAddress = GetIpAddress());
var uri = "api/SecondLevel/PostRejectionRecord";
var response = HClient.PostAsJsonAsync(uri, objPlSecondLevel).Result;
if (response.IsSuccessStatusCode)
{
var getdata = response.Content.ReadAsAsync <IEnumerable <PL_SecondLevel> >().Result;
if (getdata != null)
{
lblmsg.Text = "Mission Success";
}
getdata = null;
}
response = null; uri = null;
}
public DataTable ShowExamDetail(int Ind, string Rollno, string ExamYear, int OccCtrl, string ExamSession)
{
PL_SecondLevel pl = new PL_SecondLevel();
pl.Ind = Ind;
pl.Rollno = Rollno;
pl.ExamYear = ExamYear;
pl.OccCtrl = OccCtrl;
pl.ExamSession = ExamSession;
return(objDlSecondlevel.ShowExamDetail(pl));
}
public DataTable ShowExamDetail(PL_SecondLevel plSecondLevel)
{
cmd = new SqlCommand("SPApplicationDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", plSecondLevel.Ind);
cmd.Parameters.AddWithValue("@Rollno", Convert.ToInt32(plSecondLevel.Rollno));
cmd.Parameters.AddWithValue("@ExamYear", Convert.ToInt32(plSecondLevel.ExamYear));
cmd.Parameters.AddWithValue("@OccCtrl", Convert.ToInt32(plSecondLevel.OccCtrl));
cmd.Parameters.AddWithValue("@ExamSession", Convert.ToInt32(plSecondLevel.ExamSession));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable SubmitCorrection(PL_SecondLevel pl)
{
DataTable dt = new DataTable();
try
{
SqlCommand cmd = new SqlCommand("SPApplicationEntry", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@IsConfirmed", false);
cmd.Parameters.AddWithValue("@IsRejected", false);
cmd.Parameters.AddWithValue("@IsCorrectionReqd", true);
con.Open();
int i = Convert.ToInt16(cmd.ExecuteScalar());
con.Close();
if (i > 0)
{
SqlCommand cmd1 = new SqlCommand("SPApplicationEntry", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@Ind", 2);
cmd1.Parameters.AddWithValue("@ApplicationID", pl.ApplicationID);
cmd1.Parameters.AddWithValue("@DocType", pl.DocTypeID);
cmd1.Parameters.AddWithValue("@LevelID", pl.UserID);
cmd1.Parameters.AddWithValue("@LevelRemark", "");
cmd1.Parameters.AddWithValue("@EntryByIP", pl.EntryByIP);
cmd1.Parameters.AddWithValue("@ApprovalCount", 1);
cmd1.Parameters.AddWithValue("@MaxApproval", pl.maxaproval);
cmd1.Parameters.AddWithValue("@RecordID", i);
cmd1.Parameters.AddWithValue("@IsConfirmed", false);
cmd1.Parameters.AddWithValue("@IsRejected", false);
cmd1.Parameters.AddWithValue("@IsCorrectionReqd", true);
da = new SqlDataAdapter(cmd1);
con.Close();
da.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
// return dt;
}
else
{
dt = null;
}
}
}
catch (Exception ex)
{ msg = ex.Message; }
return(dt);
}
public DataTable ShowExamDetail(PL_SecondLevel pl)
{
HttpClient hclint = new HttpClient();
hclint.BaseAddress = new Uri(DataAcces.Url);
hclint.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("Application/Json"));
dt = new DataTable();
var uri = string.Format("api/SecondLevel/ShowExamDetail?Ind={0}&Rollno={1}&ExamYear={2}&OccCtrl={3}&ExamSession={4}", pl.Ind, pl.Rollno, pl.ExamYear, pl.OccCtrl, pl.ExamSession);
var response = hclint.PostAsJsonAsync(uri, objPlSecondLevel).Result;
if (response.IsSuccessStatusCode)
{
dt = response.Content.ReadAsAsync <DataTable>().Result;
}
return(dt);
}
public DataTable GetLevelRemark(PL_SecondLevel pl)
{
try
{
cmd = new SqlCommand("SPApplicationEntry", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@ApplicationID", pl.ApplicationID);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
}
catch (Exception ex)
{ msg = ex.Message; }
return(dt);
}
//For DL for Pending and Complete Data Grid for Level id >2 (3 to 7)
public DataSet GetAppDetail(PL_SecondLevel pl)
{
try
{
cmd = new SqlCommand("SPApplicationDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@levelid", pl.levelid);
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
}
catch (Exception ex)
{ msg = ex.Message; }
return(ds);
}
public int GetRecordId()
{
HttpClient hclient = new HttpClient();
hclient.BaseAddress = new Uri(DataAcces.Url);
hclient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
objPlSecondLevel = new PL_SecondLevel();
var uri = string.Format("api/SecondLevel/GetRecordId/?Ind={0}&ApplicationId={1}", 3, lngapplicationId);
var response = hclient.GetAsync(uri).Result;
var getdata = response.Content.ReadAsAsync <IEnumerable <PL_SecondLevel> >().Result;
foreach (var a in getdata)
{
lngRecordId = a.recordId;
}
return(lngRecordId);
}
public DataTable PostCorrectionRecord(PL_SecondLevel objplSecondLevel)
{
objPlSecondlevel.dt = objDlSecondlevel.SubmitCorrection(objplSecondLevel);
return(objPlSecondlevel.dt);
}
protected async void grdPandingDetails_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "ShowPopup")
{
j = Convert.ToInt32(Session["UserTypeId"]);
pnlform.Visible = true;
pnlform.Enabled = false;
lnkSubmit.Visible = false;
LinkButton btndetails = (LinkButton)e.CommandSource;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
int rwindex = gvrow.RowIndex;
dt = new DataTable();
dt = (DataTable)Session["PendingPopup"];
if (dt.Rows.Count > 0)
{
lblEntry.Text = "Applied For : " + dt.Rows[rwindex]["AppliedFor"].ToString().ToUpper();
ApprovalCount = 0;
txtRollNo.Text = dt.Rows[rwindex]["RollNo"].ToString();
txtStudentName.Text = dt.Rows[rwindex]["StudentName"].ToString().ToUpper();
ApplicatioID = Convert.ToInt64(dt.Rows[rwindex]["ApplicationID"].ToString());
lblappno.Text = Convert.ToString(ApplicatioID);
lngapplicationId = Convert.ToInt32(dt.Rows[rwindex]["ApplicationID"].ToString());
DocTypeID = Convert.ToInt32(dt.Rows[rwindex]["DocTypeID"].ToString());
//txtExamSession.Text = dt.Rows[rwindex]["ExamSession"].ToString();
if ((dt.Rows[rwindex]["ExamSession"].ToString() == "SUMMER") || (dt.Rows[rwindex]["ExamSession"].ToString() == "2"))
{
txtExamSession.Text = "SUMMER";
}
else if ((dt.Rows[rwindex]["ExamSession"].ToString() == "WINTER") || (dt.Rows[rwindex]["ExamSession"].ToString() == "1"))
{
txtExamSession.Text = "WINTER";
}
txtExamYear.Text = dt.Rows[rwindex]["ExamYear"].ToString().ToUpper();
HideFoil.ImageUrl = dt.Rows[rwindex]["PartAImagePath"].ToString().ToUpper();
HideCF.ImageUrl = dt.Rows[rwindex]["PartBImagePath"].ToString().ToUpper();
ImageFoil.ImageUrl = dt.Rows[rwindex]["PartAImagePath"].ToString().ToUpper();
ImageCF.ImageUrl = dt.Rows[rwindex]["PartBImagePath"].ToString().ToUpper();
txtBranchName.Text = dt.Rows[rwindex]["ExamBranch"].ToString().ToUpper();
ImageCF.Width = 400;
objPlSecondLevel.Ind = 11;
objPlSecondLevel.Rollno = dt.Rows[rwindex]["RollNo"].ToString();
objPlSecondLevel.ExamYear = dt.Rows[rwindex]["ExamYear"].ToString();
objPlSecondLevel.OccCtrl = 0;
if (dt.Rows[rwindex]["ExamSession"].ToString() == "SUMMER")
{
objPlSecondLevel.ExamSession = "2";
}
else if (dt.Rows[rwindex]["ExamSession"].ToString() == "WINTER")
{
objPlSecondLevel.ExamSession = "1";
}
Convert.ToInt32(objPlSecondLevel.Rollno);
Convert.ToInt32(objPlSecondLevel.ExamYear);
Convert.ToInt32(objPlSecondLevel.ExamSession);
txtExamName.Text = dt.Rows[0]["ExamName"].ToString().Trim().ToUpper();
txtExamName.Enabled = true; txtExamSession.Enabled = false; txtExamYear.Enabled = false; txtRollNo.Enabled = false;
trDivision.Visible = trCgpa.Visible = trEnroll.Visible = trCollege.Visible =
trSubjectName.Visible = trDistinctionSub.Visible = trMeritNo.Visible =
trLaterReferenceNo.Visible = trLaterReferenceDate.Visible = trPassingYear.Visible = trExamMedium.Visible =
trAwardedBy.Visible = TrawardPrice.Visible = trResulDeclarationDate.Visible = trRank.Visible = false;
if (DocTypeID == 1)
{
trDivision.Visible = true;
trCgpa.Visible = true;
txtDivision.Text = dt.Rows[rwindex]["Division"].ToString().ToUpper();
txtCGPA.Text = dt.Rows[rwindex]["CGPAPercentage"].ToString().ToUpper();
}
else if (DocTypeID == 2)
{
trEnroll.Visible = true;
trDivision.Visible = true;
trCgpa.Visible = true;
trCollege.Visible = true;
txtDivision.Text = dt.Rows[rwindex]["Division"].ToString().ToUpper();
txtEnrollmentlNo.Text = dt.Rows[rwindex]["EnrollmentNo"].ToString().ToUpper();
txtCollege.Text = dt.Rows[rwindex]["College"].ToString().ToUpper();
txtCGPA.Text = dt.Rows[rwindex]["CGPAPercentage"].ToString();
}
else if (DocTypeID == 3)
{
trEnroll.Visible = true;
trSubjectName.Visible = true;
trDistinctionSub.Visible = true;
txtEnrollmentlNo.Text = dt.Rows[rwindex]["EnrollmentNo"].ToString().ToUpper();
txtSubjectName.Text = dt.Rows[rwindex]["SubjectName"].ToString().ToUpper();
txtDistinctionSub.Text = dt.Rows[rwindex]["DistinctionSubject"].ToString().ToUpper();
}
else if (DocTypeID == 4)
{
trMeritNo.Visible = true;
txtMeritNo.Text = dt.Rows[rwindex]["MeritNo"].ToString().ToUpper();
}
else if (DocTypeID == 6)
{
trDivision.Visible = true;
trMeritNo.Visible = trRank.Visible = trAwardedBy.Visible = TrawardPrice.Visible = true;
txtAwardPrize.Text = dt.Rows[rwindex]["AwardPrize"].ToString();
if (dt.Rows[rwindex]["Ranking"] == "IInd")
{
ddlRank.SelectedIndex = 2;
}
else
{
ddlRank.SelectedIndex = 1;
}
if (dt.Rows[rwindex]["AwardedBy"].ToString() == "Gold Medal")
{
ddlAwardedby.SelectedIndex = 1;
}
else if (dt.Rows[rwindex]["AwardedBy"].ToString() == "Silver Medal")
{
ddlAwardedby.SelectedIndex = 2;
}
else if (dt.Rows[rwindex]["AwardedBy"].ToString() == "Cash Prize")
{
ddlAwardedby.SelectedIndex = 3;
}
txtDivision.Text = dt.Rows[rwindex]["Division"].ToString().ToUpper();
txtMeritNo.Text = dt.Rows[rwindex]["MeritNo"].ToString().ToUpper();
}
else if (DocTypeID == 8)
{
trDivision.Visible = true;
trLaterReferenceNo.Visible = true;
trLaterReferenceDate.Visible = true;
txtDivision.Text = dt.Rows[rwindex]["Division"].ToString().ToUpper();
txtLaterReferenceNo.Text = dt.Rows[rwindex]["LetterRefNo"].ToString().ToUpper();
txtLaterReferenceDate.Text = Convert.ToDateTime(dt.Rows[rwindex]["LetterRefDate"]).ToString("yyyy-MM-dd");
}
else if (DocTypeID == 9)
{
trDivision.Visible = trLaterReferenceNo.Visible =
trLaterReferenceDate.Visible = trPassingYear.Visible = true;
txtDivision.Text = dt.Rows[rwindex]["Division"].ToString().ToUpper();
txtPassingYear.Text = dt.Rows[rwindex]["ExamPassingYear"].ToString().ToUpper();
txtLaterReferenceNo.Text = dt.Rows[rwindex]["LetterRefNo"].ToString().ToUpper();
txtLaterReferenceDate.Text = Convert.ToDateTime(dt.Rows[rwindex]["LetterRefDate"]).ToString("yyyy-MM-dd");
}
else if (DocTypeID == 11)
{
trExamMedium.Visible = true;
txtExamMedium.Text = dt.Rows[rwindex]["ExamMedium"].ToString().ToUpper();
}
viewApplicationModal.Style.Add("display", "block");
//Popup(true);
}
}
HttpClient hclient = new HttpClient();
hclient.BaseAddress = new Uri(DataAcces.Url);
hclient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
objPlSecondLevel = new PL_SecondLevel();
var uri = string.Format("api/SecondLevel/GetLevelRemark/?Ind={0}&ApplicationId={1}", 5, lngapplicationId);
DataTable dtlevel = null;
var response = hclient.GetAsync(uri).Result;
var productJsonString = await response.Content.ReadAsStringAsync();
dtlevel = JsonConvert.DeserializeObject <DataTable>(productJsonString);
StringBuilder sb = new StringBuilder();
if (dtlevel.Rows.Count > 0)
{
sb.Append("<table style='width:100%; border:1px solid;'>");
sb.Append("<tr style='background-color:#50618c; color:white; border:1px solid;'> <th style='width:15%;'>Approval By </th><th style='width:15%;'> Approval Date </th> <th style='width:25%;'> Remark</th></tr>");
for (int i = 0; i < dtlevel.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td style='display:none;'>" + dtlevel.Rows[i]["LevelID"] + "</td>");
sb.Append("<td style='border:1px solid; width:15%;'> " + dtlevel.Rows[i]["LevelDesc"] + "</td>");
sb.Append("<td style='border:1px solid; text-align:center; width:15%;'>" + dtlevel.Rows[i]["ApprovalDate"] + " </td>");
sb.Append("<td style='border:1px solid; width:25%;'>" + dtlevel.Rows[i]["LevelRemark"] + " </td>");
sb.Append("</tr>");
}
sb.Append("</table>");
tblRemark.InnerHtml = sb.ToString();
}
// dtlevel = null;
}
catch
{ }
}
