private void BindExamYear() // Exam Year Purpose
{
objplstudetail.Ind = 3;
HttpClient HClient = new HttpClient();
HClient.BaseAddress = new Uri(DataAcces.Url);
HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
objplstudentDetail = new PlStudentDetail();
var uri = "api/StudentDetail/GetExamYear/";
var response = HClient.GetAsync(uri).Result;
if (response.IsSuccessStatusCode)
{
var getdata = response.Content.ReadAsAsync <IEnumerable <PlStudentDetail> >().Result;
if (getdata.Count() > 0)
{
DDLExamYear.DataSource = getdata;
DDLExamYear.DataValueField = "ItemID";
DDLExamYear.DataTextField = "ItemDesc";
DDLExamYear.DataBind();
}
getdata = null;
}
response = null; uri = null;
}
public DataTable GetStudentDetail(PlStudentDetail pl)
{
cmd = new SqlCommand("SPApplicationDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@ExamSession", pl.ExamSession);
cmd.Parameters.AddWithValue("@ExamYear", pl.ExamYear);
cmd.Parameters.AddWithValue("@StudentName", pl.StudentName);
cmd.Parameters.AddWithValue("@Rollno", pl.Rollno);
//cmd.Parameters.AddWithValue("@SumittedFees", pl.SubmittedFees);
//cmd.Parameters.AddWithValue("@ApplicationID", pl.ApplicationID);
//cmd.Parameters.AddWithValue("@Remarks", pl.Remarks);
//cmd.Parameters.AddWithValue("@InsertionDate", pl.InserttionDate);
//cmd.Parameters.AddWithValue("@InsertionBy", pl.InsertionBy);
//cmd.Parameters.AddWithValue("@InsertionByIP", pl.InsertionByIP);
//cmd.Parameters.AddWithValue("@EstimateDate", pl.EstimateDate);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
if (Convert.ToInt32(dt.Rows[0]["RollNo"]) == 0)
{
dt = null;
}
}
else
{
dt = null;
}
return(dt);
}
public DataTable GetForApply(PlStudentDetail pl)
{
cmd = new SqlCommand("SPGetAllMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
protected void BtnSave_Click(object sender, EventArgs e)
{
string lblExamName = "", lblPartARegNo = "", lblPartAImagePath = "", lblPartBRegNo = "", lblPartBImagePath = "";
foreach (GridViewRow item in GridStudentDetail.Rows)
{
CheckBox Cb = (CheckBox)item.FindControl("CheckBox1");
if (Cb.Checked)
{
lblExamName = (item.FindControl("lblExamName") as Label).Text;
lblPartARegNo = (item.FindControl("lblPartARegNo") as Label).Text;
lblPartAImagePath = (item.FindControl("lblPartAImagePath") as Label).Text;
lblPartBRegNo = (item.FindControl("lblPartBRegNo") as Label).Text;
lblPartBImagePath = (item.FindControl("lblPartBImagePath") as Label).Text;
}
}
objplstudentDetail = new PlStudentDetail();
objplstudetail.Ind = 1;
objplstudentDetail.ApplicationID = 0;
objplstudentDetail.ExamSession = DDLExamSession.SelectedValue;
objplstudentDetail.ExamYear = DDLExamYear.SelectedValue;
objplstudentDetail.ExamName = lblExamName;
objplstudentDetail.StudentName = TxtStuName.Text;
objplstudentDetail.Rollno = txtRollNo.Text;
objplstudentDetail.Remarks = TxtRmark.Text;
objplstudentDetail.AppliedFor = DDLApply.SelectedValue;
objplstudentDetail.SubmittedFees = string.IsNullOrEmpty(txtRecieptAmt.Text) ? 0 : Convert.ToDecimal(txtRecieptAmt.Text);
objplstudentDetail.PartARegNo = string.IsNullOrEmpty(lblPartARegNo) ? 0 : Convert.ToInt32(lblPartARegNo);
objplstudentDetail.PartAImagePath = lblPartAImagePath;
objplstudentDetail.PartBRegNo = string.IsNullOrEmpty(lblPartBRegNo) ? 0 : Convert.ToInt32(lblPartBRegNo);
objplstudentDetail.PartBImagePath = lblPartBImagePath;
objplstudentDetail.InsertionBy = UserId;
objplstudentDetail.InsertionByIP = ipAddress;
objplstudentDetail.EstimateDate = DateTime.Now.ToString("dd/MM/yyyy");
HttpClient HClient = new HttpClient();
HClient.BaseAddress = new Uri(DataAcces.Url);
HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
objplstudentDetail = new PlStudentDetail();
var uri = "api/StudentDetail/SaveRecord/";
var response = HClient.PostAsJsonAsync(uri, objplstudentDetail).Result;
if (response.IsSuccessStatusCode)
{
var getdata = response.Content.ReadAsAsync <IEnumerable <PlStudentDetail> >().Result;
if (getdata.Count() > 0)
{
}
}
}
public DataTable SaveStudentDetail(PlStudentDetail pl)
{
// decimal roll = Convert.ToDecimal(pl.Rollno);
//cmd = new SqlCommand("select SName,RollNo from TblFoilImgEntry where RollNo='" + roll + "' ", con);
cmd = new SqlCommand("SPApplicationDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@AppID", pl.ApplicationID);
cmd.Parameters.AddWithValue("@ExamSession", Convert.ToInt32(pl.ExamSession));
cmd.Parameters.AddWithValue("@ExamYear", Convert.ToInt32(pl.ExamYear));
cmd.Parameters.AddWithValue("@ExamName", pl.ExamName);
cmd.Parameters.AddWithValue("@StudentName", pl.StudentName);
cmd.Parameters.AddWithValue("@RollNo", pl.Rollno);
cmd.Parameters.AddWithValue("@Remarks", pl.Remarks);
cmd.Parameters.AddWithValue("@AppliedFor", pl.AppliedFor);
cmd.Parameters.AddWithValue("@SubmittedFees", pl.SubmittedFees);
cmd.Parameters.AddWithValue("@PartARegNo", pl.PartARegNo);
cmd.Parameters.AddWithValue("@PartAImagePath", pl.PartAImagePath);
cmd.Parameters.AddWithValue("@PartBRegNo", pl.PartBRegNo);
cmd.Parameters.AddWithValue("@PartBImagePath", pl.PartBImagePath);
// cmd.Parameters.AddWithValue("@InsertionDate", pl.InserttionDate);
cmd.Parameters.AddWithValue("@InsertionBy", pl.InsertionBy);
cmd.Parameters.AddWithValue("@InsertionByIP", pl.InsertionByIP);
cmd.Parameters.AddWithValue("@EstimateDate", Convert.ToDateTime(pl.EstimateDate));
con.Open();
int Ind = 0;
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
con.Close();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
Ind = 1;
}
}
else
{
dt = null;
}
return(dt);
}
private void BindForApply() // Document Type Purpose For Apply
{
HttpClient HClient = new HttpClient();
HClient.BaseAddress = new Uri(DataAcces.Url);
HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
objplstudentDetail = new PlStudentDetail();
var uri = "api/StudentDetail/GetApply/?ind=" + "15";
var response = HClient.GetAsync(uri).Result;
if (response.IsSuccessStatusCode)
{
// var getdata = response.Content.ReadAsAsync<IEnumerable<PlStudentDetail>>().Result;
dt = new DataTable();
dt = response.Content.ReadAsAsync <DataTable>().Result;
if (dt.Rows.Count > 0)
{
}
}
//response = null; uri = null;
}
private void SearchDetail() // Search Detail Purpose
{
try
{
lblSms.Text = "";
string rollno;
if (txtRollNo.Text.Trim() == "")
{
rollno = "0";
}
else
{
rollno = Convert.ToString(txtRollNo.Text.Trim());
}
HttpClient HClient = new HttpClient();
HClient.BaseAddress = new Uri(DataAcces.Url);
HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
objplstudentDetail = new PlStudentDetail();
var uri = string.Format("api/StudentDetail/GetStudentDetail/?ind={0}&ExamYear={1}&ExamSession={2}&StudentName={3}&Rollno={4}", 2, DDLExamYear.SelectedItem.ToString(), DDLExamSession.SelectedValue.ToString(), TxtStuName.Text.Trim(), rollno);
var response = HClient.GetAsync(uri).Result;
if (response.IsSuccessStatusCode)
{
//var getdata = response.Content.ReadAsAsync<IEnumerable<PlStudentDetail>>().Result;
var getdata = response.Content.ReadAsAsync <DataTable>().Result;
if (getdata.Rows.Count > 0)
{
LblSearchCount.Text = "Total Searched Records : " + getdata.Rows.Count;
Session["dtSession"] = getdata;
Panel1.Visible = true;
GridStudentDetail.DataSource = getdata;
GridStudentDetail.DataBind();
DDLApply.Enabled = false;
DDLExamSession.Enabled = false;
DDLExamYear.Enabled = false;
TxtRmark.Enabled = true;
TxtStuName.Enabled = false;
txtRollNo.Enabled = false;
foreach (DataRow a in getdata.Rows)
{
objplstudetail.ExamName = Convert.ToString(a["Faculty_Exam_Name"]);
objplstudetail.PartAImagePath = Convert.ToString(a["PartAImagePath"]);
// if (a["PartARegNo"] != null || a["PartARegNo"] != "")
objplstudetail.PartARegNo = Convert.ToInt32(a["PartARegNo"]);
objplstudetail.PartBImagePath = Convert.ToString(a["PartBImagePath"]);
// if (a["PartBRegNo"] != null || a["PartBRegNo"] != "")
objplstudetail.PartBRegNo = Convert.ToInt32(a["PartBRegNo"]);
objplstudetail.Rollno = Convert.ToString(a["Rollno"]);
objplstudetail.SName = Convert.ToString(a["SName"]);
obj.Add(objplstudetail);
}
getdata = null;
}
else
{
lblSms.Text = "No Matching Record Found.";
Session["dtSession"] = null;
}
}
response = null; uri = null;
return;
}
catch
{
}
finally { }
}
public DataTable SaveStudentDetail(PlStudentDetail pl)
{
return(dl.SaveStudentDetail(pl));
}
public DataTable GetStudentDetail(PlStudentDetail pl)
{
return(dl.GetStudentDetail(pl));
}
public DataTable GetForApply(PlStudentDetail pl)
{
return(dl.GetForApply(pl));
}
public DataTable GetExamType(PlStudentDetail pl)
{
return(dl.GetExamType(pl));
}
public DataTable GetExamSession(PlStudentDetail pl)
{
return(dl.GetExamSession(pl));
}
public DataTable GetExamYear(PlStudentDetail pl)
{
return(dl.GetExamYear(pl));
}
