protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { EncryptedQueryString args = new EncryptedQueryString(Request.QueryString["args"]); if (args.Count < 1) { btnReset.Enabled = false; throw new Exception("Invalid User!"); } foreach (var arg in args) { Label label = new Label(); label.Text = String.Format("{0}={1}", arg.Key, HttpUtility.HtmlEncode(arg.Value)); login_id = label.Text; } if (login_id == "") { btnReset.Enabled = false; throw new Exception("Invalid User!"); } string[] b = login_id.Split('='); login_id = b[1]; } catch (Exception ex) { lbResponse.ForeColor = System.Drawing.ColorTranslator.FromHtml("#CC0000"); lbResponse.Text = ex.Message; } } }
protected void btnforget_Click(object sender, EventArgs e) { using (PhotoProcessingDataContext dataDB = new PhotoProcessingDataContext()) { var counter = from a in dataDB.Photo_CustomerRegistrationDetails where a.Email == txtEmail.Text select a; if (counter.Count()==1) { var getval = counter.FirstOrDefault(); EncryptedQueryString args = new EncryptedQueryString(); args["arg1"] = txtEmail.Text; string url = string.Format("http://*****:*****@gmail.com"); msg.To.Add(txtEmail.Text); msg.Subject = "Activation Mail From icons"; StringBuilder sb = new StringBuilder(); sb.Append("<table><tr><td colspan='2'>Hi, " +getval.Full_Name + "</td></tr><tr><td colspan='2'></td></tr><tr><td colspan='2'>Thank you for registering with us! .</td></tr><tr><td colspan='2'></td></tr><tr><td colspan='2'>Click on the link below to activate your account:</td></tr><tr><td colspan='2'></td></tr><tr><td>Login URL :</td><td>" + url + "</td></tr><tr><td colspan='2'></td></tr><tr><td colspan='2'>Click is not possible means <a href=" + url + ">click here</a></td></tr><tr><td colspan='2'></td></tr><tr><td>Account Detail:</td></tr><tr><td colspan='2'></td></tr><tr><td colspan='2'><table><tr><td> Email:</td><td>" + txtEmail.Text + "</td></tr></table></td></tr><tr><td colspan='2'></td></tr><tr><td colspan='2'>Thank you,</td></tr><tr><td colspan='2'>Edit My Photos</td></tr><tr><td colspan='2'>www.i-constech.com</td></tr></table>"); msg.Body = sb.ToString(); msg.IsBodyHtml = true; msg.Priority = MailPriority.High; MailSender ms = new MailSender(); ms.SendMailUsingGmail(msg); lbResponse.ForeColor = System.Drawing.ColorTranslator.FromHtml("#006600"); lbResponse.Text = "Password Link sent to your Mail Id!"; } else { lbResponse.ForeColor = System.Drawing.ColorTranslator.FromHtml("#CC0000"); lbResponse.Text = "Invalid Email Id!"; } } }
protected void gvSponsorships_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { DataRowView row = (DataRowView)e.Row.DataItem; string url = Utility.GetBBISPageUrl(MyContent.MoreInfoPageID); string moreInfoUrl = url + "{0}id=" + row["ID"]; moreInfoUrl = moreInfoUrl.IndexOf("?") > -1 ? String.Format(moreInfoUrl, "&") : String.Format(moreInfoUrl, "?"); moreInfoUrl = moreInfoUrl + "&sponsored=y"; ((LinkButton)e.Row.FindControl("lnkNo")).PostBackUrl = moreInfoUrl; ((LinkButton)e.Row.FindControl("lnkName")).PostBackUrl = moreInfoUrl; ((ImageButton)e.Row.FindControl("imgThumbnail")).ImageUrl = "ImageHandler.ashx?context=sponsorship&type=" + MyContent.ThumbnailNoteType + "&id=" + row["Id"]; ((ImageButton)e.Row.FindControl("imgThumbnail")).PostBackUrl = moreInfoUrl; if (e.Row.FindControl("lnkEmail") != null) { var lnkEmail = (HyperLink)e.Row.FindControl("lnkEmail"); EncryptedQueryString args = new EncryptedQueryString(); args["CHILDID"] = row["Child No"].ToString(); args["CHILDNAME"] = row["Child Name"].ToString(); args["SPONSORID"] = row["SPONSORID"].ToString(); //need to get this args["SPONSORNAME"] = row["SPONSORNAME"].ToString(); //need to get this string emailUrl = string.Concat(Utility.GetBBISPageUrl(MyContent.EmailPageID), string.Format("?args={0}", args.ToString())); lnkEmail.NavigateUrl = emailUrl; } } }
protected void SendCommand_Click(object sender, EventArgs e) { EncryptedQueryString QueryString = new EncryptedQueryString(); QueryString.Add("MyData", MyData.Text); QueryString.Add("MyTime", DateTime.Now.ToLongTimeString()); QueryString.Add("MyDate", DateTime.Now.ToLongDateString()); Response.Redirect("QueryStringRecipient.aspx?data=" + QueryString.ToString()); }
protected void btnRegister_Click(object sender, EventArgs e) { lbResponse.Text = string.Empty; //System.Threading.Thread.Sleep(100000000); if (cbterms.Checked) { int a = 0; if (cbsubscription.Checked) { a = 1; } using (PhotoProcessingDataContext dataDB = new PhotoProcessingDataContext()) { string path = "~/Images/Profile/default_person.jpg"; var counter = from b in dataDB.Photo_CustomerRegistrationDetails where b.Email == txtEmail.Text select b; if (counter.Count() == 0) { Photo_CustomerRegistrationDetailBL obj = new Photo_CustomerRegistrationDetailBL(0, txtEmail.Text, txtPassword.Text, 0, path, txtFullName.Text, 1, 0, a, a, DateTime.Now, DateTime.MaxValue, DateTime.MaxValue, 0, 0); if (obj.Insert()) { EncryptedQueryString args = new EncryptedQueryString(); args["arg1"] = txtEmail.Text; string url = string.Format("http://*****:*****@gmail.com"); msg.To.Add(txtEmail.Text); msg.Subject = "Activation Mail From icons"; StringBuilder sb = new StringBuilder(); sb.Append("<table><tr><td colspan='2'>Hi, " + txtFullName.Text + "</td></tr><tr><td colspan='2'></td></tr><tr><td colspan='2'>Thank you for registering with us! .</td></tr><tr><td colspan='2'></td></tr><tr><td colspan='2'>Click on the link below to activate your account:</td></tr><tr><td colspan='2'></td></tr><tr><td>Login URL :</td><td>" + url + "</td></tr><tr><td colspan='2'></td></tr><tr><td colspan='2'>Click is not possible means <a href=" + url + ">click here</a></td></tr><tr><td colspan='2'></td></tr><tr><td>Account Detail:</td></tr><tr><td colspan='2'></td></tr><tr><td colspan='2'><table><tr><td> Email:</td><td>" + txtEmail.Text + "</td></tr><tr><td>Password:</td><td>" + txtPassword.Text + "</td></tr></table></td></tr><tr><td colspan='2'></td></tr><tr><td colspan='2'>Thank you,</td></tr><tr><td colspan='2'>Edit My Photos</td></tr><tr><td colspan='2'>www.i-constech.com</td></tr></table>"); msg.Body = sb.ToString(); msg.IsBodyHtml = true; msg.Priority = MailPriority.High; MailSender ms = new MailSender(); ms.SendMailUsingGmail(msg); lbResponse.Text = "Validation mail send to your Id. Please, Check to activate your account...!"; emptyfield(); } } else { lbResponse.ForeColor = System.Drawing.ColorTranslator.FromHtml("#ff6230"); lbResponse.Text = "Email Id Already exist!"; } } } else { lbResponse.ForeColor = System.Drawing.ColorTranslator.FromHtml("#ff6230"); lbResponse.Text = "Check the terms & conditions"; } }
public string getCardUrl(Employee emp) { EncryptedQueryString QueryString = new EncryptedQueryString(); QueryString.Add("start_date", StartDateOfPeriod); QueryString.Add("end_date", EndDateOfPeriod); QueryString.Add("role", role); QueryString.Add("month_id", period.SelectedItem.Value); QueryString.Add("date", period.SelectedItem.Text); QueryString.Add("emp_id", emp.EmployeeID); QueryString.Add("emp_begda", emp.BeginDate); QueryString.Add("emp_endda", emp.EndDate); QueryString.Add("count_days", count_days.ToString()); string url = "Card.aspx?card=" + QueryString.ToString(); return url; }
protected void Page_Load(object sender, EventArgs e) { // Deserialize the encrypted query string EncryptedQueryString QueryString = new EncryptedQueryString(Request.QueryString["data"]); // Write information to the screen StringBuilder Info = new StringBuilder(); foreach (String key in QueryString.Keys) { Info.AppendFormat("{0} = {1}<br>", key, QueryString[key]); } QueryStringLabel.Text = Info.ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) Response.Redirect("Default.aspx"); // выводим доступные кнопки Person user = (Person)Session["User"]; Display disp = new Display(); //if (user.Roles == null) ContentPlaceHolder1.Visible = false; MenuBar.Text = disp.DisplayMenuBar(user.Roles); if (Request.QueryString["url"] != null) { EncryptedQueryString QueryString = new EncryptedQueryString(Request.QueryString["url"]); PageToLoad = QueryString["page"]; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["args"] != null) { var args = new EncryptedQueryString(Request.QueryString["args"]); _childid = args["CHILDID"]; _childname = args["CHILDNAME"]; lblChildID.Text = string.Format("Child ID: {0}", _childid); lblChildName.Text = string.Format("Child Name: {0}", _childname); } else { btnSend.Enabled = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { string login_id = string.Empty; EncryptedQueryString args = new EncryptedQueryString(Request.QueryString["args"]); foreach (var arg in args) { Label label = new Label(); label.Text = String.Format("{0}={1}", arg.Key, HttpUtility.HtmlEncode(arg.Value)); login_id = label.Text; } if (login_id == "") { throw new Exception("Invalid User!"); } string[] b = login_id.Split('='); login_id = b[1]; using (PhotoProcessingDataContext dataDB = new PhotoProcessingDataContext()) { var account = (from a in dataDB.Photo_CustomerRegistrationDetails where a.Email == login_id select a).FirstOrDefault(); account.ActivationStatus_Mail = 1; dataDB.SubmitChanges(); lbResponse.Text = "Your Account activated successfully!"; } } catch (Exception ex) { lbResponse.ForeColor = System.Drawing.ColorTranslator.FromHtml("#CC0000"); lbResponse.Text = ex.Message; } } }
protected void Save_Click(object sender, ImageClickEventArgs e) { //Response.Write(Request.Form["test"]); Person user = (Person)Session["User"]; PeriodDB perdb = new PeriodDB(); Period per = perdb.getPeriod(Convert.ToInt32(this.month), Convert.ToInt32(this.year)); if (this.employees != null) { DepartmentList department_list = new DepartmentList(); List<Department> departments = department_list.getDepartments(employees); foreach (Department dep in departments) { EmployeeList emp_list = new EmployeeList(); List<Employee> emps = null;//// emp_list.getEmployeesOfDepartment(dep.DepartmentID, employees); EmployeeComparerByPostASC cmpByPostASC = new EmployeeComparerByPostASC(); emps.Sort(cmpByPostASC); foreach (Employee em in emps) { EmployeeList emplist = new EmployeeList(); List<TimekeeperHours> current = null;//emplist.getEmployeesTimekeeperHours(em); List<HRHours> hr_current = null;/// emplist.getEmployeesHRHours(em); for (int i = 1; i <= count_days; i++) { string textbox_id = "tb" + dep.DepartmentID + em.PostID + em.EmployeeID + i.ToString(); //string hr_id = "hr" + dep.DepartmentID + em.EmployeeID + i.ToString(); Date dt = new Date(); SQLDB db = new SQLDB(); string hour = Request.Form[textbox_id]; //string overhour = Request.Form[hr_id]; TimekeeperHours th = current.Find(delegate(TimekeeperHours ht) { return ht.Day == i.ToString(); }); decimal h = -1; string sym = ""; if ((hour != "") && (hour != null)) { if (HasSymbols(hour)) { if (th == null) db.insertTimekeeperHoursAndSymbols(em.EmployeeID, em.StartPeriod, em.BeginDate, em.EndDate, h, hour, user.TabNum, dep.DepartmentID, em.PostID, i.ToString(), month, year, per.PeriodID); else if (!th.Symbols.Equals(hour)) db.updateTimekeeperHoursAndSymbols(user.TabNum, h, hour, th.ID); } else { h = Convert.ToDecimal(hour); if (th == null) db.insertTimekeeperHoursAndSymbols(em.EmployeeID, em.StartPeriod, em.BeginDate, em.EndDate, h, sym, user.TabNum, dep.DepartmentID, em.PostID, i.ToString(), month, year, per.PeriodID); else if (th.Hours != h) db.updateTimekeeperHoursAndSymbols(user.TabNum, h, sym, th.ID); } } if ((hour == "") && (th != null)) db.deleteTimekeeperHours(th.ID); } } } } EncryptedQueryString QueryString = new EncryptedQueryString(); QueryString.Add("month", period.SelectedItem.Value); QueryString.Add("role", role); //Server.Transfer("TimeTable.aspx?data=" + QueryString.ToString()); //Response.Redirect("Tabel.aspx?data=" + QueryString.ToString()); }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) Response.Redirect("Default.aspx"); Date dt = new Date(); SAPDB db = new SAPDB(); SQLDB sql = new SQLDB(); PeriodDB perdb = new PeriodDB(); Person user = (Person)Session["User"]; string role = ""; string month_id = ""; string year = ""; string start_date = ""; string end_date = ""; if (Request.QueryString["rft"] != null) { EncryptedQueryString QueryString = new EncryptedQueryString(Request.QueryString["rft"]); if (QueryString["role"] != null) role = QueryString["role"].ToString(); if (QueryString["month_id"] != null) month_id = QueryString["month_id"].ToString(); if (QueryString["year"] != null) year = QueryString["year"].ToString(); if (QueryString["start_date"] != null) start_date = QueryString["start_date"].ToString(); if (QueryString["end_date"] != null) end_date = QueryString["end_date"].ToString(); } Period per = perdb.getPeriod(Convert.ToInt32(month_id), Convert.ToInt32(year)); EmployeeList emp_list = new EmployeeList(); List<Employee> all_employees = db.getEmployeeListForReports(start_date, end_date, user.TabNum, role); if (all_employees == null) { MessageBox.Show("Невозможно сформировать отчет! Список сотрудников за период пуст!"); return; } EmployeeComparerByFullnameASC emp_comp = new EmployeeComparerByFullnameASC(); all_employees.Sort(emp_comp); Response.Clear(); Response.Charset = "utf-8"; Response.ContentType = "application/vnd.ms-excel"; string str = @"<table cellspacing='0' cellpadding='0' border='1'> <tr> <td colspan='25' style='border: 0px; height: 30px; font-weight: bold;' align='center' valign='middle'> ОТЧЕТ </td> <td> </td><td> </td><td> </td> </tr> <tr> <td colspan='25' style='border: 0px; height: 30px;' align='center' valign='middle'>"; str += "по фактически отработанному времени за " + per.MonthName.ToUpper() + " " + per.Year + " года</td><td> </td><td> </td><td> </td></tr>"; str += @"<tr> <td rowspan='2' style='background-color: #99CCFF; font-weight: bold;' align='center'> Таб. номер </td> <td rowspan='2' style='background-color: #99CCFF; font-weight: bold;' align='center'> ФИО </td> <td rowspan='2' style='width:80px; background-color: #99CCFF; font-weight: bold;' align='center'> Кол-во рабочих часов по графику (норма) </td> <td colspan='20' style='height: 30px; background-color: #99CCFF; font-weight: bold;' align='center'> ОТКЛОНЕНИЯ </td> <td rowspan='2' style='width:80px; background-color: #99CCFF; font-weight: bold;' align='center'> Итого отработано часов за период (факт) </td> <td rowspan='2' style='width:80px; background-color: #99CCFF; font-weight: bold;' align='center'> Итого отработано сверурочных часов </td> <td rowspan='2'> </td><td rowspan='2'> </td><td rowspan='2'> </td> </tr> <tr> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Временная нетрудоспособность </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Выходные дни (еженедельный отпуск) и нерабочие праздничные дни </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Время простоя по вине работника </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Невыходы на время исполнения государственных или общественных обязанностей согласно законодательству </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Отпуск без сохранения заработной платы, предоставляемый работнику по разрешению работодателя </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Служебная командировка </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Неявки по невыясненным причинам (до выяснения обстоятельств) </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Время простоя по причинам, не зависящим от работодателя и работника </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Дополнительные выходные дни (оплачиваемые) </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Ежегодный дополнительный оплачиваемый отпуск </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Отпуск по уходу за ребенком до достижения им возраста трех лет </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Отпуск без сохранения заработной платы при условиях, предусмотренных действующим законодательством Российской Федерации </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Ежегодный основной оплачиваемый отпуск </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Повышение квалификации с отрывом от работы </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Прогулы (отсутствие на рабочем месте без уважительных причин в течение времени, установленного законодательством) </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Отпуск по беременности и родам (отпуск в связи с усыновлением новорожденного ребенка) </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Время простоя по вине работодателя </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Дополнительный отпуск в связи с обучением с сохранением среднего заработка работникам, совмещающим работу с обучением </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Дополнительный отпуск в связи с обучением без сохранения заработной платы </td> <td style='width:80px; background-color: #FFFF99; font-weight: bold;' align='center'> Работа в выходные и праздничные дни </td> </tr> "; foreach(Employee emp in all_employees) { decimal norma = 0; decimal overhours = 0; decimal def_sum = 0; Deflections d = new Deflections(); List<HRHours> hr_current = sql.getHRHours(emp.EmployeeID, emp.StartPeriod, emp.BeginDate, emp.EndDate); List<Schedule> schedule = sql.getSchedule(emp.EmployeeID, emp.StartPeriod, emp.BeginDate, emp.EndDate); List<ScheduleDeflection> dschedule = sql.getScheduleDeflection(emp.EmployeeID, emp.StartPeriod, emp.BeginDate, emp.EndDate); foreach (Schedule sch in schedule) { // если выходной или изменение на выходной то пишем в отклонения по выходному дню if (((sch.DaySchedule == "FREE") && (Convert.ToInt32(sch.TimeHours) == 0)) || (sch.DayScheduleVar == "F")) d.def_V += sch.TimeHours; else norma += sch.TimeHours; } foreach (HRHours over in hr_current) overhours += (over.DayOverHours + over.NightOverHours); foreach (ScheduleDeflection sdf in dschedule) { def_sum += sdf.TimeHours; if (sdf.CodeT13.Equals("РВ")) { def_sum -= sdf.TimeHours; // убираем из поля Итого отработано по факту overhours += sdf.TimeHours; // записываем в поле Итого сверхурочных часов } switch (sdf.CodeT13) { case "Б": d.def_B += sdf.TimeHours; break; case "ВП": d.def_VP += sdf.TimeHours; break; case "Г": d.def_G += sdf.TimeHours; break; case "ДО": d.def_DO += sdf.TimeHours; break; case "К": d.def_K += sdf.TimeHours; break; case "НН": d.def_NN += sdf.TimeHours; break; case "НП": d.def_NP += sdf.TimeHours; break; case "ОВ": d.def_OV += sdf.TimeHours; break; case "ОД": d.def_OD += sdf.TimeHours; break; case "ОЖ": d.def_OJ += sdf.TimeHours; break; case "ОЗ": d.def_OZ += sdf.TimeHours; break; case "ОТ": d.def_OT += sdf.TimeHours; break; case "ПК": d.def_PK += sdf.TimeHours; break; case "ПР": d.def_PR += sdf.TimeHours; break; case "Р": d.def_R += sdf.TimeHours; break; case "РП": d.def_RP += sdf.TimeHours; break; case "У": d.def_U += sdf.TimeHours; break; case "УД": d.def_UD += sdf.TimeHours; break; case "РВ": d.def_RV += sdf.TimeHours; break; default: break; } } str += "<tr>"; str += "<td align='center'>" + DeleteZeroFromEmployeeID(emp.EmployeeID) + "</td>"; str += "<td align='center'>" + emp.FullName + "</td>"; if (norma != 0) str += "<td align='center'>" + norma.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_B != 0) str += "<td align='center'>" + d.def_B.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_V != 0) str += "<td align='center'>" + d.def_V.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_VP != 0) str += "<td align='center'>" + d.def_VP.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_G != 0) str += "<td align='center'>" + d.def_G.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_DO != 0) str += "<td align='center'>" + d.def_DO.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_K != 0) str += "<td align='center'>" + d.def_K.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_NN != 0) str += "<td align='center'>" + d.def_NN.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_NP != 0) str += "<td align='center'>" + d.def_NP.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_OV != 0) str += "<td align='center'>" + d.def_OV.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_OD != 0) str += "<td align='center'>" + d.def_OD.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_OJ != 0) str += "<td align='center'>" + d.def_OJ.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_OZ != 0) str += "<td align='center'>" + d.def_OZ.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_OT != 0) str += "<td align='center'>" + d.def_OT.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_PK != 0) str += "<td align='center'>" + d.def_PK.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_PR != 0) str += "<td align='center'>" + d.def_PR.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_R != 0) str += "<td align='center'>" + d.def_R.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_RP != 0) str += "<td align='center'>" + d.def_RP.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_U != 0) str += "<td align='center'>" + d.def_U.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_UD != 0) str += "<td align='center'>" + d.def_UD.ToString() + "</td>"; else str += "<td> </td>"; if (d.def_RV != 0) str += "<td align='center'>" + d.def_RV.ToString() + "</td>"; else str += "<td> </td>"; if ((norma - def_sum) != 0) str += "<td align='center'>" + (norma - def_sum).ToString() + "</td>"; else str += "<td> </td>"; if (overhours != 0) str += "<td align='center'>" + overhours.ToString() + "</td>"; else str += "<td> </td>"; str += "<td>" + getCompany(emp.Department) + "</td><td>" + getPath(emp.Department) + "</td><td>" + getDepartment(emp.Department) + "</td>"; str += "</tr>"; str += "</tr>"; } str += "</table>"; Response.Write(str); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) Response.Redirect("Default.aspx"); Date dt = new Date(); SAPDB db = new SAPDB(); SQLDB sql = new SQLDB(); PeriodDB perdb = new PeriodDB(); NightHoursDB nightdb = new NightHoursDB(); Person user = (Person)Session["User"]; string role = ""; string month_id = ""; string year = ""; string start_date = ""; string end_date = ""; if (Request.QueryString["rtb"] != null) { EncryptedQueryString QueryString = new EncryptedQueryString(Request.QueryString["rtb"]); if (QueryString["role"] != null) role = QueryString["role"].ToString(); if (QueryString["month_id"] != null) month_id = QueryString["month_id"].ToString(); if (QueryString["year"] != null) year = QueryString["year"].ToString(); if (QueryString["start_date"] != null) start_date = QueryString["start_date"].ToString(); if (QueryString["end_date"] != null) end_date = QueryString["end_date"].ToString(); } List<NightHours> nighthours = nightdb.getNightHours(); Period per = perdb.getPeriod(Convert.ToInt32(month_id), Convert.ToInt32(year)); EmployeeList emp_list = new EmployeeList(); List<Employee> all_employees = db.getEmployeeListForReports(start_date, end_date, user.TabNum, role); if (all_employees == null) { MessageBox.Show("Невозможно сформировать отчет! Список сотрудников за период пуст!"); return; } EmployeeComparerByFullnameASC emp_comp = new EmployeeComparerByFullnameASC(); all_employees.Sort(emp_comp); Response.Clear(); Response.Charset = "utf-8"; Response.ContentType = "application/vnd.ms-excel"; string str = @"<table cellspacing='0' cellpadding='0' border='1'> <tr> <td width='30px' style='font-weight: bold;' align='center' valign='middle'> Таб. номер </td> <td width='100px' style='font-weight: bold;' align='center' valign='middle'> ФИО </td>"; int count_days = dt.getCountDays(per.MonthID, per.Year); for (int i = 1; i <= count_days; i++) str += "<td width='20px' style='font-weight: bold;' align='center'>" + i.ToString() + "</td><td width='20px' style='background-color: #99CCFF; font-weight: bold;' align='center' >" + i.ToString() + "a</td>"; str += "<td> </td><td> </td><td> </td></tr>"; foreach (Employee emp in all_employees) { str += "<tr>"; str += "<td width='30px' align='center'>" + DeleteZeroFromEmployeeID(emp.EmployeeID) + "</td>"; str += "<td width='100px' align='center'>" + emp.FullName + "</td>"; int day = 1; List<HRHours> hr_current = sql.getHRHours(emp.EmployeeID, emp.StartPeriod, emp.BeginDate, emp.EndDate); List<Schedule> schedule = sql.getSchedule(emp.EmployeeID, emp.StartPeriod, emp.BeginDate, emp.EndDate); List<ScheduleDeflection> dschedule = sql.getScheduleDeflection(emp.EmployeeID, emp.StartPeriod, emp.BeginDate, emp.EndDate); foreach (Schedule sch in schedule) { decimal all_hours = 0; decimal night_hours = 0; int d = Convert.ToInt32(sch.DayPeriod); // если у нас день не совпадает с днем в графике, заполняю пустым квадратом //TimekeeperHours tkh = tkh_current.Find(delegate(TimekeeperHours h) { return Convert.ToInt32(h.Day) == day; }); HRHours hr = hr_current.Find(delegate(HRHours hrh) { return Convert.ToInt32(hrh.Day) == day; }); if (hr != null) { all_hours += hr.DayOverHours + hr.NightOverHours; night_hours += hr.NightOverHours; } while (d != day) { if (day == count_days) break; if (all_hours != 0) str += "<td width='20px' align='center'>" + all_hours.ToString() + "</td>"; else str += "<td width='20px' align='center'> </td>"; if (night_hours != 0) str += "<td width='20px' style='background-color: #99CCFF;' align='center'>" + night_hours.ToString() + "</td>"; else str += "<td width='20px' style='background-color: #99CCFF;' align='center'> </td>"; day++; } ScheduleDeflection sd = dschedule.Find(delegate(ScheduleDeflection dsch) { return Convert.ToInt32(dsch.DayPeriod) == day; }); if (sd != null) { //time = CheckDecimalNumber(sd.CodeT13); decimal diversity = sch.TimeHours - sd.TimeHours; if (diversity != 0) { if (diversity > 0) { all_hours = diversity; } else { all_hours = sd.TimeHours; } } if (all_hours != 0) str += "<td width='20px' align='center'>" + all_hours.ToString() + "</td>"; else str += "<td width='20px' align='center'> </td>"; if (night_hours != 0) str += "<td width='20px' style='background-color: #99CCFF;' align='center'>" + night_hours.ToString() + "</td>"; else str += "<td width='20px' style='background-color: #99CCFF;' align='center'> </td>"; } else { // если выходной или изменение на выходной то пишем в отклонения по выходному дню if (((sch.DaySchedule == "FREE") && (Convert.ToInt32(sch.TimeHours) == 0)) || (sch.DayScheduleVar == "F")) { if (all_hours != 0) str += "<td width='20px' align='center'>" + all_hours.ToString() + "</td>"; else str += "<td width='20px' align='center'> </td>"; if (night_hours != 0) str += "<td width='20px' style='background-color: #99CCFF;' align='center'>" + night_hours.ToString() + "</td>"; else str += "<td width='20px' style='background-color: #99CCFF;' align='center'> </td>"; } else { //decimal hour_start = Convert.ToInt32(sch.TimeBegin.Substring(0, 2)); //decimal hour_end = Convert.ToInt32(sch.TimeEnd.Substring(0, 2)); //decimal minute_start = Convert.ToDecimal(sch.TimeBegin.Substring(2, 2)); //decimal minute_end = Convert.ToDecimal(sch.TimeEnd.Substring(2, 2)); //if (hour_start == 0) hour_start = 24; //if (hour_end == 0) hour_end = 24;\ /* hour_start += minute_start / 60; hour_end += minute_end / 60; if (sch.TimeHours != 0) { if ((hour_start > 6) && (hour_end < 22)) all_hours += sch.TimeHours; if (hour_start <= 6) { night_hours += 6 - hour_start - 1; all_hours += sch.TimeHours; } if (hour_end >= 22) { night_hours += hour_end - 22; all_hours += sch.TimeHours; } } */ all_hours += sch.TimeHours; NightHours nhour = nighthours.Find(delegate(NightHours nh) { return nh.DaySchedule.ToUpper() == sch.DaySchedule.ToUpper(); }); if (nhour != null) { night_hours += nhour.Night_Hours; } //day_hours += (night_hours + sch.TimeHours); if (all_hours != 0) str += "<td width='20px' align='center'>" + all_hours.ToString() + "</td>"; else str += "<td width='20px' align='center'> </td>"; if (night_hours != 0) str += "<td width='20px' style='background-color: #99CCFF;' align='center'>" + night_hours.ToString() + "</td>"; else str += "<td width='20px' style='background-color: #99CCFF;' align='center'> </td>"; } } day++; } while (day <= count_days) { decimal all_hours = 0; decimal night_hours = 0; //HRHours hr = hr_current.Find(delegate(HRHours hrh) { return Convert.ToInt32(hrh.Day) == day; }); if (all_hours != 0) str += "<td width='20px' align='center'>" + all_hours.ToString() + "</td>"; else str += "<td width='20px' align='center'> </td>"; if (night_hours != 0) str += "<td width='20px' style='background-color: #99CCFF;' align='center'>" + night_hours.ToString() + "</td>"; else str += "<td width='20px' style='background-color: #99CCFF;' align='center'> </td>"; day++; } str += "<td>" + getCompany(emp.Department) + "</td><td>" + getPath(emp.Department) + "</td><td>" + getDepartment(emp.Department) + "</td>"; str += "</tr>"; } str += "</table>"; Response.Write(str); Response.End(); }
protected void btnSend_Click(object sender, EventArgs e) { string errorMessage = string.Empty; try { var args = new EncryptedQueryString(Request.QueryString["args"]); _childid = args["CHILDID"]; _childname = args["CHILDNAME"]; _sponsorid = args["SPONSORID"]; _sponsorname = args["SPONSORNAME"]; string customMessage = txtMessage.Text.Replace("\r\n", "<br />"); StringBuilder message = new StringBuilder(); message.AppendLine("<table>"); message.AppendLine(string.Format("<tr><td>Sponsor ID:</td><td>{0}</td></tr>", _sponsorid)); message.AppendLine(string.Format("<tr><td>Sponsor Name:</td><td>{0}</td></tr>", _sponsorname)); message.AppendLine("<tr><td colspan='2'><br /></td></tr>"); message.AppendLine(string.Format("<tr><td>Child ID:</td><td>{0}</td></tr>", _childid)); message.AppendLine(string.Format("<tr><td>Child Name:</td><td>{0}</td></tr>", _childname)); message.AppendLine("<tr><td colspan='2'><br /></td></tr>"); message.AppendLine("<tr><td colspan='2'><br /></td></tr>"); message.AppendLine(string.Format("<tr><td colspan='2'>{0}</td></tr>", customMessage)); message.AppendLine("<tr><td colspan='2'><br /></td></tr>"); message.AppendLine("<tr><td colspan='2'><br /></td></tr>"); message.AppendLine(string.Format("<tr><td colspan='2'>{0}</td></tr>", MyContent.LinkHtml)); message.AppendLine("<tr><td colspan='2'><br /></td></tr>"); message.AppendLine("<tr><td colspan='2'><br /></td></tr>"); message.AppendLine("</table>"); var template = new EmailTemplate(MyContent.TemplateID); var em = new EMail(template); em.Save(); em.FromAddress = MyContent.FromAddress; em.FromDisplayName = MyContent.FromName; em.Subject = MyContent.SubjectLine; em.ContentHTML = message.ToString(); em.Send(MyContent.ToAddress, MyContent.ToAddress, API.Users.CurrentUser.RaisersEdgeID, API.Users.CurrentUser.UserID, null, this.Page); } catch (ArgumentNullException ane) { errorMessage = ane.Message; } catch (Exception ex) { errorMessage = "An error has occurred, please try again."; Blackbaud.Web.Content.Core.Common.LogErrorToDB(ex, false); } if (!string.IsNullOrWhiteSpace(errorMessage)) { Utility.RedirectToBBISPage(MyContent.ErrorPageID); } else { Utility.RedirectToBBISPage(MyContent.SuccessPageID); } }
public ActionResult SendRegisterConfirmEmail(RegisterModel registerModel, int parentEmailTemplateNodeId, int emailTemplateNodeId) { var errorMsg = "registration failed !!!"; if (umbraco.library.GetDictionaryItem("") != null) { if (umbraco.library.GetDictionaryItem("") != "") { errorMsg = umbraco.library.GetDictionaryItem(""); } } try { var parentEmailTemplate = contentService.GetById(parentEmailTemplateNodeId); var fromEmail = parentEmailTemplate.Properties["fromEmail"].Value.ToString(); var bccEmail = parentEmailTemplate.Properties["bCCEmail"].Value.ToString(); var adminEmail = parentEmailTemplate.Properties["adminEmail"].Value.ToString(); var emailTemplate = contentService.GetById(emailTemplateNodeId); var subject = emailTemplate.Properties["subject"].Value.ToString(); var mailBody = emailTemplate.Properties["mailBody"].Value.ToString(); mailBody.Replace("#email#", registerModel.Email); var isSuccess = new SendMail().Send(fromEmail, adminEmail, bccEmail, subject, mailBody); if (isSuccess) { var successMsg = "registration is approved"; if (umbraco.library.GetDictionaryItem("") != null) { if (umbraco.library.GetDictionaryItem("") != "") { successMsg = umbraco.library.GetDictionaryItem(""); } } if (emailTemplate.Properties["sendToVisitor"].Value.ToString() == "1") { var CompleteRegisterUrl = Request.Url.Host; var encryptedMail = new EncryptedQueryString(); encryptedMail["EM"] = registerModel.Email; var visitorSubject = emailTemplate.Properties["subjectToVisitor"].Value.ToString(); var visitorMail = emailTemplate.Properties["mailToVisitor"].Value.ToString(); visitorMail = visitorMail.Replace("#email#", registerModel.Email).Replace("#CompleteRegisterUrl#", CompleteRegisterUrl + "/register/register-confirm?" + "email=" + encryptedMail).Replace("#username#", registerModel.LoginName); var isMailSend = new SendMail().Send(fromEmail, registerModel.Email, bccEmail, visitorSubject, visitorMail); if (isMailSend) { return(Json(new { result = "success", message = successMsg })); } } } return(Json(new { result = "fail", message = errorMsg })); } catch (Exception ex) { Helper.CreateErrorLogMessage(ex.Message + "with inner exception '" + ex.InnerException + "'"); return(Json(new { result = "fail", message = errorMsg })); } }
protected void bt_filter_tab_Click(object sender, EventArgs e) { EncryptedQueryString QueryString = new EncryptedQueryString(); QueryString.Add("tab", filter_tab_text.Text); QueryString.Add("month", period.SelectedItem.Value); QueryString.Add("role", role); //Server.Transfer("TimeTable.aspx?data=" + QueryString.ToString(`)); Response.Redirect("Tabel.aspx?data=" + QueryString.ToString()); }
protected void Check_Click(object sender, ImageClickEventArgs e) { EncryptedQueryString QueryString = new EncryptedQueryString(); QueryString.Add("month", period.SelectedItem.Value); QueryString.Add("role", role); QueryString.Add("check", "true"); Response.Redirect("Tabel.aspx?data=" + QueryString.ToString()); }
private void fillMonths() { if (period.Items.Count != 0) return; Date dt = new Date(); List<Period> periods = dt.getPeriodsToDropDownList(); string monthID = ""; foreach (Period p in periods) { monthID = p.MonthID.ToString(); if (monthID.Length == 1) monthID = monthID.Insert(0, "0"); ListItem li = new ListItem(p.MonthName.ToUpper(), monthID); period.Items.Add(li); } //Response.Write("fillMonths<br>"); if (Request.QueryString["data"] != null) { EncryptedQueryString QueryString = new EncryptedQueryString(Request.QueryString["data"]); foreach (string key in QueryString.Keys) if (key == "month") period.SelectedValue = QueryString[key]; } }
protected void ddl_post_SelectedIndexChanged(object sender, EventArgs e) { EncryptedQueryString QueryString = new EncryptedQueryString(); QueryString.Add("post", ddl_post.SelectedItem.Value); QueryString.Add("month", period.SelectedItem.Value); QueryString.Add("role", role); //Server.Transfer("TimeTable.aspx?data=" + QueryString.ToString()); Response.Redirect("Tabel.aspx?data=" + QueryString.ToString()); }
protected void RefreshPage() { EncryptedQueryString QueryString = new EncryptedQueryString(); QueryString.Add("month", period.SelectedItem.Value); QueryString.Add("role", role); //Server.Transfer("TimeTable.aspx?data=" + QueryString.ToString()); Response.Redirect("Tabel.aspx?data=" + QueryString.ToString()); }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) Response.Redirect("Default.aspx"); Display disp = new Display(); Date dt = new Date(); SAPDB db = new SAPDB(); SQLDB sql = new SQLDB(); PeriodDB perdb = new PeriodDB(); Person user = (Person)Session["User"]; //List<Role> rol = user.Roles; //foreach (Role r in rol) // Response.Write(r.RoleID + " = " + r.RoleName); if (!IsPostBack) { fillMonths(); if (Request.QueryString["data"] == null) period.SelectedValue = dt.getMonthToday(); } year = period.SelectedItem.Text.Substring(period.SelectedItem.Text.Length - 4); month = period.SelectedItem.Value; string fio = ""; string tab_number = ""; string post = ""; check = false; closed = false; count_days = dt.getCountDays(Convert.ToInt32(month), Convert.ToInt32(year)); if (Request.QueryString["type"] != null) role = Request.QueryString["type"].ToString(); Period per = perdb.getPeriod(Convert.ToInt32(month), Convert.ToInt32(year)); if (per.IsClosed == 1) { lbStatus.Text = "������"; Traffic.Text = "<img alt='' src='App_Resources/red.bmp' style='position:relative; top:4px;' />"; closed = true; } else Traffic.Text = "<img alt='' src='App_Resources/green.bmp' style='position:relative; top:4px;' />"; if (Request.QueryString["data"] != null) { EncryptedQueryString QueryString = new EncryptedQueryString(Request.QueryString["data"]); if (QueryString["fio"] != null) fio = QueryString["fio"]; if (QueryString["tab"] != null) tab_number = QueryString["tab"]; if (QueryString["post"] != null) post = QueryString["post"]; if (QueryString["role"] != null) role = QueryString["role"]; if (QueryString["check"] != null) check = true; if (!QueryString["month"].Equals(period.SelectedItem.Value)) { fio = ""; tab_number = ""; post = ""; check = false; } } //Response.Write(month); //Response.Write("fio=" + fio + "tab=" + tab_number + " - " + month + "<br>"); //Response.Write(post + "<br>"); string start_date = dt.getSAPStartPeriodDate(month, year); string end_date = dt.getSAPEndPeriodDate(month, year); StartDateOfPeriod = start_date; EndDateOfPeriod = end_date; //Response.Write(start_date + end_date); Label lb = new Label(); lb.Text = disp.DisplayDaysTabel(count_days, 18); days.Controls.Add(lb); //Response.Write(start_date + end_date); //Period period_time = perdb.getPeriod(Convert.ToInt32(month), Convert.ToInt32(year)); setButtons(role); //Response.Write(start_date + "-" + end_date + "<br>"); this.employees = null;/// db.getEmployeeList(start_date, end_date, user.TabNum, this.role); EmployeeList emp_list = new EmployeeList(); List<Post> post_list = null;/// pl.getPosts(db.getPostList(start_date, end_date, user.TabNum, this.role)); if (post_list != null) { fillPosts(post_list); } else { ListItem li = new ListItem("�������� ���������"); ddl_post.Items.Add(li); } /*if (post != "") { if (post != "���") { EmployeeList empl = new EmployeeList(); // this.employees = empl.getEmployeesOnCurrentPost(post, employees); } } if (fio != "") { EmployeeList emp_fio = new EmployeeList(); this.employees = emp_fio.getEmployeesByFIO(fio, employees); } if (tab_number != "") { EmployeeList emp_tab = new EmployeeList(); this.employees = emp_tab.getEmployeesByTab(tab_number, employees); }*/ if (check) { EmployeeList emp_check = new EmployeeList(); /////this.employees = emp_check.getWrongCheckedEmployees(employees, count_days, hours, overhours); } if (employees != null) { DepartmentList department_list = new DepartmentList(); List<Department> departments = department_list.getDepartments(employees); foreach (Department dep in departments) { Label depart = new Label(); depart.Text = disp.DisplayDepartmentName(dep.DepartmentName, dep.DepartmentID, StartDateOfPeriod); content.Controls.Add(depart); Label lbEmps = new Label(); lbEmps.Text = "<div id='" + dep.DepartmentID + "' style='display:none'>"; // �������� ���� �������� ��� �������� �������� /*EmployeeList emp_list = new EmployeeList(); List<Employee> emps = emp_list.getEmployeesOfDepartment(dep.DepartmentID, employees); EmployeeComparerByPostASC cmpByPostASC = new EmployeeComparerByPostASC(); emps.Sort(cmpByPostASC); //for (int j = 0; j < 100; j++) foreach (Employee em in emps) { lbEmps.Text += "<table cellpadding='0' cellspacing='0' border='0' class='employee'><tr><td class='main_info_left_no'> </td><td class='employee_post'>" + em.Post + "</td><td class='employee_id'>" + em.EmployeeID + "</td><td class='employee_name'><img src='App_Resources/person.gif' style='cursor: hand; cursor: pointer;'> <span style='cursor: hand; cursor: pointer;' onclick='window.open(\"" + getCardUrl(em.EmployeeID) +"\",\"displayWindow\",\"menubar=no,width=800,height=600,resizable=yes,scrollbars=yes\")'>" + em.FullName + "</span></td><td class='employee_grid_line_center'> </td><td>" + disp.DisplaySchedules(count_days, 18, em.EmployeeID, dep.DepartmentID, hours, overhours, em.Schedule, em.ScheduleDeflection, role, check, closed) + "</td><td class='main_info_right_no'></td></tr></table>"; }*/ lbEmps.Text += "</div>"; content.Controls.Add(lbEmps); } } // ajax �� �������� ������ ����������� ������������� ������������� string cbReference = Page.ClientScript.GetCallbackEventReference(this, "arg", "ClientCallback", "context"); string func_name = "FillEmployeesCallback"; string cbScript = "function " + func_name + "(arg, context)" + "{" + cbReference + ";" + "}"; Page.ClientScript.RegisterClientScriptBlock(this.GetType(), func_name, cbScript, true); }