public static string checkCatName(string CatName) { string returnValue = "1"; try { DAccess2 dd = new DAccess2(); string cat_name = CatName; if (cat_name.Trim() != "" && cat_name != null) { string querycatname = dd.GetFunction("select distinct category_code,category_name from staffcategorizer where category_name='" + cat_name + "' and college_code='" + autocol + "'"); if (querycatname.Trim() == "" || querycatname == null || querycatname == "0" || querycatname == "-1") { returnValue = "0"; } } else { returnValue = "2"; } } catch (SqlException ex) { returnValue = "error" + ex.ToString(); } return(returnValue); }
public static string CheckUserName(string MenuName) { string returnValue = "1"; try { DAccess2 dd = new DAccess2(); string user_name = MenuName; if (user_name.Trim() != "" && user_name != null) { string query = dd.GetFunction("select distinct MenuName,MenuMasterPK from HM_MenuMaster where MenuName ='" + user_name + "'"); if (query.Trim() == "" || query == null || query == "0" || query == "-1") { returnValue = "0"; } } else { returnValue = "2"; } } catch (SqlException ex) { returnValue = "error" + ex.ToString(); } return(returnValue); }
public void bindsections() { Connection(); DAccess2 das = new DAccess2(); DataSet dss = new DataSet(); ht.Clear(); ht.Add("batch_year", ddlBatch.SelectedItem.Text.ToString()); ht.Add("degree_code", ddlBranch.SelectedValue.ToString()); dss = das.select_method("bind_sec", ht, "sp"); if (dss.Tables[0].Rows.Count > 0) { ddlSection.Enabled = true; ddlSection.Items.Clear(); ddlSection.Items.Insert(0, new ListItem("All", "0")); for (int i = 0; i < dss.Tables[0].Rows.Count; i++) { ddlSection.Items.Add(dss.Tables[0].Rows[i]["sections"].ToString()); } } else { ddlSection.Items.Insert(0, new ListItem("All", "0")); ddlSection.Enabled = false; } }
public void binddegree() { Connection(); usercode = Session["usercode"].ToString(); DAccess2 da1 = new DAccess2(); DataSet ds1 = new DataSet(); string singleuser = Session["single_user"].ToString(); string group_user = Session["group_code"].ToString(); if (group_user.Contains(';')) { string[] group_semi = group_user.Split(';'); group_user = group_semi[0].ToString(); } ht.Clear(); ht.Add("college_code", Session["collegecode"].ToString()); ht.Add("User_code", usercode); ht.Add("single_user", singleuser); ht.Add("group_code", group_user); ds1 = da1.select_method("bind_degree", ht, "sp"); if (ds1.Tables[0].Rows.Count > 0) { ddlDegree.Enabled = true; ddlDegree.Items.Clear(); for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { ddlDegree.Items.Insert(i, new ListItem(ds1.Tables[0].Rows[i]["course_name"].ToString(), ds1.Tables[0].Rows[i]["course_id"].ToString())); } } else { ddlDegree.Enabled = false; } }
public void bindSem1() { Connection(); DAccess2 das = new DAccess2(); DataSet dss = new DataSet(); ht.Clear(); ht.Add("batch_year", ddlBatch.SelectedItem.Text.ToString()); ht.Add("college_code", Session["collegecode"].ToString()); ht.Add("degree_code", ddlBranch.SelectedValue.ToString()); dss = das.select_method("bind_sem", ht, "sp"); if (dss.Tables[0].Rows.Count > 0) { ddlSem.Enabled = true; ddlSem.Items.Clear(); for (int i = 1; i <= Convert.ToInt16(dss.Tables[0].Rows[0]["duration"].ToString()); i++) { ddlSem.Items.Add(i.ToString()); } } else { ddlSem.Enabled = false; } }
public static string checkGroupName(string grpname) { string returnValue = "1"; try { DAccess2 dd = new DAccess2(); string grp_name = grpname; if (grp_name.Trim() != "" && grp_name != null) { string queryledname = dd.GetFunction("select distinct GroupName,FinGroupPK from FM_FinGroupMaster where GroupName='" + grp_name + "' and CollegeCode=" + collegestat + ""); if (queryledname.Trim() == "" || queryledname == null || queryledname == "0" || queryledname == "-1") { returnValue = "0"; } } else { returnValue = "2"; } } catch (SqlException ex) { returnValue = "error" + ex.ToString(); } return(returnValue); }
public void inservalue() { DAccess2 dacc = new DAccess2(); string batchquery = string.Empty; string collegeCode = ddlCollege.SelectedItem.Value; string isvocational = Radioformat1.Checked ? "1" : "0"; string batch = ddlbatch.SelectedItem.Value; string degree = ddlbranch.SelectedItem.Value; if (txtsubject.Text == "" && txtcommunity.Text == "") { lblAlertMsg.Visible = true; lblAlertMsg.Text = "Enter The value of subject and community"; divPopAlert.Visible = true; txtsubject.Visible = false; txtcommunity.Visible = false; } string sql = "if exists(select * from stu_eligiblemaster where deg_code='" + degree + "' and isVocational='" + isvocational + "' and batch_year='" + batch + "' ) update stu_eligiblemaster set colleg_code='" + collegeCode + "',batch_year='" + batch + "',deg_code='" + degree + "',isVocational='" + isvocational + "',subject='" + txtsubject.Text + "',Community='" + txtcommunity.Text + "',formula='" + foumla.Text + "',fomulavalue='" + TextBox2.Text + "' where batch_year='" + batch + "' and isVocational='" + isvocational + "' and colleg_code='" + collegeCode + "'else insert into stu_eligiblemaster(colleg_code ,batch_year ,deg_code,isVocational,subject , Community ,formula,fomulavalue ) values('" + collegeCode + "','" + batch + "','" + degree + "','" + isvocational + "','" + txtsubject.Text + "','" + txtcommunity.Text + "','" + foumla.Text + "','" + TextBox2.Text + "') "; dacc.update_method_wo_parameter(sql, "text"); //int result = d2.update_method_wo_parameter(splhr_query_master, "text"); ddlbatch.SelectedIndex = 0; ddldegree.SelectedIndex = 0; ddlbranch.SelectedIndex = 0; ddlCollege.SelectedIndex = 0; }
public void community() { string str = string.Empty; string str2 = string.Empty; string strname = string.Empty; DAccess2 d2 = new DAccess2(); string batchquery = string.Empty; foreach (GridViewRow gvrow in GridView1.Rows) { CheckBox chk = (CheckBox)gvrow.FindControl("cbSelect2"); if (chk != null & chk.Checked) { //str += "" + gvrow.Cells[1].Text + ""; str += d2.GetFunction("select MAX (TextCode) from textvaltable where TextCriteria='comm' and textval<>'' and college_code ='" + ddlCollege.SelectedItem.Value + "' and textval='" + gvrow.Cells[1].Text + "' "); //ds.Clear(); str += "="; str += (gvrow.FindControl("TextBox1") as TextBox).Text; str += "/"; } } txtcommunity.Text = str; }
public static string checkCatAcr(string CatAcr) { string returnValue = "1"; try { DAccess2 dd = new DAccess2(); string cat_acr = CatAcr; if (cat_acr.Trim() != "" && cat_acr != null) { string querycatacr = dd.GetFunction("select distinct CategoryAcr,CategoryMasterPK from HRM_CategoryMaster where CategoryAcr='" + cat_acr + "'"); if (querycatacr.Trim() == "" || querycatacr == null || querycatacr == "0" || querycatacr == "-1") { returnValue = "0"; } } else { returnValue = "2"; } } catch (SqlException ex) { returnValue = "error" + ex.ToString(); } return(returnValue); }
public static string CheckAbbreviation(string StoreName) { string returnValue = "1"; try { DAccess2 dd = new DAccess2(); string user_name = StoreName; if (user_name.Trim() != "" && user_name != null) { string query = dd.GetFunction("select distinct MarkTypeAcr from CO_MarkMaster where CollegeCode in('" + clgcode1 + "') and MarkTypeAcr ='" + user_name + "'"); if (query.Trim() == "" || query == null || query == "0" || query == "-1") { returnValue = "0"; } } else { returnValue = "2"; } } catch (SqlException ex) { returnValue = "error" + ex.ToString(); } return(returnValue); }
public static string checkCatAcr(string CatAcr) { string returnValue = "1"; try { DAccess2 dd = new DAccess2(); string cat_acr = CatAcr; if (cat_acr.Trim() != "" && cat_acr != null) { string querycatacr = dd.GetFunction("select distinct shortname,category from leave_category where shortname='" + cat_acr + "' and college_Code='" + autocol + "'"); if (querycatacr.Trim() == "" || querycatacr == null || querycatacr == "0" || querycatacr == "-1") { returnValue = "0"; } } else { returnValue = "2"; } } catch (SqlException ex) { returnValue = "error" + ex.ToString(); } return(returnValue); }
public static string checkAcctName(string acname) { string returnValue = "1"; try { DAccess2 dd = new DAccess2(); string ac_name = acname; if (ac_name.Trim() != "" && ac_name != null) { string queryacname = dd.GetFunction("select distinct FinYearName from FM_FinYearMaster where FinYearName='" + ac_name + "' and CollegeCode=" + collegestat + ""); if (queryacname.Trim() == "" || queryacname == null || queryacname == "0" || queryacname == "-1") { returnValue = "0"; } } else { returnValue = "2"; } } catch (SqlException ex) { returnValue = "error" + ex.ToString(); } return(returnValue); }
public static List <string> Getmenu(string prefixText) { DAccess2 dn = new DAccess2(); DataSet dw = new DataSet(); List <string> name = new List <string>(); string query = "select distinct MenuCode from HM_MenuMaster where MenuCode like '%" + prefixText + "%'"; dw = dn.select_method_wo_parameter(query, "Text"); if (dw.Tables[0].Rows.Count > 0) { for (int i = 0; i < dw.Tables[0].Rows.Count; i++) { name.Add(dw.Tables[0].Rows[i]["MenuCode"].ToString()); } } return(name); }
public static List <string> Getname(string prefixText) { DAccess2 dn = new DAccess2(); DataSet dw = new DataSet(); List <string> name = new List <string>(); string sql = "select TextCode,TextVal from TextValTable where TextCriteria ='Sitem' "; dw = dn.select_method_wo_parameter(sql, "Text"); if (dw.Tables[0].Rows.Count > 0) { for (int i = 0; i < dw.Tables[0].Rows.Count; i++) { name.Add(dw.Tables[0].Rows[i]["TextVal"].ToString()); } } return(name); }
public static List <string> Getitemheader(string prefixText) { DAccess2 dn = new DAccess2(); DataSet dw = new DataSet(); List <string> name = new List <string>(); string query = "select distinct itemheader_name from item_master WHERE itemheader_name like '" + prefixText + "%' "; dw = dn.select_method_wo_parameter(query, "Text"); if (dw.Tables[0].Rows.Count > 0) { for (int i = 0; i < dw.Tables[0].Rows.Count; i++) { name.Add(dw.Tables[0].Rows[i]["itemheader_name"].ToString()); } } return(name); }
public static List <string> Getname(string prefixText) { DAccess2 dn = new DAccess2(); DataSet dw = new DataSet(); List <string> name = new List <string>(); string query = "select distinct itemname from IT_PurchaseOrder p,IT_PurchaseOrderDetail pd,IM_ItemMaster i where i.ItemPK=pd.ItemFK and p.PurchaseOrderPK=pd.PurchaseOrderFK and itemname like '" + prefixText + "%' "; dw = dn.select_method_wo_parameter(query, "Text"); if (dw.Tables[0].Rows.Count > 0) { for (int i = 0; i < dw.Tables[0].Rows.Count; i++) { name.Add(dw.Tables[0].Rows[i]["ItemName"].ToString()); } } return(name); }
public void btnPrint11() { DAccess2 ddd2 = new DAccess2(); string college_code = Convert.ToString(Session["collegecode"].ToString()); string colQ = "select * from collinfo where college_code='" + college_code + "'"; DataSet dsCol = new DataSet(); dsCol = ddd2.select_method_wo_parameter(colQ, "Text"); string collegeName = string.Empty; string collegeCateg = string.Empty; string collegeAff = string.Empty; string collegeAdd = string.Empty; string collegePhone = string.Empty; string collegeFax = string.Empty; string collegeWeb = string.Empty; string collegeEmai = string.Empty; string collegePin = string.Empty; string acr = string.Empty; string City = string.Empty; if (dsCol.Tables.Count > 0 && dsCol.Tables[0].Rows.Count > 0) { collegeName = Convert.ToString(dsCol.Tables[0].Rows[0]["Collname"]); City = Convert.ToString(dsCol.Tables[0].Rows[0]["address3"]); collegeAff = "(Affiliated to " + Convert.ToString(dsCol.Tables[0].Rows[0]["university"]) + ")"; collegeAdd = Convert.ToString(dsCol.Tables[0].Rows[0]["address1"]) + " , " + Convert.ToString(dsCol.Tables[0].Rows[0]["address2"]) + " , " + Convert.ToString(dsCol.Tables[0].Rows[0]["district"]) + " - " + Convert.ToString(dsCol.Tables[0].Rows[0]["pincode"]); collegePin = Convert.ToString(dsCol.Tables[0].Rows[0]["pincode"]); collegePhone = "OFFICE: " + Convert.ToString(dsCol.Tables[0].Rows[0]["phoneno"]); collegeFax = "FAX: " + Convert.ToString(dsCol.Tables[0].Rows[0]["faxno"]); collegeWeb = "Website: " + Convert.ToString(dsCol.Tables[0].Rows[0]["website"]); collegeEmai = "E-Mail: " + Convert.ToString(dsCol.Tables[0].Rows[0]["email"]); collegeCateg = "(" + Convert.ToString(dsCol.Tables[0].Rows[0]["category"]) + ")"; } DateTime dt = DateTime.Now; int year = dt.Year; spCollegeName.InnerHtml = collegeName; spAddr.InnerHtml = collegeAdd; spDegreeName.InnerHtml = acr; spReportName.InnerHtml = "Special Hour Report"; // spSection.InnerHtml ="Satff: "+ Convert.ToString(ddlSearchOption.SelectedItem.Text); }
//Print and Excel Report protected void btnExcel_Click(object sender, EventArgs e) { try { string reportname = txtexcelname.Text; if (reportname.ToString().Trim() != "") { DAccess2 DA = new DAccess2(); DA.printexcelreport(Fpspread1, reportname); lblvalidation1.Visible = false; } else { lblvalidation1.Text = "Please Enter Your Report Name"; lblvalidation1.Visible = true; txtexcelname.Focus(); } } catch { } }
public static string applicationNo(string applno) { string Value = "1"; try { if (!string.IsNullOrEmpty(applno) && !string.IsNullOrEmpty(btyr)) { DAccess2 da = new DAccess2(); string applValue = da.GetFunction(" select top 1 r.roll_admit from Registration r,applyn a where a.app_no=r.App_No and isnull(a.is_enroll,0) = '2' and r.roll_admit <>'' and r.roll_admit like '%" + applno + "%' and r.batch_year='" + btyr + "' and r.college_code='" + clgcode + "' order by r.roll_admit desc"); if (string.IsNullOrEmpty(applValue) || applValue == "0" || applValue == "-1") { Value = "0"; } } else { Value = "2"; } } catch (SqlException ex) { Value = "error" + ex.ToString(); } return(Value); }
public void bindcollege() { DAccess2 d2 = new DAccess2(); try { ds.Clear(); ds = d2.BindCollegebaseonrights(Session["usercode"].ToString()); if (ds.Tables[0].Rows.Count > 0) { ddl_collegename.DataSource = ds; ddl_collegename.DataTextField = "collname"; ddl_collegename.DataValueField = "college_code"; ddl_collegename.DataBind(); headerbind(); ledgerbind(); } } catch { } }
protected void bindsubject() { if (ddlSubjectType.SelectedItem.Text.ToString() != "All") { DAccess2 da = new DAccess2(); DataSet ds = new DataSet(); ht.Clear(); if (ddlSection.SelectedItem.Text.ToString() != "" && ddlSubjectType.SelectedItem.Text.ToString() != "" && ddlBatch.SelectedItem.Text.ToString() != "" && ddlSem.SelectedValue.ToString() != "" && ddlBranch.SelectedValue.ToString() != "") { ht.Add("CollegeCode", Session["collegecode"].ToString()); ht.Add("Sections", ddlSection.SelectedItem.Text.ToString()); ht.Add("Subtype", ddlSubjectType.SelectedItem.Text.ToString()); ht.Add("BatchYear", ddlBatch.SelectedItem.Text.ToString()); ht.Add("Semester", ddlSem.SelectedItem.Text.ToString()); ht.Add("DegreeCode", ddlBranch.SelectedValue.ToString()); ds = da.select_method("ProcBatchAllocationSubjectDetails", ht, "sp"); ddlSubject.Items.Clear(); if (ds.Tables[0].Rows.Count > 0) { ddlSubject.Enabled = true; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ddlSubject.Items.Insert(i, new ListItem(ds.Tables[0].Rows[i]["SubjectName"].ToString(), ds.Tables[0].Rows[i]["SubjectNo"].ToString())); } } else { ddlSubject.Enabled = false; } } } else { DAccess2 da = new DAccess2(); DataSet ds = new DataSet(); ht.Clear(); if (ddlSection.SelectedItem.Text.ToString() != "" && ddlSubjectType.SelectedItem.Text.ToString() != "" && ddlBatch.SelectedItem.Text.ToString() != "" && ddlSem.SelectedValue.ToString() != "" && ddlBranch.SelectedValue.ToString() != "") { ht.Add("CollegeCode", Session["collegecode"].ToString()); ht.Add("Sections", ddlSection.SelectedItem.Text.ToString()); ht.Add("Subtype", ddlSubjectType.SelectedItem.Text.ToString()); ht.Add("BatchYear", ddlBatch.SelectedItem.Text.ToString()); ht.Add("Semester", ddlSem.SelectedItem.Text.ToString()); ht.Add("DegreeCode", ddlBranch.SelectedValue.ToString()); ds = da.select_method("ProcBatchAllocationSubjectDetails", ht, "sp"); ddlSubject.Items.Clear(); int i = 0; if (ds.Tables[0].Rows.Count > 0) { for (i = 0; i < ds.Tables[0].Rows.Count; i++) { ddlSubject.Items.Insert(i, new ListItem(ds.Tables[0].Rows[i]["SubjectName"].ToString(), ds.Tables[0].Rows[i]["SubjectNo"].ToString())); //ddlSubject.DataSource = ds; //ddlSubject.DataValueField = "SubjectNo"; //ddlSubject.DataTextField = "SubjectName"; //ddlSubject.DataBind(); } } if (ds.Tables[1].Rows.Count > 0) { ddlSubject.Enabled = true; int n = 0; n = i; for (int j = 0; j < ds.Tables[1].Rows.Count; j++) { ddlSubject.Items.Insert(n, new ListItem(ds.Tables[1].Rows[j]["SubjectName"].ToString(), ds.Tables[1].Rows[j]["SubjectNo"].ToString())); n = n + 1; } } if (ds.Tables[0].Rows.Count < 1 && ds.Tables[1].Rows.Count < 1) { ddlSubject.Enabled = false; } else { ddlSubject.Enabled = true; } } } }
public static List <string> studsmartno(string Smart_No) { string data = string.Empty; List <string> details = new List <string>(); try { if (Smart_No.Trim() != "" && Smart_No.Length >= 10) { DataSet ds = new DataSet(); DataSet ds1 = new DataSet(); DataSet ds2 = new DataSet(); DAccess2 DA = new DAccess2(); string stud_condition = ""; string staff_condition = ""; if (chosedmode == 0) { stud_condition = " and smart_serial_no='" + Smart_No + "'"; staff_condition = " and Smartcard_serial_no='" + Smart_No + "'"; string messatt_settings = ""; string q1 = ""; System.Web.UI.WebControls.Image lbl_studimage = new System.Web.UI.WebControls.Image(); lbl_studimage.ImageUrl = "../images/dummyimg.png"; lbl_studimage.Visible = true; if (stud_condition.Trim() != "") { q1 = " select r.app_no,r.Reg_No,r.college_code ,roll_no,Stud_Name,Stud_Type,r.degree_code,Branch_code,Batch_Year,Sections,((CONVERT(varchar(max), r.Batch_Year)+' - '+C.Course_Name+' - '+dt.dept_acronym+ case when sections='' then '' else ' - '+ (sections) end)) as batch from Registration r,Degree d,Department dt,course c where d.Dept_Code=dt.Dept_Code and c.Course_Id=d.Course_Id and r.degree_code=d.Degree_Code " + stud_condition + " and r.college_code='" + coll_code + "'"; ds = DA.select_method_wo_parameter(q1, "Text"); } if (ds.Tables[0].Rows.Count > 0) { string rollno = Convert.ToString(ds.Tables[0].Rows[0]["roll_no"]); details.Add(rollno); details.Add(Convert.ToString(ds.Tables[0].Rows[0]["Stud_Name"])); details.Add(Convert.ToString(ds.Tables[0].Rows[0]["Stud_Type"])); details.Add(Convert.ToString(ds.Tables[0].Rows[0]["batch"])); lbl_studimage.Visible = true; string type = ""; lbl_studimage.ImageUrl = "../Handler/Handler4.ashx?rollno=" + rollno + ""; details.Add(Convert.ToString(lbl_studimage.ImageUrl)); string app_no = Convert.ToString(ds.Tables[0].Rows[0]["app_no"]); string clgcode = Convert.ToString(ds.Tables[0].Rows[0]["college_code"]); DataView alreadyregstud = new DataView(); DataView alreadyregstud1 = new DataView(); if (app_no.Trim() != "") { q1 = ""; q1 = "if exists(select * from Late_attendance where App_No='" + app_no + "' and FromDate='" + DateTime.Now.ToString("MM/dd/yyyy") + "' and college_code='" + clgcode + "') update Late_attendance set FromTime='" + DateTime.Now.ToString("h:mm:ss tt") + "' where App_No='" + app_no + "' and FromDate='" + DateTime.Now.ToString("MM/dd/yyyy") + "' and college_code='" + clgcode + "' else insert into Late_attendance (App_No,FromDate,FromTime,college_code,AttnMonth,AttnYear)values('" + app_no + "','" + DateTime.Now.ToString("MM/dd/yyyy") + "','" + DateTime.Now.ToString("h:mm:ss tt") + "','" + clgcode + "','" + DateTime.Now.ToString("MM") + "','" + DateTime.Now.ToString("yyyy") + "')"; //q1 = "insert into Late_attendance (App_No,FromDate,FromTime,college_code,AttnMonth,AttnYear)values('" + app_no + "','" + DateTime.Now.ToString("MM/dd/yyyy") + "','" + DateTime.Now.ToString("h:mm:ss tt") + "','" + clgcode + "','" + DateTime.Now.ToString("MM") + "','" + DateTime.Now.ToString("yyyy") + "')"; int up = DA.update_method_wo_parameter(q1, "text"); if (up != 0) { details.Add("1"); details.Add(type); } } q1 = " select * from Late_attendance "; ds1.Clear(); ds1 = DA.select_method_wo_parameter(q1, "Text"); ds1.Tables[0].DefaultView.RowFilter = "AttnMonth='" + DateTime.Now.ToString("MM") + "' and AttnYear ='" + DateTime.Now.ToString("yyyy") + "' and College_Code='" + clgcode + "' and App_No='" + app_no + "' "; alreadyregstud1 = ds1.Tables[0].DefaultView; details.Add(Convert.ToString(ds.Tables[0].Rows[0]["Reg_no"])); details.Add(Convert.ToString(alreadyregstud1.Count)); if (alreadyregstud1.Count >= 4) { sms(clgcode, app_no, Convert.ToString(ds.Tables[0].Rows[0]["Stud_Name"]), DateTime.Now.ToString("h:mm:ss tt"), DateTime.Now.ToString("MM/dd/yyyy")); } } else { details.Clear(); details.Add(""); details.Add(""); details.Add(""); details.Add(""); details.Add(Convert.ToString(lbl_studimage.ImageUrl)); details.Add("0"); details.Add(""); } } } return(details); } catch { details.Clear(); details.Add(""); details.Add(""); details.Add(""); details.Add(""); details.Add(""); details.Add("0"); return(details); } }
//public void load_ddlrollno() //{ // try // { // System.Web.UI.WebControls.ListItem lst1 = new System.Web.UI.WebControls.ListItem("Roll No", "0"); // System.Web.UI.WebControls.ListItem lst2 = new System.Web.UI.WebControls.ListItem("Reg No", "1"); // System.Web.UI.WebControls.ListItem lst3 = new System.Web.UI.WebControls.ListItem("Admin No", "2"); // System.Web.UI.WebControls.ListItem lst4 = new System.Web.UI.WebControls.ListItem("App No", "3"); // System.Web.UI.WebControls.ListItem lst5 = new System.Web.UI.WebControls.ListItem("Name", "4"); // System.Web.UI.WebControls.ListItem lst51 = new System.Web.UI.WebControls.ListItem("Hostel Id", "5"); // //Roll Number or Reg Number or Admission No or Application Number // ddlrollno.Items.Clear(); // string insqry1 = "select value from Master_Settings where settings='Roll No' and usercode ='" + usercode + "' --and college_code ='" + collegecode + "'"; // int save1 = Convert.ToInt32(d2.GetFunction(insqry1)); // if (save1 == 1) // { // //Roll No // ddlrollno.Items.Add(lst1); // } // insqry1 = "select value from Master_Settings where settings='Register No' and usercode ='" + usercode + "' --and college_code ='" + collegecode + "'"; // save1 = Convert.ToInt32(d2.GetFunction(insqry1)); // if (save1 == 1) // { // //RegNo // ddlrollno.Items.Add(lst2); // } // insqry1 = "select value from Master_Settings where settings='Admission No' and usercode ='" + usercode + "' --and college_code ='" + collegecode + "'"; // save1 = Convert.ToInt32(d2.GetFunction(insqry1)); // if (save1 == 1) // { // //Admission No - Roll Admit // ddlrollno.Items.Add(lst3); // } // insqry1 = "select value from Master_Settings where settings='Application No' and usercode ='" + usercode + "' --and college_code ='" + collegecode + "'"; // save1 = Convert.ToInt32(d2.GetFunction(insqry1)); // if (save1 == 1) // { // //App Form Number - Application Number // ddlrollno.Items.Add(lst4); // } // insqry1 = "select value from Master_Settings where settings='Hostel Id' and usercode ='" + usercode + "' --and college_code ='" + collegecode + "'"; // save1 = Convert.ToInt32(d2.GetFunction(insqry1)); // if (save1 == 1) // { // //App Form Number - Application Number // ddlrollno.Items.Add(lst51); // } // if (ddlrollno.Items.Count == 0) // { // ddlrollno.Items.Add(lst1); // } // ddlrollno.Items.Add(lst5); // switch (Convert.ToUInt32(ddlrollno.SelectedItem.Value)) // { // case 0: // txtno.Attributes.Add("placeholder", "Roll No"); // chosedmode = 0; // break; // case 1: // txtno.Attributes.Add("placeholder", "Reg No"); // chosedmode = 1; // break; // case 2: // txtno.Attributes.Add("placeholder", "Admin No"); // chosedmode = 2; // break; // case 3: // txtno.Attributes.Add("placeholder", "App No"); // chosedmode = 3; // break; // case 5: // txtno.Attributes.Add("placeholder", "Hostel Id"); // chosedmode = 5; // break; // } // } // catch { } //} public static void sms(string clgcode, string appno, string outin, string time, string date) { DAccess2 d2 = new DAccess2(); DataSet ds = new DataSet();//barath21.04.17 string user_id = d2.GetFunction("select SMS_User_ID from Track_Value where college_code='" + clgcode + "'"); //string getval = d2.GetUserapi(user_id); //string[] spret = getval.Split('-'); //if (spret.GetUpperBound(0) == 1) //{ // SenderID = spret[0].ToString(); // Password = spret[1].ToString(); // Session["api"] = user_id; // Session["senderid"] = SenderID; //} string mobilenos = string.Empty; string strmsg = " Your Son/Daughter Mr/Miss." + outin + " Entered from College on " + date + " at " + time; accessNew(); if (sms_mom == "1") { string momnum = d2.GetFunction("select parentM_Mobile from applyn where app_no='" + appno + "'"); mobilenos = momnum; // mobilenos = "9585698019"; // mobilenos = "9751471583"; if (mobilenos != "")//barath21.04.17 { int m = d2.send_sms(user_id, clgcode, usercode, mobilenos, strmsg, "0"); //barath 20.04.17 //string strpath = "http://dnd.airsmsmarketing.info/api/sendmsg.php?user="******"&pass="******"&sender=" + SenderID + "&phone=" + mobilenos + "&text=" + strmsg + "&priority=ndnd&stype=normal"; //smsreport(strpath, isst); } } if (sms_dad == "2") { string fathernum = d2.GetFunction("select parentF_Mobile from applyn where app_no='" + appno + "'"); mobilenos = fathernum; // mobilenos = "9585698019"; // mobilenos = "9751471583"; if (mobilenos != "")//barath21.04.17 { int m = d2.send_sms(user_id, clgcode, usercode, mobilenos, strmsg, "0"); //barath 20.04.17 //string strpath = "http://dnd.airsmsmarketing.info/api/sendmsg.php?user="******"&pass="******"&sender=" + SenderID + "&phone=" + mobilenos + "&text=" + strmsg + "&priority=ndnd&stype=normal"; //smsreport(strpath, isst); } } if (sms_stud == "3") { string studnum = d2.GetFunction("select Student_Mobile from applyn where app_no='" + appno + "'"); mobilenos = studnum; // mobilenos = "9585698019"; // mobilenos = "9751471583"; if (mobilenos != "") //barath21.04.17 { int m = d2.send_sms(user_id, clgcode, usercode, mobilenos, strmsg, "0"); //barath 20.04.17 //string strpath = "http://dnd.airsmsmarketing.info/api/sendmsg.php?user="******"&pass="******"&sender=" + SenderID + "&phone=" + mobilenos + "&text=" + strmsg + "&priority=ndnd&stype=normal"; //smsreport(strpath, isst); } } }
protected void txt_noofstars_textchange(object sender, EventArgs e) { try { string returnValue = "1"; DAccess2 dd = new DAccess2(); string user_name = txt_noofstars.Text; lbl_noofstars_limit.Text = ""; //string college = ""; //for (int row = 0; row < Cbl_college.Items.Count; row++) //{ // if (Cbl_college.Items[row].Selected == true) // { // if (college == "") // { // college = Cbl_college.Items[row].Value; // } // else // { // college = college + "','" + Cbl_college.Items[row].Value; // } // } //} //clgcode1 = college; if (Convert.ToInt32(txt_noofstars.Text) <= 5) { if (user_name.Trim() != "" && user_name != null) { string query = dd.GetFunction("select distinct No_Of_Stars from CO_MarkMaster where CollegeCode in('" + clgcode1 + "') and No_Of_Stars ='" + user_name + "'"); if (query.Trim() == "" || query == null || query == "0" || query == "-1") { returnValue = "0"; } } else { returnValue = "2"; } switch (returnValue) { case "0": lbl_noofstars_limit.Text = "Star value Does Not Exist"; lbl_noofstars_limit.ForeColor = Color.Green; break; case "1": lbl_noofstars_limit.Text = "Star value Available"; lbl_noofstars_limit.ForeColor = Color.Red; txt_noofstars.Text = ""; break; case "2": lbl_noofstars_limit.Text = "Please Enter Star value"; lbl_noofstars_limit.ForeColor = Color.Red; txt_noofstars.Text = ""; break; case "error": lbl_noofstars_limit.Text = "Error Occurred"; lbl_noofstars_limit.ForeColor = Color.Red; txt_noofstars.Text = ""; break; } } else { //lbl_noofstars_limit.Visible = true; lbl_noofstars_limit.Text = "Enter the Maximum value of 5"; lbl_noofstars_limit.ForeColor = Color.Red; txt_noofstars.Text = ""; } } catch (Exception ex) { d2.sendErrorMail(ex, collegecode1, "Options_Creation"); } }
public static void accessNew() { try { DAccess2 dnew = new DAccess2(); DataSet dsms = new DataSet(); string query = ""; string Master1 = ""; string stud = ""; string values = ""; string sms = ""; string sms1 = ""; string sms2 = ""; sms_mom = ""; sms_dad = ""; sms_stud = ""; if (group_user.Trim() != "" && group_user.Trim() != "0") { Master1 = group_user; query = "select * from Master_Settings where settings ='SMS Mobile Rights' and Group_code ='" + Master1 + "'"; } else if (usercode.Trim() != "") { Master1 = usercode; query = "select * from Master_Settings where settings ='SMS Mobile Rights' and usercode ='" + Master1 + "'"; } dsms = dnew.select_method_wo_parameter(query, "Text"); if (dsms.Tables[0].Rows.Count > 0) { for (int i = 0; i < dsms.Tables[0].Rows.Count; i++) { string val = Convert.ToString(dsms.Tables[0].Rows[i]["value"]); string[] split = val.Split(','); if (split.Length == 1) { sms = split[0]; if (sms == "1") { sms_mom = sms; } else if (sms == "2") { sms_dad = sms; } else if (sms == "3") { sms_stud = sms; } } else if (split.Length == 2) { sms = split[0]; sms1 = split[1]; if (sms == "1") { sms_mom = sms; } else if (sms == "2") { sms_dad = sms; } else if (sms == "3") { sms_stud = sms; } if (sms1 == "1") { sms_mom = sms1; } else if (sms1 == "2") { sms_dad = sms1; } else if (sms1 == "3") { sms_stud = sms1; } } else { sms = split[0]; sms1 = split[1]; sms2 = split[2]; sms_mom = "1"; sms_dad = "2"; sms_stud = "3"; } } } } catch { } }
protected void Page_Load(object sender, EventArgs e) { try { //****************************************************// if (Session["collegecode"] == null) { Response.Redirect("~/Default.aspx"); } if (!Request.FilePath.Contains("CoeHome")) { string strPreviousPage = ""; if (Request.UrlReferrer != null) { strPreviousPage = Request.UrlReferrer.Segments[Request.UrlReferrer.Segments.Length - 1]; } if (strPreviousPage == "") { Response.Redirect("~/CoeMod/CoeHome.aspx"); return; } } //****************************************************// if (!IsPostBack) { Master1 = "select * from Master_Settings where usercode=" + Session["usercode"] + ""; setcon.Close(); setcon.Open(); SqlDataReader mtrdr; Session["Rollflag"] = "0"; Session["Regflag"] = "0"; Session["Studflag"] = "0"; SqlCommand mtcmd = new SqlCommand(Master1, setcon); mtrdr = mtcmd.ExecuteReader(); { if (mtrdr.HasRows) { while (mtrdr.Read()) { if (mtrdr["settings"].ToString() == "Roll No" && mtrdr["value"].ToString() == "1") { Session["Rollflag"] = "1"; } if (mtrdr["settings"].ToString() == "Register No" && mtrdr["value"].ToString() == "1") { Session["Regflag"] = "1"; } } } } DAccess2 da = new DAccess2(); DataSet ds = new DataSet(); ds = da.select_method_wo_parameter("bind_batch", "sp"); if (ds.Tables[0].Rows.Count > 0) { ddlBatch.Items.Clear(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ddlBatch.Items.Add(ds.Tables[0].Rows[i]["batch_year"].ToString()); } } binddegree(); bindbranch(); bindSem(); bindsections(); ddlSubjectType.Items.Insert(0, new ListItem("All", "0")); ddlSubjectType.Items.Insert(1, new ListItem("Regular", "1")); ddlSubjectType.Items.Insert(2, new ListItem("Arear", "2")); ddlSession.Items.Insert(0, new ListItem("F.N", "0")); ddlSession.Items.Insert(1, new ListItem("A.N", "1")); Fpstudents.Sheets[0].RowCount = 1; Fpstudents.Sheets[0].ColumnCount = 6; } Fpstudents.Sheets[0].Columns[0].Width = 60; Fpstudents.Sheets[0].Columns[1].Width = 100; Fpstudents.Sheets[0].Columns[2].Width = 150; Fpstudents.Sheets[0].Columns[3].Width = 250; Fpstudents.Sheets[0].Columns[4].Width = 50; Fpstudents.Sheets[0].Columns[5].Width = 50; Fpstudents.Sheets[0].Columns[0].Locked = true; Fpstudents.Sheets[0].Columns[1].Locked = true; Fpstudents.Sheets[0].Columns[2].Locked = true; Fpstudents.Sheets[0].Columns[3].Locked = true; Fpstudents.Sheets[0].Columns[4].HorizontalAlign = HorizontalAlign.Center; Fpstudents.Sheets[0].Columns[5].HorizontalAlign = HorizontalAlign.Center; Fpstudents.Sheets[0].Columns[3].CellType = cb; Fpstudents.Sheets[0].RowHeader.Visible = false; Fpstudents.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; Fpstudents.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Roll.No"; Fpstudents.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Reg.No"; Fpstudents.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Name"; Fpstudents.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Batch"; Fpstudents.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Select"; FarPoint.Web.Spread.CheckBoxCellType chkcell = new FarPoint.Web.Spread.CheckBoxCellType(); Fpstudents.Sheets[0].Columns[5].CellType = chkcell; Fpstudents.Sheets[0].ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium; Fpstudents.Sheets[0].ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua"; Fpstudents.Sheets[0].ColumnHeader.DefaultStyle.Font.Bold = true; Fpstudents.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium; Fpstudents.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua"; Fpstudents.Sheets[0].DefaultStyle.Font.Bold = false; Fpstudents.CommandBar.Visible = false; //Fpstudents.RowHeader.Visible = false; } catch (Exception ex) { } }
protected void btnGo_Click(object sender, EventArgs e) { lblerror.Visible = false; Fpstudents.Visible = false; string batch = ddlBatch.SelectedValue.ToString(); string degree_code = ddlBranch.SelectedValue.ToString(); string sem = ddlSem.SelectedValue; string subjectno = ddlSubject.SelectedValue.ToString(); string examdate = ""; string examcode = ""; string examdate1 = txtExamDate.Text; string datechangenew = ""; string datechange = ""; if (txtExamDate.Text != "") { string[] splitdate = examdate1.Split(new Char[] { '/' }); string reqdate = splitdate[0].ToString(); string reqmonth = splitdate[1].ToString(); string reqyear = splitdate[2].ToString(); datechange = reqmonth + "-" + reqdate + "-" + reqyear; datechangenew = reqdate + "-" + reqmonth + "-" + reqyear; } if (batch != "" && degree_code != "" && sem != "" && subjectno != "") { string examdatequery = "select convert(varchar(10),exam_date,105) as exam_date,ex.exam_code from exmtt ex,exmtt_det ed where ex.exam_code=ed.exam_code and ex.degree_code=" + degree_code + " and ex.batchto=" + batch + " and ex.semester=" + sem + " and ed.subject_no=" + subjectno + ""; SqlDataAdapter daexamdatequery = new SqlDataAdapter(examdatequery, con5); DataSet dsexamdatequery = new DataSet(); con5.Close(); con5.Open(); daexamdatequery.Fill(dsexamdatequery); if (dsexamdatequery.Tables[0].Rows.Count > 0) { examdate = Convert.ToString(dsexamdatequery.Tables[0].Rows[0]["exam_date"]); examcode = Convert.ToString(dsexamdatequery.Tables[0].Rows[0]["exam_code"]); } if (examdate != "") { if (txBatch.Text != "") { if (txtExamDate.Text != "") { Connection(); int n = Convert.ToInt16(txBatch.Text.ToString()); name = new string[n + 1]; int mm = 0; for (int j = 1; j <= n; j++) { name[j] = ("B" + j); name[0] = " "; } string[] strcomo = new string[] { " " }; cb = new FarPoint.Web.Spread.ComboBoxCellType(name); cb.AutoPostBack = true; Hashtable ht = new Hashtable(); ht.Clear(); DAccess2 da = new DAccess2(); DataSet ds = new DataSet(); if (ddlSem.SelectedValue.ToString() != "" && ddlBranch.SelectedValue.ToString() != "" && ddlSection.SelectedItem.Text.ToString() != "" && ddlBatch.SelectedItem.Text.ToString() != "" && ddlSubject.SelectedValue.ToString() != "") { ht.Add("Semester", ddlSem.SelectedItem.Text.ToString()); ht.Add("CollegeCode", Session["collegecode"].ToString()); ht.Add("DegreeCode", ddlBranch.SelectedValue.ToString()); ht.Add("Sections", ddlSection.SelectedItem.Text.ToString()); ht.Add("BatchYear", ddlBatch.SelectedItem.Text.ToString()); ht.Add("SubjectNo", ddlSubject.SelectedValue.ToString()); ds = da.select_method("ProcBatchAllocationRegNoDetails", ht, "sp"); Fpstudents.Sheets[0].RowCount = 0; Fpstudents.Sheets[0].RowCount = ds.Tables[0].Rows.Count + 1; Fpstudents.Sheets[0].PageSize = ds.Tables[0].Rows.Count + 1 * 20; Fpstudents.Sheets[0].SpanModel.Add(0, 0, 1, 5); FarPoint.Web.Spread.CheckBoxCellType chkcell1 = new FarPoint.Web.Spread.CheckBoxCellType(); Fpstudents.Sheets[0].Cells[0, 5].CellType = chkcell1; Fpstudents.Sheets[0].Cells[0, 5].HorizontalAlign = HorizontalAlign.Center; Fpstudents.Sheets[0].FrozenRowCount = 1; chkcell1.AutoPostBack = true; if (ds.Tables[0].Rows.Count > 0) { btnsave.Visible = true; Fpstudents.Visible = true; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string batch1 = ""; if (txtExamDate.Text != "") { string selectbatch = "select batch from batch_allocation_practical where batch_year=" + ddlBatch.SelectedItem.Text.ToString() + " and degree_code=" + ddlBranch.SelectedValue.ToString() + " and semester=" + ddlSem.SelectedValue.ToString() + " and exam_code=" + examcode + " and subject_no=" + ddlSubject.SelectedValue.ToString() + " and roll_no='" + ds.Tables[0].Rows[i]["RollNo"].ToString() + "' and subject_no=" + subjectno + ""; SqlDataAdapter daselectbatch = new SqlDataAdapter(selectbatch, con5); DataSet dsselectbatch = new DataSet(); con5.Close(); con5.Open(); daselectbatch.Fill(dsselectbatch); if (dsselectbatch.Tables[0].Rows.Count > 0) { batch1 = dsselectbatch.Tables[0].Rows[0]["batch"].ToString(); } } Fpstudents.Sheets[0].Cells[i + 1, 0].Text = Convert.ToString(i + 1); Fpstudents.Sheets[0].Cells[i + 1, 0].HorizontalAlign = HorizontalAlign.Center; Fpstudents.Sheets[0].Cells[i + 1, 1].Text = ds.Tables[0].Rows[i]["RollNo"].ToString(); Fpstudents.Sheets[0].Cells[i + 1, 1].HorizontalAlign = HorizontalAlign.Center; Fpstudents.Sheets[0].Cells[i + 1, 2].Text = ds.Tables[0].Rows[i]["RegNo"].ToString(); Fpstudents.Sheets[0].Cells[i + 1, 2].HorizontalAlign = HorizontalAlign.Center; Fpstudents.Sheets[0].Cells[i + 1, 3].Text = ds.Tables[0].Rows[i]["StudentName"].ToString(); Fpstudents.Sheets[0].Cells[i + 1, 4].CellType = cb; Fpstudents.Sheets[0].SetText(i + 1, 4, batch1); } } int rowcount = Fpstudents.Sheets[0].RowCount; Fpstudents.Sheets[0].RowCount = rowcount; Fpstudents.Height = rowcount * 20; if (Session["Rollflag"] == "0") { Fpstudents.Width = 560; Fpstudents.Sheets[0].Columns[1].Visible = false; } if (Session["Regflag"] == "0") { Fpstudents.Width = 510; Fpstudents.Sheets[0].Columns[2].Visible = false; if (Session["Rollflag"] == "0") { Fpstudents.Width = 410; } } } } else { btnsave.Visible = false; Fpstudents.Visible = false; lblerror.Visible = true; lblerror.Text = "Exam Date Not Filled"; } } else { btnsave.Visible = false; Fpstudents.Visible = false; lblerror.Visible = true; lblerror.Text = "No of Batches not Filled"; //ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "alert('No of Batches is not Filled')", true); } } else { btnsave.Visible = false; Fpstudents.Visible = false; lblerror.Visible = true; lblerror.Text = "Time Table not created for this Subject"; //ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "alert('Time Table is not created for this Subject')", true); } } }
public static List <string> studsmartno(string Smart_No, string j) { string data = string.Empty; List <string> details = new List <string>(); try { if (Smart_No.Trim() != "" && Smart_No.Length >= 10) { DataSet ds = new DataSet(); DataSet ds1 = new DataSet(); DAccess2 DA = new DAccess2(); string[] passedvalue = j.Split('-'); studentcardtype = Convert.ToString(passedvalue[4]); string stud_condition = ""; string staff_condition = ""; if (studentcardtype.Trim() == "0") { stud_condition = " and smart_serial_no='" + Smart_No + "'"; staff_condition = " and Smartcard_serial_no='" + Smart_No + "'"; DateTime date = new DateTime(); string[] split = Convert.ToString(passedvalue[3]).Split('/'); date = Convert.ToDateTime(split[1] + "/" + split[0] + "/" + split[2]); string scheduledate = Convert.ToString(date.ToString("dddd")); string messatt_settings = ""; messatt_settings = DA.GetFunction("select mess_attendance_set from HostelIns_settings where Schedule_date='" + date.ToString("MM/dd/yyyy") + "' and Session_code='" + Convert.ToString(passedvalue[1]) + "' and Hostel_code='" + Convert.ToString(passedvalue[2]) + "'"); if (messatt_settings.Trim() == "0") { messatt_settings = DA.GetFunction("select mess_attendance_set from HostelIns_settings where Schedule_Day='" + scheduledate + "' and Session_code='" + Convert.ToString(passedvalue[1]) + "' and Hostel_code='" + Convert.ToString(passedvalue[2]) + "'"); } string isstaff = "0"; System.Web.UI.WebControls.Image lbl_studimage = new System.Web.UI.WebControls.Image(); lbl_studimage.ImageUrl = "../images/dummyimg.png"; lbl_studimage.Visible = true; if (messatt_settings.Length > 0) { string[] messatt_set = messatt_settings.Split(','); string q1 = ""; if (stud_condition.Trim() != "" || staff_condition.Trim() != "") { ds.Clear(); if (messatt_set.Contains("S")) { if (staff_condition.Trim() != "") { q1 = " select sa.appl_id as app_no,s.staff_Code as roll_no,s.staff_name as Stud_Name,desig_name as batch,sa.staff_type as Stud_Type,s.college_code from staffmaster s,staff_appl_master sa where s.appl_no=sa.appl_no and settled=0 and resign =0 " + staff_condition + ""; isstaff = "1"; ds = DA.select_method_wo_parameter(q1, "Text"); } else { q1 = " select r.app_no,r.college_code ,roll_no,Stud_Name,Stud_Type,r.degree_code,Branch_code,Batch_Year,Sections,((CONVERT(varchar(max), r.Batch_Year)+' - '+C.Course_Name+' - '+dt.dept_acronym+ case when sections='' then '' else ' - '+ (sections) end)) as batch from Registration r,Degree d,Department dt,course c where d.Dept_Code=dt.Dept_Code and c.Course_Id=d.Course_Id and r.degree_code=d.Degree_Code " + stud_condition + ""; ds = DA.select_method_wo_parameter(q1, "Text"); isstaff = "0"; } } if (ds.Tables[0].Rows.Count == 0) { if (stud_condition.Trim() != "") { q1 = " select r.app_no,r.college_code ,roll_no,Stud_Name,Stud_Type,r.degree_code,Branch_code,Batch_Year,Sections,((CONVERT(varchar(max), r.Batch_Year)+' - '+C.Course_Name+' - '+dt.dept_acronym+ case when sections='' then '' else ' - '+ (sections) end)) as batch from Registration r,Degree d,Department dt,course c where d.Dept_Code=dt.Dept_Code and c.Course_Id=d.Course_Id and r.degree_code=d.Degree_Code " + stud_condition + ""; ds = DA.select_method_wo_parameter(q1, "Text"); isstaff = "0"; } } q1 = " select roll_no,Entry_Date,Session_Code,Hostel_Code,College_Code from HostelMess_Attendance "; ds1.Clear(); ds1 = DA.select_method_wo_parameter(q1, "Text"); if (ds.Tables[0].Rows.Count > 0) { string rollno = Convert.ToString(ds.Tables[0].Rows[0]["roll_no"]); details.Add(rollno); details.Add(Convert.ToString(ds.Tables[0].Rows[0]["Stud_Name"])); details.Add(Convert.ToString(ds.Tables[0].Rows[0]["Stud_Type"])); details.Add(Convert.ToString(ds.Tables[0].Rows[0]["batch"])); lbl_studimage.Visible = true; string type = ""; if (isstaff == "1") { type = "1"; lbl_studimage.ImageUrl = "../Handler/staffphoto.ashx?staff_code=" + rollno; } else { type = "0"; lbl_studimage.ImageUrl = "../Handler/Handler4.ashx?rollno=" + rollno; } details.Add(Convert.ToString(lbl_studimage.ImageUrl)); string app_no = Convert.ToString(ds.Tables[0].Rows[0]["app_no"]); string clgcode = Convert.ToString(ds.Tables[0].Rows[0]["college_code"]); DataView alreadyregstud = new DataView(); ds1.Tables[0].DefaultView.RowFilter = "Entry_Date='" + DateTime.Now.ToString("MM/dd/yyyy") + "' and Session_Code='" + Convert.ToString(passedvalue[1]) + "' and Hostel_Code='" + Convert.ToString(passedvalue[2]) + "' and College_Code='" + clgcode + "' and Roll_No='" + rollno + "' "; alreadyregstud = ds1.Tables[0].DefaultView; if (alreadyregstud.Count == 0) { if (app_no.Trim() != "") { q1 = ""; q1 = "insert into HostelMess_Attendance (roll_no,entry_date,Entry_time,session_name,session_code, is_staff, Hostel_code,college_code,app_no)values('" + rollno + "','" + DateTime.Now.ToString("MM/dd/yyyy") + "','" + DateTime.Now.ToString("h:mm:ss tt") + "','" + Convert.ToString(passedvalue[0]) + "','" + Convert.ToString(passedvalue[1]) + "','" + isstaff + "','" + Convert.ToString(passedvalue[2]) + "','" + clgcode + "','" + app_no + "')"; int up = DA.update_method_wo_parameter(q1, "text"); if (up != 0) { details.Add("1"); details.Add(type); } } } else { details.Clear(); details.Add(""); details.Add(""); details.Add(""); details.Add(""); lbl_studimage.ImageUrl = "../images/dummyimg.png"; details.Add(Convert.ToString(lbl_studimage.ImageUrl)); details.Add("2"); details.Add(""); } } else { details.Clear(); details.Add(""); details.Add(""); details.Add(""); details.Add(""); details.Add(Convert.ToString(lbl_studimage.ImageUrl)); details.Add("0"); details.Add(""); } } else { details.Clear(); details.Add(""); details.Add(""); details.Add(""); details.Add(""); details.Add(Convert.ToString(lbl_studimage.ImageUrl)); details.Add("0"); details.Add(""); } } } } return(details); } catch { details.Clear(); details.Add(""); details.Add(""); details.Add(""); details.Add(""); details.Add(""); details.Add("0"); return(details); } }
public void bindSem() { Connection(); DAccess2 das = new DAccess2(); DataSet dss = new DataSet(); ddlSem.Items.Clear(); string duration = ""; Boolean first_year = false; ht.Clear(); ht.Add("degree_code", ddlBranch.SelectedValue.ToString()); ht.Add("batch_year", ddlBatch.SelectedItem.Text.ToString()); ht.Add("college_code", Session["collegecode"].ToString()); dss = das.select_method("bind_sem", ht, "sp"); int count3 = dss.Tables[0].Rows.Count; if (count3 > 0) { ddlSem.Enabled = true; duration = dss.Tables[0].Rows[0][0].ToString(); first_year = Convert.ToBoolean(dss.Tables[0].Rows[0][1].ToString()); for (int loop_val = 1; loop_val <= Convert.ToInt16(duration); loop_val++) { if (first_year == false) { ddlSem.Items.Add(loop_val.ToString()); } else if (first_year == true && loop_val != 2) { ddlSem.Items.Add(loop_val.ToString()); } } } else { count3 = dss.Tables[1].Rows.Count; if (count3 > 0) { ddlSem.Enabled = true; duration = dss.Tables[1].Rows[0][0].ToString(); first_year = Convert.ToBoolean(dss.Tables[1].Rows[0][1].ToString()); for (int loop_val = 1; loop_val <= Convert.ToInt16(duration); loop_val++) { if (first_year == false) { ddlSem.Items.Add(loop_val.ToString()); } else if (first_year == true && loop_val != 2) { ddlSem.Items.Add(loop_val.ToString()); } } } else { ddlSem.Enabled = false; } } }