private bool CheckedStr(ref string MyErr) { bool MyFlag = true; try { FpSpread.SaveChanges(); for (int s = 1; s < FpSpread.Sheets[0].RowCount; s++) { byte Check = Convert.ToByte(FpSpread.Sheets[0].Cells[s, 1].Value); if (Check == 1) { string InTime = Convert.ToString(FpSpread.Sheets[0].Cells[s, 5].Text); string StaffName = Convert.ToString(FpSpread.Sheets[0].Cells[s, 3].Text); if (String.IsNullOrEmpty(InTime)) { MyErr = "Please Set the InTime for the Staff '" + StaffName + "'!"; MyFlag = false; return(MyFlag); } } } } catch { } return(MyFlag); }
protected void btnSetTime_Click(object sender, EventArgs e) { try { lblMainErr.Visible = false; string InTime = string.Empty; InTime = Convert.ToString(ddlHr.SelectedItem.Text) + ":" + Convert.ToString(ddlMin.SelectedItem.Text) + " " + Convert.ToString(ddlMer.SelectedItem.Text); if (CheckedOK()) { for (int st = 1; st < FpSpread.Sheets[0].RowCount; st++) { FpSpread.SaveChanges(); byte Check = Convert.ToByte(FpSpread.Sheets[0].Cells[st, 1].Value); if (Check == 1) { FpSpread.Sheets[0].Cells[st, 5].Text = InTime; FpSpread.Sheets[0].Cells[st, 1].Value = 0; } } } else { lblMainErr.Visible = true; lblMainErr.Text = "Please Select Any Staff!"; } } catch { } }
protected void btnRemove_Click(object sender, EventArgs e) { try { lblMainErr.Visible = false; if (CheckedOK()) { for (int st = 1; st < FpSpread.Sheets[0].RowCount; st++) { FpSpread.SaveChanges(); byte Check = Convert.ToByte(FpSpread.Sheets[0].Cells[st, 1].Value); if (Check == 1) { FpSpread.Sheets[0].Cells[st, 5].Text = ""; FpSpread.Sheets[0].Cells[st, 1].Value = 0; } } } else { lblMainErr.Visible = true; lblMainErr.Text = "Please Select Any Staff!"; } } catch { } }
protected void btnresetpriority_Click(object sender, EventArgs e) { try { if (FpSpread.Sheets[0].Rows.Count > 0 && chkpriority.Checked) { for (i = 0; i < FpSpread.Sheets[0].Rows.Count; i++) { string collcode = Convert.ToString(ddlcoll.SelectedValue); string priority = Convert.ToString(FpSpread.Sheets[0].Cells[i, 4].Text.Trim()); string staffcode = Convert.ToString(FpSpread.Sheets[0].Cells[i, 1].Text); FpSpread.Sheets[0].Cells[i, 3].Locked = false; FpSpread.Sheets[0].Cells[i, 3].Value = 0; FpSpread.Sheets[0].Cells[i, 4].Text = ""; if (priority.Trim() != "" && priority.Trim() != "0") { priority = "0"; int insQ = d2.update_method_wo_parameter("update staffmaster set PrintPriority=" + priority + " where staff_code='" + staffcode + "' and college_code=" + collcode + "", "Text"); } } } FpSpread.SaveChanges(); } catch { } }
protected void Fpspread_render(object sender, EventArgs e) { try { if (flag_true == true) { FpSpread.SaveChanges(); string activrow = ""; activrow = FpSpread.Sheets[0].ActiveRow.ToString(); string activecol = FpSpread.Sheets[0].ActiveColumn.ToString(); int actcol = Convert.ToInt16(activecol); int hy_order = 0; for (i = 0; i <= Convert.ToInt16(FpSpread.Sheets[0].RowCount) - 1; i++) { int isval = Convert.ToInt32(FpSpread.Sheets[0].Cells[i, actcol].Value); if (isval == 1) { hy_order++; FpSpread.Sheets[0].Cells[Convert.ToInt32(activrow), actcol].Locked = true; } } FpSpread.Sheets[0].Cells[Convert.ToInt32(activrow), actcol + 1].Text = hy_order.ToString(); } } catch { } }
protected void Fpspread_buttoncommand(object sender, EventArgs e) { try { FpSpread.SaveChanges(); string activerow = FpSpread.ActiveSheetView.ActiveRow.ToString(); string activecol = FpSpread.ActiveSheetView.ActiveColumn.ToString(); if (activecol == "3") { int act1 = Convert.ToInt32(activerow); int act2 = Convert.ToInt16(activecol); if (FpSpread.Sheets[0].Cells[act1, act2].Value.ToString() == "1") { flag_true = true; FpSpread.Sheets[0].Cells[act1, act2 + 1].Text = ""; } else { flag_true = false; } } FpSpread.SaveChanges(); } catch { } }
protected void FpSpread_Command(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e) { try { FpSpread.SaveChanges(); Dictionary <string, string> diclea = new Dictionary <string, string>(); // int countvalue1 = Convert.ToInt32(Session["item_Value"]); // countvalue1 = countvalue1 + 3; string actrow = FpSpread.Sheets[0].ActiveRow.ToString(); //e.SheetView.ActiveRow.ToString(); string actcol = FpSpread.Sheets[0].ActiveColumn.ToString(); //e.SheetView.ActiveColumn.ToString(); string txtval = Convert.ToString(FpSpread.Sheets[0].Cells[Convert.ToInt32(actrow), Convert.ToInt32(actcol)].Text); string last = e.CommandArgument.ToString(); if (actrow != "0") { if (actrow == last) { flag_true = false; } else { flag_true = true; } } if (actcol == "1") { if (actrow == last) { flag_true = false; } else { flag_true = true; } } if (flag_true == false) { string setval = "select * from leave_category where college_code='" + Session["collegecode"].ToString() + "'"; DataSet dsleavval = d2.select_method_wo_parameter(setval, "text"); for (int li = 0; li < dsleavval.Tables[0].Rows.Count; li++) { if (!diclea.ContainsKey(dsleavval.Tables[0].Rows[li]["shortname"].ToString().Trim().ToLower())) { diclea.Add(dsleavval.Tables[0].Rows[li]["shortname"].ToString().Trim().ToLower(), dsleavval.Tables[0].Rows[li]["shortname"].ToString().Trim().ToLower()); } } } } catch (Exception ex) { } }
private bool CheckedOK() { bool EntryFlag = false; try { FpSpread.SaveChanges(); for (int s = 1; s < FpSpread.Sheets[0].RowCount; s++) { byte Check = Convert.ToByte(FpSpread.Sheets[0].Cells[s, 1].Value); if (Check == 1) { EntryFlag = true; } } } catch { } return(EntryFlag); }
protected bool checkvalue() { bool chkspr = true; string sprstaffcode = ""; FpSpread.SaveChanges(); try { for (ik = 0; ik < FpSpread.Sheets[0].RowCount; ik++) { sprstaffcode = Convert.ToString(FpSpread.Sheets[0].Cells[ik, 0].Text); if (sprstaffcode.Trim() == "") { chkspr = false; } } } catch { } return(chkspr); }
protected bool checkstaffcode() { bool chkspr = true; string staffcode = Convert.ToString(ddlstafflst.SelectedValue); string sprstaffcode = ""; FpSpread.SaveChanges(); try { for (ik = 0; ik < FpSpread.Sheets[0].RowCount; ik++) { sprstaffcode = Convert.ToString(FpSpread.Sheets[0].Cells[ik, 1].Text); if (staffcode == sprstaffcode) { chkspr = false; } } } catch { } return(chkspr); }
protected void btnexcel_Click(object sender, EventArgs e) { try { FpSpread.SaveChanges(); string reportname = txtexcel.Text; if (reportname.ToString().Trim() != "") { txtexcel.Text = ""; d2.printexcelreport(FpSpread, reportname); lblerror.Visible = false; } else { lblerror.Text = "Please Enter Your Report Name"; lblerror.Visible = true; } btnprintmaster.Focus(); } catch { } }
protected void FpSpread_Command(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e) { try { FpSpread.SaveChanges(); byte Check = Convert.ToByte(FpSpread.Sheets[0].Cells[0, 1].Value); if (Check == 1) { for (int sel = 1; sel < FpSpread.Sheets[0].RowCount; sel++) { FpSpread.Sheets[0].Cells[sel, 1].Value = 1; } } else { for (int sel = 1; sel < FpSpread.Sheets[0].RowCount; sel++) { FpSpread.Sheets[0].Cells[sel, 1].Value = 0; } } } catch { } }
protected void btnSave_Click(object sender, EventArgs e) { try { lblMainErr.Visible = false; string MyErrTxt = string.Empty; string Intime = string.Empty; string StaffCode = string.Empty; string StaffApplID = string.Empty; string InsQ = string.Empty; int insCount = 0; string PayMonth = Convert.ToString(ddlMon.SelectedItem.Value); string PayYear = Convert.ToString(ddlYear.SelectedItem.Text); DateTime dtFrm = new DateTime(); DateTime dtTo = new DateTime(); dtFrm = GetMonFrstDate(txtFrmDt.Text); dtTo = GetMonFrstDate(txtToDt.Text); DataSet MyDs = new DataSet(); DataView dvnew = new DataView(); if (CheckedOK()) { if (CheckedStr(ref MyErrTxt)) { string GetApplID = "select appl_id,sm.staff_code from staff_appl_master sa,staffmaster sm,stafftrans st where sa.appl_no=sm.appl_no and st.staff_code=sm.staff_code and st.latestrec='1' and sm.resign='0' and sm.settled='0' and ISNULL(Discontinue,'0')='0' and sm.college_code='" + clgcode + "'"; MyDs.Clear(); MyDs = d2.select_method_wo_parameter(GetApplID, "Text"); for (int st = 1; st < FpSpread.Sheets[0].RowCount; st++) { FpSpread.SaveChanges(); byte Check = Convert.ToByte(FpSpread.Sheets[0].Cells[st, 1].Value); if (Check == 1) { StaffCode = Convert.ToString(FpSpread.Sheets[0].Cells[st, 2].Text); Intime = Convert.ToString(FpSpread.Sheets[0].Cells[st, 5].Text); if (MyDs.Tables.Count > 0 && MyDs.Tables[0].Rows.Count > 0) { MyDs.Tables[0].DefaultView.RowFilter = " Staff_Code='" + StaffCode + "'"; dvnew = MyDs.Tables[0].DefaultView; if (dvnew.Count > 0) { StaffApplID = Convert.ToString(dvnew[0]["appl_id"]); } } InsQ = "if exists(select * from Staff_InOut_BellTime_Individual where StaffApplID='" + StaffApplID + "' and StaffCode='" + StaffCode + "' and PayMonth='" + PayMonth + "' and Payyear='" + PayYear + "') Update Staff_InOut_BellTime_Individual set IN_Time='" + Intime + "',FromDate='" + dtFrm.ToString("MM/dd/yyyy") + "',Todate='" + dtTo.ToString("MM/dd/yyyy") + "' where StaffApplID='" + StaffApplID + "' and StaffCode='" + StaffCode + "' and PayMonth='" + PayMonth + "' and Payyear='" + PayYear + "' else insert into Staff_InOut_BellTime_Individual (StaffApplID,StaffCode,IN_Time,FromDate,Todate,PayMonth,Payyear) values ('" + StaffApplID + "','" + StaffCode + "','" + Intime + "','" + dtFrm.ToString("MM/dd/yyyy") + "','" + dtTo.ToString("MM/dd/yyyy") + "','" + PayMonth + "','" + PayYear + "')"; int myCount = d2.update_method_wo_parameter(InsQ, "Text"); if (myCount > 0) { insCount += 1; } } } if (insCount > 0) { alertpopwindow.Visible = true; lblalerterr.Text = "Bell Time Settings Saved Successfully!"; } } else { lblMainErr.Visible = true; lblMainErr.Text = MyErrTxt; } } else { lblMainErr.Visible = true; lblMainErr.Text = "Please Select Any Staff!"; } } catch { } }
public void btn_go_Click(object sender, EventArgs e) { try { if (txt_staffCode.Text != "--Select--") { DataSet ds = new DataSet(); ds.Clear(); string appl_id = string.Empty; string staff_code = string.Empty; if (cbl_staffCode.Items.Count > 0) { for (int i = 0; i < cbl_staffCode.Items.Count; i++) { if (cbl_staffCode.Items[i].Selected == true) { string staffCode = Convert.ToString(cbl_staffCode.Items[i].Value); string applno = d2.GetFunction("select appl_no from staffmaster where staff_code='" + staffCode + "'"); string applid = d2.GetFunction("select appl_id from staff_appl_master where appl_no='" + applno + "'"); if (appl_id == "") { appl_id = applid; } else { appl_id = appl_id + "','" + applid; } } } string getFromDate = Convert.ToString(txtfrom.Text); string getTodate = Convert.ToString(txtto.Text); string[] split_f = getFromDate.Split(new Char[] { '/' }); string[] split_t = getTodate.Split(new Char[] { '/' }); string fromdate = split_f[1] + "/" + split_f[0] + "/" + split_f[2]; string todate = split_t[1] + "/" + split_t[0] + "/" + split_t[2]; DateTime fdate = new DateTime(); DateTime tdate = new DateTime(); fdate = Convert.ToDateTime(fromdate); tdate = Convert.ToDateTime(todate); string getcolcode = rs.GetSelectedItemsValueAsString(cbl_clg); string query = "select * from staff_CompensationLeave where holiday_date between '" + fdate + "' and '" + tdate + "' and appl_id in('" + appl_id + "') and college_code in('" + getcolcode + "') order by holiday_date"; ds = d2.select_method_wo_parameter(query, "text"); if (ds.Tables[0].Rows.Count > 0) { divPopAlert.Visible = false; lblAlertMsg.Text = ""; sp_div.Visible = true; FpSpread.Visible = true; FpSpread.Sheets[0].RowCount = 0; FpSpread.Sheets[0].ColumnCount = 0; FpSpread.CommandBar.Visible = false; FpSpread.Sheets[0].AutoPostBack = false; FpSpread.Sheets[0].ColumnHeader.RowCount = 2; FpSpread.Sheets[0].FrozenRowCount = 1; FpSpread.Sheets[0].RowHeader.Visible = false; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.White; FpSpread.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; FpSpread.Sheets[0].ColumnCount++; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Text = "S.No"; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, FpSpread.Sheets[0].ColumnCount - 1, 2, 1); FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true; FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 50; FpSpread.Sheets[0].ColumnCount++; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Text = "Name"; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, FpSpread.Sheets[0].ColumnCount - 1, 2, 1); FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true; FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 250; FpSpread.Sheets[0].ColumnCount++; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Text = "Compensation Date"; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, FpSpread.Sheets[0].ColumnCount - 1, 2, 1); FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true; FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 107; FpSpread.Sheets[0].ColumnCount++; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Text = "Holiday Date"; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, FpSpread.Sheets[0].ColumnCount - 1, 2, 1); FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true; FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 100; FpSpread.Sheets[0].ColumnCount++; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Text = "Worked On Holiday"; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium; FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true; // FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 200; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Text = "M"; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium; FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true; FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 100; FpSpread.Sheets[0].ColumnCount++; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Text = "E"; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium; FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true; FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 100; FpSpread.Sheets[0].ColumnCount++; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Text = "Compensation Leave"; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[0, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, 6, 1, 2); FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true; FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 200; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Text = "M"; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium; FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true; FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 100; FpSpread.Sheets[0].ColumnCount++; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Text = "E"; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[1, FpSpread.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium; FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Locked = true; FpSpread.Columns[FpSpread.Sheets[0].ColumnCount - 1].Width = 100; FpSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, 4, 1, 2); int sno = 0; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { rprint.Visible = true; string appl_ids = Convert.ToString(ds.Tables[0].Rows[i]["appl_id"]); string appl_no = d2.GetFunction("select appl_no from staff_appl_master where appl_id='" + appl_ids + "'"); string staffcode = d2.GetFunction("select staff_code from staffmaster where appl_no='" + appl_no + "'"); string name = d2.GetFunction("select staff_name from staffmaster where appl_no='" + appl_no + "'"); string collegecode = d2.GetFunction("select college_code from staffmaster where appl_no='" + appl_no + "'"); string holidaydate = Convert.ToString(ds.Tables[0].Rows[i]["holiday_date"]); string Leave_Morning = Convert.ToString(ds.Tables[0].Rows[i]["LeaveMorning"]); string Leave_evng = Convert.ToString(ds.Tables[0].Rows[i]["LeaveEvening"]); string compensationdate = Convert.ToString(ds.Tables[0].Rows[i]["compensation_date"]); string morn_lve = string.Empty; string evn_lve = string.Empty; if (Leave_Morning != "0") { morn_lve = d2.GetFunction("select shortname from leave_category where LeaveMasterPK='" + Leave_Morning + "' and college_code='" + collegecode + "'"); } if (Leave_evng != "0") { evn_lve = d2.GetFunction("select shortname from leave_category where LeaveMasterPK='" + Leave_evng + "' and college_code='" + collegecode + "'"); } string monyearval = string.Empty; string getdateval = string.Empty; string commonyear = string.Empty; string comgetdate = string.Empty; string[] splitspace = holidaydate.Split(new char[] { ' ' }); string[] splitval = splitspace[0].Split(new Char[] { '/' }); string monthval = splitval[0].ToString(); string dateval = splitval[1].ToString(); string yearval = splitval[2].ToString(); string dateval1 = (dateval.TrimStart('0')); string monthval1 = (monthval.TrimStart('0')); monyearval = monthval + "/" + yearval; getdateval = dateval + "/" + monthval + "/" + yearval; string[] compdatesplitspace = compensationdate.Split(new char[] { ' ' }); string[] compdatesplitval = compdatesplitspace[0].Split(new Char[] { '/' }); string compmonval = compdatesplitval[0].ToString(); string compdateval = compdatesplitval[1].ToString(); string compyearval = compdatesplitval[2].ToString(); string compdate = (compdateval.TrimStart('0')); string compmonth = (compmonval.TrimStart('0')); comgetdate = compdateval + "/" + compmonval + "/" + compyearval; dateval1 = "[" + dateval1 + "]"; string morning = string.Empty; string evening = string.Empty; string getpresentabs = d2.GetFunction("select " + dateval1 + " from staff_attnd where staff_code='" + staffcode + "' and mon_year='" + monyearval + "'"); if (getpresentabs != "" || getpresentabs != "0") { if (getpresentabs.Contains('-')) { string[] mor_evnf = getpresentabs.Split('-'); morning = Convert.ToString(mor_evnf[0]); evening = Convert.ToString(mor_evnf[1]); } } sno++; FpSpread.Sheets[0].RowCount++; FpSpread.Sheets[0].Cells[i, 0].Text = Convert.ToString(sno); FpSpread.Sheets[0].Cells[i, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].Cells[i, 0].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[i, 0].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[i, 1].Text = Convert.ToString(name); FpSpread.Sheets[0].Cells[i, 1].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[i, 1].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[i, 1].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[i, 2].Text = Convert.ToString(comgetdate); FpSpread.Sheets[0].Cells[i, 2].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[i, 2].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[i, 2].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[i, 3].Text = Convert.ToString(getdateval); FpSpread.Sheets[0].Cells[i, 3].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[i, 3].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[i, 3].Font.Name = "Book Antiqua"; if (morning != "") { FpSpread.Sheets[0].Cells[i, 4].Text = Convert.ToString(morning); } else { FpSpread.Sheets[0].Cells[i, 4].Text = "-"; } FpSpread.Sheets[0].Cells[i, 4].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].Cells[i, 4].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[i, 4].Font.Name = "Book Antiqua"; if (evening != "") { FpSpread.Sheets[0].Cells[i, 5].Text = Convert.ToString(evening); } else { FpSpread.Sheets[0].Cells[i, 5].Text = "-"; } FpSpread.Sheets[0].Cells[i, 5].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].Cells[i, 5].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[i, 5].Font.Name = "Book Antiqua"; if (morn_lve != "") { FpSpread.Sheets[0].Cells[i, 6].Text = Convert.ToString(morn_lve); } else { FpSpread.Sheets[0].Cells[i, 6].Text = "-"; } FpSpread.Sheets[0].Cells[i, 6].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].Cells[i, 6].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[i, 6].Font.Name = "Book Antiqua"; if (evn_lve != "") { FpSpread.Sheets[0].Cells[i, 7].Text = Convert.ToString(evn_lve); } else { FpSpread.Sheets[0].Cells[i, 7].Text = "-"; } FpSpread.Sheets[0].Cells[i, 7].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].Cells[i, 7].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[i, 7].Font.Name = "Book Antiqua"; // FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(staffCode); } FpSpread.SaveChanges(); FpSpread.Visible = true; lblAlertMsg.Text = string.Empty; divPopAlert.Visible = false; // btn_save.Visible = false; FpSpread.Sheets[0].PageSize = FpSpread.Sheets[0].RowCount; FpSpread.SaveChanges(); } else { divPopAlert.Visible = true; lblAlertMsg.Text = "No Records Found"; // btn_save.Visible = false; } } } else { //alert message //please select Atleast one staff divPopAlert.Visible = true; lblAlertMsg.Text = "Please Select Atleast One Staff"; // btn_save.Visible = false; } } catch (Exception ex) { } }
protected void SaveDetails() { try { string degreecode = rs.GetSelectedItemsValue(cbldepartment); string batchyear = Convert.ToString(ddlbatch.SelectedItem.Text); string type = Convert.ToString(ddltype.SelectedItem.Text); string edulevel = Convert.ToString(ddledulevel.SelectedItem.Text); string Query = " select r.App_No,r.roll_no,r.Reg_No,r.Roll_Admit,r.stud_name,case when sex='0' then 'Male' when sex='1' then 'Female' end sex ,r.degree_code,dt.Dept_Name,c.Course_Name ,r.Batch_Year,r.Current_Semester,c.Course_Id,r.sections,h.HostelMasterFK,hm.HostelName,isnull(a.studhouse,'')studhouse from applyn a, degree d,Department dt,Course C,Registration r left join HT_HostelRegistration h on r.App_No=h.APP_No left join hm_hostelmaster hm on h.HostelMasterFK=hm.HostelMasterPK where a.app_no =r.App_No and d.Degree_Code =r.degree_code and d.Dept_Code =dt.Dept_Code and c.Course_Id =d.Course_Id and isconfirm ='1' and c.type ='" + type + "' and c.Edu_Level ='" + edulevel + "' and a.college_code='" + Convert.ToString(ddl_collegename.SelectedItem.Value) + "' and r.batch_year in('" + batchyear + "') and d.Degree_Code in ('" + degreecode + "') order by isnull(d.Dept_Priority,10000),r.Reg_No asc";//c.Course_Id,d.Degree_Code,AdmitedDate"; Query += " select HouseName+'$'+CONVERT(varchar(10), HousePK) as HouseName,Gender,GenderPriority from HousingDetails where collegecode='" + Convert.ToString(ddl_collegename.SelectedItem.Value) + "' order by isnull(HousePriority,0),ISNULL(GenderPriority,0),isnull(OrderBy,0) asc"; ds.Clear(); //ds = d2.select_method_wo_parameter(Query, "Text"); Hashtable HouseDetHash = new Hashtable(); HouseDetHash.Add("stream", type); HouseDetHash.Add("eduLevel", edulevel); HouseDetHash.Add("collegeCode", Convert.ToString(ddl_collegename.SelectedItem.Value)); HouseDetHash.Add("degreecode", degreecode); HouseDetHash.Add("batchYear", batchyear); ds = d2.select_method("AutohouseGeneration", HouseDetHash, "sp"); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { rs.Fpreadheaderbindmethod("S.No-50/Student Name-220/Roll No-150/Reg No-150/Admission No-150/Gender-70/Section-70/" + lblDeg.Text + "-100/" + lblBran.Text + "-200/House Name-180", FpSpread, "FALSE"); int MaleCurrentRow = 0; int FemaleCurrentRow = 0; List <String> MaleHousingArr = new List <string>(); List <String> FemaleHousingArr = new List <string>(); if (ds.Tables[1].Rows.Count > 0) { MaleHousingArr = ds.Tables[1].AsEnumerable().Where(r => r.Field <byte>("Gender") == 0).Select(r => r.Field <String>("HouseName")).ToList <String>(); FemaleHousingArr = ds.Tables[1].AsEnumerable().Where(r => r.Field <byte>("Gender") == 1).Select(r => r.Field <String>("HouseName")).ToList <String>(); } //if (MaleHousingArr.Contains("")) // MaleHousingArr.IndexOf("hha"); foreach (DataRow dr in ds.Tables[0].Rows) { FpSpread.Sheets[0].Rows.Count++; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(FpSpread.Sheets[0].Rows.Count); FpSpread.Sheets[0].Columns[2].Visible = false; FpSpread.Sheets[0].Columns[3].Visible = false; FpSpread.Sheets[0].Columns[4].Visible = false; if (Convert.ToString(Session["Rollflag"]) == "1") { FpSpread.Sheets[0].Columns[2].Visible = true; } if (Convert.ToString(Session["Regflag"]) == "1") { FpSpread.Sheets[0].Columns[3].Visible = true; } if (Convert.ToString(Session["Admissionflag"]) == "1") { FpSpread.Sheets[0].Columns[4].Visible = true; } FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType(); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(dr["App_No"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Note = Convert.ToString(dr["Stud_Type"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(dr["stud_name"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].CellType = txt; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dr["roll_no"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].CellType = txt; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dr["Reg_No"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].CellType = txt; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(dr["Roll_Admit"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dr["sex"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(dr["sections"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Text = Convert.ToString(dr["Course_Name"]); FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Text = Convert.ToString(dr["Dept_Name"]); string studhouse = Convert.ToString(dr["HouseName"]); string studhousePK = Convert.ToString(dr["HousePK"]); string Hostelname = Convert.ToString(dr["HostelName"]); string HousePk = Convert.ToString(dr["HostelMasterFK"]); if (GenerateBool) { if (string.IsNullOrEmpty(Hostelname) && string.IsNullOrEmpty(HousePk) && string.IsNullOrEmpty(studhouse)) { #region Auto Allotment if (Convert.ToString(dr["sex"]).ToUpper() == "MALE") { if (MaleHousingArr.Count <= MaleCurrentRow) { MaleCurrentRow = 0; string[] houseDet = Convert.ToString(MaleHousingArr[MaleCurrentRow]).Split('$'); Hostelname = Convert.ToString(houseDet[0]); HousePk = Convert.ToString(houseDet[1]); MaleCurrentRow++; } else { string[] houseDet = Convert.ToString(MaleHousingArr[MaleCurrentRow]).Split('$'); Hostelname = Convert.ToString(houseDet[0]); HousePk = Convert.ToString(houseDet[1]); MaleCurrentRow++; } } if (Convert.ToString(dr["sex"]).ToUpper() == "FEMALE") { if (FemaleHousingArr.Count <= FemaleCurrentRow) { FemaleCurrentRow = 0; string[] houseDet = Convert.ToString(FemaleHousingArr[FemaleCurrentRow]).Split('$'); Hostelname = Convert.ToString(houseDet[0]); HousePk = Convert.ToString(houseDet[1]); FemaleCurrentRow++; } else { string[] houseDet = Convert.ToString(FemaleHousingArr[FemaleCurrentRow]).Split('$'); Hostelname = Convert.ToString(houseDet[0]); HousePk = Convert.ToString(houseDet[1]); FemaleCurrentRow++; } } #endregion } else { if (string.IsNullOrEmpty(Hostelname)) { Hostelname = Convert.ToString(dr["HouseName"]); HousePk = Convert.ToString(dr["HousePK"]); string HouseName = Hostelname + '$' + HousePk; if (Convert.ToString(dr["sex"]).ToUpper() == "MALE") { if (MaleHousingArr.Count <= MaleCurrentRow) { if (MaleHousingArr.Contains(HouseName)) { //MaleCurrentRow = MaleHousingArr.IndexOf(HouseName); MaleCurrentRow = 0; } } else { if (MaleHousingArr.Contains(HouseName)) { MaleCurrentRow = MaleHousingArr.IndexOf(HouseName); MaleCurrentRow++; } } } if (Convert.ToString(dr["sex"]).ToUpper() == "FEMALE") { if (FemaleHousingArr.Count <= FemaleCurrentRow) { if (FemaleHousingArr.Contains(HouseName)) { //FemaleCurrentRow = FemaleHousingArr.IndexOf(HouseName); FemaleCurrentRow = 0; } } else { if (FemaleHousingArr.Contains(HouseName)) { FemaleCurrentRow = FemaleHousingArr.IndexOf(HouseName); FemaleCurrentRow++; } } } //if (Convert.ToString(dr["sex"]).ToUpper() == "MALE") //{ // if (MaleHousingArr.Count <= MaleCurrentRow) // { // MaleCurrentRow = 0; // Hostelname = Convert.ToString(dr["HouseName"]); // HousePk = Convert.ToString(dr["HousePK"]); // MaleCurrentRow++; // } // else // { // Hostelname = Convert.ToString(dr["HouseName"]); // HousePk = Convert.ToString(dr["HousePK"]); // MaleCurrentRow++; // } //} //if (Convert.ToString(dr["sex"]).ToUpper() == "FEMALE") //{ // if (FemaleHousingArr.Count <= FemaleCurrentRow) // { // FemaleCurrentRow = 0; // Hostelname = Convert.ToString(dr["HouseName"]); // HousePk = Convert.ToString(dr["HousePK"]); // FemaleCurrentRow++; // } // else // { // Hostelname = Convert.ToString(dr["HouseName"]); // HousePk = Convert.ToString(dr["HousePK"]); // FemaleCurrentRow++; // } //} } } } else { if (string.IsNullOrEmpty(Hostelname)) { Hostelname = Convert.ToString(dr["HouseName"]); HousePk = Convert.ToString(dr["HousePK"]); } } FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Text = Hostelname; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Tag = HousePk; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Locked = true; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].HorizontalAlign = HorizontalAlign.Left; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Font.Size = FontUnit.Medium; FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Font.Name = "Book Antiqua"; } FpSpread.Sheets[0].PageSize = FpSpread.Sheets[0].RowCount; FpSpread.Visible = true; FpSpread.SaveChanges(); lbl_error.Visible = false; rprint.Visible = true; } else { rprint.Visible = false; FpSpread.Visible = false; lbl_error.Visible = true; lbl_error.Text = "No Record Founds"; } } catch (Exception ex) { alertpopwindow.Visible = true; lblalerterr.Text = ex.ToString(); } }