public void bindsec()
{
try
{
string batch2 = "";
string strbranch = "";
cbl_sect.Items.Clear();
txt_sect.Text = "---Select---";
cb_sect.Checked = false;
string clgvalue = ddl_collegename.SelectedItem.Value.ToString();
if (cbl_batch.Items.Count > 0)
{
batch2 = rs.getCblSelectedValue(cbl_batch);
}
if (cbl_dept.Items.Count > 0)
{
strbranch = rs.getCblSelectedValue(cbl_dept);
}
if (clgvalue != "")
{
//ds = d2.BindSectionDetailmult(clgvalue);
string sec = "select distinct isnull(sections,'') as sections from registration where batch_year in('" + batch2 + "') and degree_code in('" + strbranch + "') and college_code='" + clgvalue + "' and delflag=0 and exam_flag<>'Debar' order by sections";//and sections is not null and ltrim(sections)<>'' and sections<>'-1'
ds.Clear();
ds = d2.select_method_wo_parameter(sec, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
cbl_sect.DataSource = ds;
cbl_sect.DataTextField = "sections";
cbl_sect.DataValueField = "sections";
cbl_sect.DataBind();
if (cbl_sect.Items.Count > 0)
{
for (int row = 0; row < cbl_sect.Items.Count; row++)
{
cbl_sect.Items[row].Selected = true;
}
txt_sect.Text = "Section(" + cbl_sect.Items.Count + ")";
cb_sect.Checked = true;
}
}
}
else
{
cb_sect.Checked = false;
txt_sect.Text = "--Select--";
}
}
catch (Exception ex)
{
}
}
public DataSet GetItemdetails()
{
DataSet dsloaddetails = new DataSet();
try
{
#region get Value
string selQ = string.Empty;
if (ddl_collegename.Items.Count > 0)
{
collcode = Convert.ToString(ddl_collegename.SelectedValue);
}
if (cbl_headername.Items.Count > 0)
{
itemheadercode = Convert.ToString(rs.getCblSelectedValue(cbl_headername));
}
if (cbl_subheadername.Items.Count > 0)
{
itemsubcode = Convert.ToString(rs.getCblSelectedValue(cbl_subheadername));
}
if (ddl_Kitname.Items.Count > 0)
{
kitcode = Convert.ToString(ddl_Kitname.SelectedValue);
}
if (!string.IsNullOrEmpty(collcode))
{
selQ = " select distinct i.ItemPK,i.ItemCode ,i.ItemName +'('+i.ItemUnit+')' as ItemName, sm.StorePK ,sm.StoreName,i.ItemHeaderName,t.MasterValue as ItemSubHeadername from IM_StoreMaster sm,IM_ItemMaster i,CO_MasterValues t where sm.StorePK=i.StoreFK and t.CollegeCode=sm.CollegeCode and t.MasterCode=i.subheader_code and sm.CollegeCode='" + collcode + "' and i.ItemHeaderCode in ('" + itemheadercode + "') and t.MasterCode in('" + itemsubcode + "') group by ItemPK,ItemCode,ItemName,StorePK,StoreName,i.ItemHeaderName,i.ItemUnit,t.MasterValue order by i.ItemPK ";
selQ += "select distinct i.ItemPK,i.ItemCode ,i.ItemName +'('+i.ItemUnit+')' as ItemName, sm.StorePK ,sm.StoreName,i.ItemHeaderName,t.MasterValue as ItemSubHeadername from IM_StoreMaster sm,IM_ItemMaster i,CO_MasterValues t,IM_KitMaster km where sm.StorePK=i.StoreFK and t.CollegeCode=sm.CollegeCode and t.MasterCode=i.subheader_code and t.CollegeCode=km.CollegeCode and i.ItemCode=km.ItemCode and km.KitCode='" + kitcode + "' and km.CollegeCode='" + collcode + "' group by ItemPK,i.ItemCode,i.ItemName,StorePK,StoreName,i.ItemHeaderName,i.ItemUnit,t.MasterValue order by i.ItemPK";
}
dsloaddetails.Clear();
dsloaddetails = d2.select_method_wo_parameter(selQ, "Text");
#endregion
}
catch
{
}
return(dsloaddetails);
}
protected DataSet dsvalue()
{
try
{
string selectquery;
string branch = reUse.GetSelectedItemsValueAsString(cbl_branch); //ddl_branch.Items.Count > 0 ? ddl_branch.SelectedValue : "";
string degCode = reUse.GetSelectedItemsValueAsString(cbl_degree); //ddl_degree.Items.Count > 0 ? ddl_degree.SelectedValue : "";
string stream = ddl_strm.Enabled ? ddl_strm.Items.Count > 0 ? ddl_strm.SelectedItem.Text.Trim() : "" : "";
string section = reUse.GetSelectedItemsText(cbl_sec);//ddl_sec.Items.Count > 0 ? ddl_sec.SelectedItem.Text.Trim() : "";
string batch_year = ddl_batch.Items.Count > 0 ? ddl_batch.SelectedItem.Text : "";
string cusem = reUse.GetSelectedItemsText(cbl_sem);// ddl_sem.Items.Count > 0 ? ddl_sem.SelectedItem.Text : "";
string sem = reUse.getCblSelectedValue(cbl_seml);
DataTable dtStud = new DataTable();
if (batch_year != string.Empty && degCode != string.Empty && branch != string.Empty && cusem != string.Empty)
{
if (stream != string.Empty)
{
stream = " and c.type in ('" + stream + "')";
}
string rptType = string.Empty;
if (ddlType.SelectedItem.Text == "Part Payment")
{
rptType = ",isPartAmount";
}
else
{
rptType = ",isPartAmount,isPartHold";
}
string college_Code = Convert.ToString(ddl_college.SelectedValue);
string ledgid = getCblSelectedValue(chkl_studled);
//selectquery = "select r.Roll_No,r.Roll_Admit,r.smart_serial_no,r.Stud_Name,d.Degree_Code,(C.Course_Name +' - '+ dt.Dept_Name) as Department,r.Reg_No,r.App_No,c.type,isnull(r.Sections,'') as Sections, case when a.sex=0 then 'Male' when a.sex=1 then 'Female' when a.sex=2 then 'Transgender' else 'N/A' end as Gender,a.IsFinPartPay" + rptType + " from Registration r,applyn a,Degree d,Department dt,Course c where r.app_no=a.app_no and r.degree_code =d.Degree_Code and dt.Dept_Code =d.Dept_Code and c.Course_Id =d.Course_Id and CC=0 and DelFlag =0 and Exam_Flag <>'DEBAR' and r.Batch_Year =" + batch_year + " and r.degree_code in ('" + branch + "') and isnull(r.Sections,'') in ('" + section + "') and r.current_semester in('" + sem + "') and isnull(a.admission_status,'0')='1' " + stream + " order by d.Degree_Code,isnull(r.Sections,''),ltrim (r.Roll_No) asc ,ltrim (r.stud_name) asc ";
selectquery = " select distinct Roll_No ,Stud_Name,Course_Name+'-'+Dept_Name as Department,r.degree_code,A.HeaderFK,HeaderName,A.LedgerFK,(LedgerName) as LedgerName,isnull(FeeAmount,0) as FeeAmount,isnull(TotalAmount,0) as TotalAmount,isnull(BalAmount,'0') as balamount,TextVal,TextCode,f.DueDate from Registration r,FM_FineMaster f,Degree d,course c,Department dt,FT_FeeAllot A,FM_HeaderMaster H,FM_LedgerMaster L,TextValTable T,FS_HeaderPrivilage P where r.Batch_Year in('" + batch_year + "') and a.App_No=r.App_No and r.degree_code in ('" + branch + "') and r.college_code in('" + college_Code + "') and A.FeeCategory in('" + sem + "') and a.LedgerFK in('" + ledgid + "') and c.Course_Id in('" + degCode + "') and d.Degree_Code=r.degree_code and d.Course_Id=c.Course_Id and dt.Dept_Code=d.Dept_Code and A.HeaderFK = H.HeaderPK AND A.LedgerFK = L.LedgerPK and P.HeaderFK = H.HeaderPK and P.HeaderFK = L.HeaderFK and a.HeaderFK=p.HeaderFK AND H.HeaderPK = L.HeaderFK AND A.FeeCategory = T.TextCode and BalAmount>0 order by r.degree_code";//and c.Course_Id in('" + degCode + "')// and c.Course_Id in('" + degCode + "')
dsload.Clear();
dsload = DA.select_method_wo_parameter(selectquery, "Text");
}
}
catch (Exception ex)
{
//DA.sendErrorMail(ex, collegeCode, "Finesetting.aspx");
}
return(dsload);
}
protected void btngo_Click(object sender, EventArgs e)
{
try
{
DataSet getstudet = new DataSet();
string couseid = "";
string subcode = "";
string tstcode = "";
string per = "";
double pert = 0;
string subno = string.Empty;
string pervalue = string.Empty;
dtab.Columns.Add("Details");
for (int i = 0; i < cblco.Items.Count; i++)
{
if (cblco.Items[i].Selected == true)
{
dtab.Columns.Add(cblco.Items[i].Text);
}
}
if (ddlsymbol.Items.Count > 0)
{
per = Convert.ToString(ddlsymbol.SelectedValue).Trim();
}
if (txtpercent.Text != "")
{
pervalue = txtpercent.Text;
}
else
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), UniqueID, "alert('Please Enter the %')", true);
return;
}
if (cblco.Items.Count > 0)
{
couseid = Convert.ToString(rs.getCblSelectedValue(cblco));
}
if (ddl_subject.Items.Count > 0)
{
subcode = Convert.ToString(ddl_subject.SelectedValue);
}
if (cbltest.Items.Count > 0)
{
tstcode = Convert.ToString(rs.getCblSelectedValue(cbltest));
}
drow = dtab.NewRow();
drow["Details"] = "Class Averag Marks %";
dtab.Rows.Add(drow);
drow = dtab.NewRow();
drow["Details"] = "Median";
dtab.Rows.Add(drow);
drow = dtab.NewRow();
drow["Details"] = per + pervalue + "%";
dtab.Rows.Add(drow);
drow = dtab.NewRow();
drow["Details"] = "Co Achieved : Yes/No";
dtab.Rows.Add(drow);
string batchyear = "";
string degreecode = "";
string semester = "";
string section = "";
string sect = "";
int col = 0;
if (ddlcollege.Items.Count > 0)
{
collegecode = Convert.ToString(ddlcollege.SelectedValue).Trim();
}
if (ddlbatch.Items.Count > 0)
{
batchyear = Convert.ToString(ddlbatch.SelectedValue).Trim();
}
if (ddlbranch.Items.Count > 0)
{
degreecode = Convert.ToString(ddlbranch.SelectedValue).Trim();
}
if (ddlsemester.Items.Count > 0)
{
semester = Convert.ToString(ddlsemester.SelectedValue).Trim();
}
if (ddlsection.Enabled == true)
{
if (ddlsection.Items.Count > 0)
{
if (Convert.ToString(ddlsection.SelectedItem.Text).Trim().ToLower() != "all" && Convert.ToString(ddlsection.SelectedItem.Text).Trim().ToLower() != "" && Convert.ToString(ddlsection.SelectedItem.Text).Trim().ToLower() != "-1")
{
section = Convert.ToString(ddlsection.SelectedItem.Text).Trim();
sect = " and r.Sections='" + section + "'";
}
else
{
section = "";
}
}
}
else
{
section = "";
}
if (!string.IsNullOrEmpty(collegecode) && !string.IsNullOrEmpty(batchyear) && !string.IsNullOrEmpty(degreecode) && !string.IsNullOrEmpty(semester) && !string.IsNullOrEmpty(couseid))
{
string sqlqry = "select distinct r.App_No,q.CourseOutComeNo from NewInternalMarkEntry m,CAQuesSettingsParent q,registration r,SubjectChooser s,Exam_type e where r.App_No=m.app_no and LTRIM(rtrim(ISNULL(r.sections,'')))=LTRIM(rtrim(ISNULL(e.sections,''))) and s.subject_no=q.subjectNo and e.exam_code=m.ExamCode and e.subject_no=q.subjectNo and e.criteria_no=q.CriteriaNo and r.Roll_No=s.roll_no and q.MasterID=m.MasterID and RollNo_Flag<>'0' and cc='0' and delflag='0' and exam_flag <> 'DEBAR' and r.degree_code='" + degreecode + "' and r.college_code='" + collegecode + "' and r.Batch_Year='" + batchyear + "' and r.Current_Semester='" + semester + "' " + sect + " and q.subjectNo in('" + subcode + "') and q.CriteriaNo in('" + tstcode + "')";
//sqlqry += " select Sum(Mark),CourseOutComeNo,subjectno,CriteriaNo from CAQuesSettingsParent";
//sqlqry += " select SUM(im.marks) mark,ca.CourseOutComeNo,ca.subjectno,ca.CriteriaNo from CAQuesSettingsParent ca,InternalMarkEntry im where ca.MasterID=im.MasterID ";
getstudet.Clear();
getstudet = d2.select_method_wo_parameter(sqlqry, "text");
if (getstudet.Tables.Count > 0 && getstudet.Tables[0].Rows.Count > 0)
{
for (int cou = 0; cou < cblco.Items.Count; cou++)
{
if (cblco.Items[cou].Selected == true)
{
col++;
couseid = cblco.Items[cou].Value;
getstudet.Tables[0].DefaultView.RowFilter = "CourseOutComeNo ='" + couseid + "'";
DataView dvstd = getstudet.Tables[0].DefaultView;
int totstd = dvstd.Count;
string toalcousermark = d2.GetFunction(" select Sum(Mark) from CAQuesSettingsParent where CourseOutComeNo='" + couseid + "' and subjectno='" + subcode + "' and CriteriaNo in('" + tstcode + "')");
// Calculate Class Averag Marks %
string value = d2.GetFunction("select SUM(im.marks) mark from CAQuesSettingsParent ca,NewInternalMarkEntry im where ca.MasterID=im.MasterID and ca.CourseOutComeNo='" + couseid + "' and ca.subjectno in('" + subcode + "') and ca.CriteriaNo in('" + tstcode + "') ");
if (value != "" && Convert.ToDouble(value) > 0)
{
double toalstdmark = Convert.ToDouble(totstd) * Convert.ToDouble(toalcousermark);
pert = Convert.ToDouble(value) / Convert.ToDouble(toalstdmark);
double pertge = pert * 100;
// double pets = (pertge * txtpert) / 100;
string perts = Convert.ToString(Math.Round(Convert.ToDouble(pertge), 2));
dtab.Rows[dtab.Rows.Count - 4][col] = perts;
}
else
{
dtab.Rows[dtab.Rows.Count - 4][col] = "0";
}
//End
double mediamstadmark = 0;
double userentrystdmark = 0;
int mediamstdcnt = 0;
int userentryperstdcnt = 0;
string classavgper = dtab.Rows[dtab.Rows.Count - 4][col].ToString();
double txtperta = Convert.ToDouble(pervalue);
if (dvstd.Count > 0)
{
for (int std = 0; std < dvstd.Count; std++)
{
double stdcomark = 0;
string appno = Convert.ToString(dvstd[std]["app_no"]);
string stdmark = d2.GetFunction("select SUM(im.marks) mark from CAQuesSettingsParent ca,NewInternalMarkEntry im where ca.MasterID=im.MasterID and app_no='" + appno + "' and ca.CourseOutComeNo ='" + couseid + "' and subjectno='" + subcode + "' and CriteriaNo in('" + tstcode + "') ");
if (stdmark == "")
{
stdcomark = 0;
}
else
{
stdcomark = Convert.ToDouble(stdmark);
}
if (Convert.ToDouble(stdcomark) > 0)
{
double stdpert = Convert.ToDouble(stdcomark) / Convert.ToDouble(toalcousermark);
double pertge = stdpert * 100;
string stdpersentage = Convert.ToString(Math.Round(Convert.ToDouble(pertge), 2));
// Calculate Mediam
if (classavgper != "")
{
if (Convert.ToDouble(classavgper) < Convert.ToDouble(stdpersentage))
{
mediamstadmark = mediamstadmark + Convert.ToDouble(stdcomark);
mediamstdcnt++;
}
}
//End
//Calculate user entry Per
if (per == ">")
{
if (Convert.ToDouble(stdpersentage) > txtperta)
{
string stdpertge = stdpersentage;
userentrystdmark = userentrystdmark + Convert.ToDouble(stdcomark);
userentryperstdcnt++;
}
}
else if (per == "<")
{
if (Convert.ToDouble(stdpersentage) < txtperta)
{
string stdpertge = stdpersentage;
userentrystdmark = userentrystdmark + Convert.ToDouble(stdcomark);
userentryperstdcnt++;
}
}
else if (per == ">=")
{
if (Convert.ToDouble(stdpersentage) >= txtperta)
{
string stdpertge = stdpersentage;
userentrystdmark = userentrystdmark + Convert.ToDouble(stdcomark);
userentryperstdcnt++;
}
}
else if (per == "<=")
{
if (Convert.ToDouble(stdpersentage) <= txtperta)
{
string stdpertge = stdpersentage;
userentrystdmark = userentrystdmark + Convert.ToDouble(stdcomark);
userentryperstdcnt++;
}
}
else
{
if (Convert.ToDouble(stdpersentage) == txtperta)
{
string stdpertge = stdpersentage;
userentrystdmark = userentrystdmark + Convert.ToDouble(stdcomark);
userentryperstdcnt++;
}
}
//End
}
}
}
//medium
if (Convert.ToInt32(mediamstadmark) != 0)
{
double totalmedian = Convert.ToDouble(mediamstdcnt) * Convert.ToDouble(toalcousermark);
pert = Convert.ToDouble(mediamstadmark) / Convert.ToDouble(totalmedian);
double pertge = pert * 100;
// double pertge = pert;
string perts = Convert.ToString(Math.Round(Convert.ToDouble(pertge), 2));
dtab.Rows[dtab.Rows.Count - 3][col] = perts;
}
else
{
dtab.Rows[dtab.Rows.Count - 3][col] = "0";
}
//User entry
if (Convert.ToInt32(userentrystdmark) != 0)
{
double totalusermark = Convert.ToDouble(userentryperstdcnt) * Convert.ToDouble(toalcousermark);
pert = Convert.ToDouble(userentrystdmark) / Convert.ToDouble(totalusermark);
double pertge = pert * 100;
string perts = Convert.ToString(Math.Round(Convert.ToDouble(pertge), 2));
dtab.Rows[dtab.Rows.Count - 2][col] = perts;
}
else
{
dtab.Rows[dtab.Rows.Count - 2][col] = "0";
}
}
}
if (dtab.Columns.Count > 0)
{
Showgrid.DataSource = dtab;
Showgrid.DataBind();
Showgrid.Visible = true;
divMainContents.Visible = true;
printtable.Visible = true;
}
}
else
{
Showgrid.Visible = false;
divMainContents.Visible = false;
printtable.Visible = false;
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), UniqueID, "alert('No Record Found!')", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), UniqueID, "alert('Please Select All The Feild')", true);
return;
}
}
catch
{
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string stuflag = string.Empty;
if (rbRegular.Checked)
{
stuflag = "1";
}
else if (rbArear.Checked)
{
stuflag = "2";
}
else
{
lblAlertMsg.Text = "Choose Arear/Regular";
divPopAlert.Visible = true;
lblAlertMsg.Visible = true;
return;
}
string valBatch = rs.getCblSelectedValue(cblBatch);
string valDegree = rs.getCblSelectedValue(cblBranch);
string valSem = rs.getCblSelectedValue(cbl_sem);
string edulevel = ddlEdulevl.SelectedValue.ToString();
string strbatch = getCblSelectedValueComma(cblBatch);
string strDegree = getCblSelectedValueComma(cblBranch);
string strSem = getCblSelectedValueComma(cbl_sem);
string MinEse = txtExtMin.Text;
string MinCia = txtCiaMin.Text;
string ModMark = txtModeration.Text;
string valCia = ddlCiaMin.SelectedValue.ToString();
string vaESE = ddlExtMin.SelectedValue.ToString();
string value = vaESE + "," + valCia;
string colCode = ddlCollege.SelectedValue.ToString();
int save = 0;
string[] batchloop = strbatch.Split(',');
string[] degreeloop = strDegree.Split(',');
for (int i = 0; i < batchloop.Length; i++)
{
for (int j = 0; j < degreeloop.Length; j++)
{
if (ddlCiaMin.SelectedValue.ToString() != "0" && ddlExtMin.SelectedValue.ToString() != "0" && !string.IsNullOrEmpty(MinEse))
{
string SelectQ = "if exists(select * from New_ModSettings where college_code='" + colCode + "' and LinkName='MaximumModerationNew' and stuflag='" + stuflag + "' and BatchYear='" + Convert.ToString(batchloop[i]) + "' and DegreeCode='" + degreeloop[j] + "') update New_ModSettings SET LinkValue='" + ModMark + "',Semester='" + strSem + "',MinCIA='" + MinCia + "',MinESE='" + MinEse + "',value='" + value + "' where college_code='" + colCode + "' and LinkName='MaximumModerationNew' and BatchYear='" + Convert.ToString(batchloop[i]) + "' and DegreeCode='" + degreeloop[j] + "' and stuflag='" + stuflag + "' else insert into New_ModSettings (LinkName,LinkValue,college_code,BatchYear,DegreeCode,Semester,MinCIA,MinESE,value,stuflag) values('MaximumModerationNew','" + ModMark + "','" + colCode + "','" + Convert.ToString(batchloop[i]) + "','" + degreeloop[j] + "','" + strSem + "','" + MinCia + "','" + MinEse + "','" + value + "','" + stuflag + "')";
save = da.update_method_wo_parameter(SelectQ, "Text");
}
}
}
if (save > 0)
{
lblAlertMsg.Text = "Saved Sucessfully";
divPopAlert.Visible = true;
lblAlertMsg.Visible = true;
return;
}
else
{
lblAlertMsg.Text = "Not Saved";
divPopAlert.Visible = true;
lblAlertMsg.Visible = true;
return;
}
}
catch
{
}
}
