public static result addCartByProductId(string id, string name, string quantity, string sale) { CNManagerDataContext db = new CNManagerDataContext(); clsProcess cl = new clsProcess(); var r = new result(); try { ShoppingCart cart = (ShoppingCart)HttpContext.Current.Session["Cart"]; string idPro = id; if (cart.ReturnID(idPro)) { cart.Update(idPro, cart.GetCurrentQuantity(idPro)); HttpContext.Current.Session["cart_count"] = r._content = cart.GetTotalQuantity.ToString(); r._mess = "Đã cập nhật số lượng sản phẩm [" + name + "] vào giỏ hàng"; } else { var pro = db.sp_web_cn_loadProductDetail(branchTypeId.ToString(), int.Parse(id.Trim())).FirstOrDefault(); cart.AddProduct(id.ToString(), cl.ConvertToUnSign(pro.ProductName), pro.ProductCode, pro.ProductName, (pro.Image == null || pro.Image == "" ? "/image/image-coming-soon.png" : pro.Image), int.Parse(quantity), pro.Price.Value, 0, pro.Score != null ? pro.Score.Value : 0, pro.BrandName, pro.CountryName, sale == "1" ? true : false); HttpContext.Current.Session["cart_count"] = r._content = cart.GetTotalQuantity.ToString(); r._mess = "Đã thêm sản phẩm [" + name + "] vào giỏ hàng"; } } catch (Exception ax) { r._mess = ax.Message; } return(r); }
public static login check_login(string us, string pw) { CNManagerDataContext db = new CNManagerDataContext(); clsProcess cl = new clsProcess(); var l = new login(); var u = from x in db.tMembers where x.BranchTypeId == branchTypeId && x.Status == 1 && (x.Username == us.Trim().ToLower() || x.Phone == us.Trim().ToLower()) && x.Password == cl.MaHoa(pw.Trim()) select new { x.Id, x.Email, x.MemberName, x.Username, x.Phone }; if (u.Count() == 1) { HttpContext.Current.Session["cn_mb_user_id"] = l.ID = u.FirstOrDefault().Id.ToString(); HttpContext.Current.Session["cn_mb_user_name"] = l.Name = u.FirstOrDefault().MemberName; HttpContext.Current.Session["cn_mb_user_email"] = l.Email = u.FirstOrDefault().Email; l.Ok = true; l.Mess = "Đăng nhập thành công"; } else { l.Ok = false; l.Mess = "Thông tin đăng nhập không đúng, vui lòng kiểm tra lại"; } return(l); }
public static result changePassword(string email, string passold, string passnew) { var r = new result(); CNManagerDataContext db = new CNManagerDataContext(); clsProcess cl = new clsProcess(); var check = from x in db.tMembers where x.BranchTypeId == branchTypeId && (x.Username == email.Trim().ToLower() || x.Phone == email.Trim()) && x.Password == cl.MaHoa(passold.Trim()) select x; if (check.Count() == 1) { try { check.FirstOrDefault().Password = cl.MaHoa(passnew); db.SubmitChanges(); r._content = "ok"; r._mess = "Thay đổi mật khẩu thành công"; } catch (Exception ax) { r._content = "error"; r._mess = ax.Message; } } else { r._content = "error"; r._mess = "Thông tin đăng nhập và mật khẩu cũ không đúng, vui lòng kiểm tra lại"; } return(r); }
public void productFeature() { clsProcess cl = new clsProcess(); CNManagerDataContext db = new CNManagerDataContext(); var pro = db.sp_web_cn_loadProductFeature(branchTypeId.ToString()); string result = ""; int count = 0; string ref_member = getRefMember(); foreach (var item in pro.ToList()) { count++; if (count == 1 || count % 2 == 1) { result += "<div class='row_items'>"; } result += "<div class='item'><div class='item-inner'><div class='images-container'>"; if (item.NoteSale != null && item.NoteSale != "") { result += "<div class='label-pro-new'><span>" + item.NoteSale + "</span></div>"; } string img = item.Image.Trim() == "" ? "/image/image-coming-soon.png" : item.Image.Trim(); result += "<a class='product-image' href='/" + ref_member + "detail/" + item.Id.ToString() + "/" + cl.ConvertToUnSign(item.ProductName) + ".html'><img src='" + img + "' alt='" + item.ProductName + "' /></a>"; result += "</div><div class='des-container'>"; result += "<p class='tags-product'>"; if (item.Tag != null && item.Tag != "") { if (item.Tag.Contains(",")) { var t = item.Tag.Split(','); foreach (var tg in t) { result += "<a href='/search/?k=" + Server.UrlEncode(tg) + "'>#" + tg + "</a>"; } } else { result += "<a href='/search/?k=" + Server.UrlEncode(item.Tag.Trim()) + "'>#" + item.Tag.Trim() + "</a>"; } } result += "</p>"; result += "<h2 class='product-name' style='height:36px;'><a href='/" + ref_member + "detail/" + item.Id.ToString() + "/" + cl.ConvertToUnSign(item.ProductName) + ".html'>" + item.ProductName + "</a></h2>"; result += "<div class='price-box box-special'><p class='special-price'><span class='price'>" + string.Format("{0:0,0 đ}", item.Price) + "</span></p>"; result += "</div><button class='button btn-cart' type='button' onclick=\"addCart(" + item.Id.ToString() + ",'" + item.ProductName + "',1" + ",'" + item.Image + "','" + string.Format("{0:0,0}", item.Price) + "',0)\" data-toggle='tooltip' title='Thêm nhanh vào giỏ hàng'>"; result += "<span><span>Thêm vào giỏ hàng</span></span></button>"; result += "<div class='box-hover'><div class='ratings'><div class='rating-box'><div class='rating5'>rating</div>"; result += "</div></div></div></div></div></div>"; if (count % 2 == 0) { result += "</div>"; } } lbFProduct.Text = result; }
public static List <product> mb_getproduct(string type, string from, string to, string status) { var p = new List <product>(); if (!string.IsNullOrEmpty(Convert.ToString(HttpContext.Current.Session["cn_mb_user_id"]))) { CNManagerDataContext db = new CNManagerDataContext(); clsProcess cl = new clsProcess(); string userid = HttpContext.Current.Session["cn_mb_user_id"].ToString(); int count = 0; var n = db.sp_web_cn_mb_getproduct(int.Parse(userid), int.Parse(type), DateTime.Parse(cl.returnDatetime(from)), DateTime.Parse(cl.returnDatetime(to)), status); foreach (var item in n.ToList()) { count++; var x = new product(); x.CustomerName = item.CustomerName; x.Brand = item.Brand; x.Code = item.ProductCode; x.CodeOrder = item.OrderCode; x.CreateAt = item.CreatedAt.Value.ToString("dd/MM/yyyy"); x.ID = item.Id.ToString(); x.Image = item.Image; if (item.MemberId != null) { x.MemberId = item.MemberId.ToString(); } x.Name = item.ProductName; x.OrderId = item.OrderId.ToString(); x.pPrice = string.Format("{0:0,0 đ}", item.pPrice.Value); x.Price = string.Format("{0:0,0}", item.Price.Value); x.Score = item.Score.ToString(); x.pScore = item.pScore.ToString(); x.Quantity = item.Quantity.ToString(); if (item.RefId != null) { x.RefId = item.RefId.ToString(); } x.Mess = cl.ConvertToUnSign(item.ProductName); x.Status = item.Status.ToString(); x.StatusId = item.StatusId.ToString(); x.OK = true; p.Add(x); } if (count == 0) { p.Add(new product { OK = false, Mess = "Không có dữ liệu nào phù hợp" }); } } else { p.Add(new product { OK = false, Mess = "Phiên đăng nhập hết hạn, vui lòng đăng nhập lại" }); } return(p); }
private void call_Calc_StdHrs(DateTime tFromDt, out string err) { err = string.Empty; using (SqlConnection cn = new SqlConnection(Utils.Helper.constr)) { try { cn.Open(); string sql = string.Empty; sql = "Select EmpUnqID,WrkGrp From MastEmp where WrkGrp in ('Comp','Cont') And Active = 1 "; DataSet dsEmp = Utils.Helper.GetData(sql, Utils.Helper.constr); bool hasRows = dsEmp.Tables.Cast <DataTable>().Any(table => table.Rows.Count != 0); if (hasRows) { foreach (DataRow drEmp in dsEmp.Tables[0].Rows) { //Open EmpAttdRecord sql = "Select tYear,tDate,CompCode,WrkGrp,EmpUnqID,ScheDuleShift,ConsShift,ConsIN,ConsOut,ConsWrkHrs,ConsOverTime," + "Status,HalfDay,LeaveTyp,LeaveHalf,ActualStatus,Earlycome,EarlyGoing,GracePeriod," + "INPunch1,OutPunch1,WrkHrs1,INPunch2,OutPunch2,WrkHrs2,INPunch3,OutPunch3," + "WrkHrs3,INPunch4,OutPunch4,WrkHrs4,TotalWorkhrs,TotalINPunchCount," + "TotalOutPunchCount,LateCome,Rules,CalcOverTime,HalfDRule,partdate,CostCode,StdHrsOT,StdShftHrs,StdWrkHrs,StdWrkShift " + " From AttdData where CompCode = '01' and tYear ='" + tFromDt.Year.ToString() + "'" + " And WrkGrp ='" + drEmp["WrkGrp"].ToString() + "' and tDate ='" + tFromDt.ToString("yyyy-MM-dd") + "'" + " And EmpUnqID ='" + drEmp["EmpUnqID"].ToString() + "'"; //create data adapter DataSet dsAttdData = new DataSet(); SqlDataAdapter daAttdData = new SqlDataAdapter(new SqlCommand(sql, cn)); SqlCommandBuilder AttdCmdBuilder = new SqlCommandBuilder(daAttdData); daAttdData.Fill(dsAttdData, "AttdData"); hasRows = dsAttdData.Tables.Cast <DataTable>().Any(table => table.Rows.Count != 0); if (hasRows) { foreach (DataRow drAttd in dsAttdData.Tables[0].Rows) { clsProcess pr = new clsProcess(); pr.Calc_StdHrs(daAttdData, dsAttdData, drAttd); } } }//foreach employee } } catch (Exception ex) { err = ex.Message; } }//using }
public static result check_register(string user, string name, string email, string pw, int sex, string phone, string birth, string add, string country, string countryname, string district, string districtname) { CNManagerDataContext db = new CNManagerDataContext(); clsProcess cl = new clsProcess(); var r = new result(); try { var mb = new tMember(); mb.Username = user.Trim(); mb.MemberCode = "MB" + DateTime.Now.ToString("ddMMyyyyHHmmss"); mb.MemberName = name.Trim(); mb.Email = email.Trim().ToLower(); mb.Password = cl.MaHoa(pw.Trim()); mb.Sex = sex == 1 ? true : false; mb.Phone = phone.Trim(); if (birth.Trim() != "") { mb.Birthday = DateTime.Parse(cl.returnDatetime(birth.Trim())); } mb.Address = add.Trim(); if (country != "") { mb.CountryId = int.Parse(country.Trim()); mb.CountryName = countryname; } if (district != "") { mb.DistrictId = int.Parse(district.Trim()); mb.DistrictName = districtname; } mb.BranchTypeId = branchTypeId; mb.Status = 1; mb.JoinCreateAt = DateTime.Now; mb.CreateAt = DateTime.Now; db.tMembers.InsertOnSubmit(mb); db.SubmitChanges(); r._mess = "Đăng kí tài khoản thành công"; r._content = "ok"; } catch (Exception ax) { r._content = "err"; r._mess = ax.Message; } return(r); }
public static result updateInfoMember(string name, string sex, string phone, string email, string birth) { var r = new result(); if (!string.IsNullOrEmpty(Convert.ToString(HttpContext.Current.Session["cn_mb_user_id"]))) { CNManagerDataContext db = new CNManagerDataContext(); clsProcess cl = new clsProcess(); var x = from n in db.tMembers where n.BranchTypeId == branchTypeId && n.Id == int.Parse(HttpContext.Current.Session["cn_mb_user_id"].ToString()) select n; if (x.Count() == 1) { x.FirstOrDefault().MemberName = name.Trim(); x.FirstOrDefault().Sex = sex.Trim() == "1" ? true : false; x.FirstOrDefault().Phone = phone.Trim(); x.FirstOrDefault().Email = email.Trim(); if (birth.Trim() != "") { x.FirstOrDefault().Birthday = DateTime.Parse(cl.returnDatetime(birth.Trim())); } else { x.FirstOrDefault().Birthday = null; } db.SubmitChanges(); r._mess = "Cập nhật thành công"; r._content = "ok"; } else { r._mess = "Không tìm thấy thông tin thành viên, vui lòng thử lại"; r._content = "error"; } } else { r._mess = "Hết phiên đăng nhập, vui lòng đăng nhập lại"; r._content = "error"; } return(r); }
public static result resetPassword(string email) { var r = new result(); CNManagerDataContext db = new CNManagerDataContext(); clsProcess cl = new clsProcess(); var check = from x in db.tMembers where x.Email == email.Trim().ToLower() select x; if (check.Count() == 1) { try { string pw = Guid.NewGuid().ToString("n").Substring(0, 8); check.FirstOrDefault().Password = cl.MaHoa(pw); db.SubmitChanges(); if (cl.SendMail("Khôi phục mật khẩu", "C'nice | Khôi phục mật khẩu", email.Trim(), "<p>Bạn vừa thực hiện hành động khôi phục lại mật khẩu người dùng tại C'nice." + "</p><p>Email của bạn: <b>" + email.Trim().ToLower() + "</b></p><p>Mật khẩu mới của bạn là: <b>" + pw + "</b></p>")) { r._mess = "Đã gửi lại mật khẩu mới vào mail " + email + " của bạn. Vui lòng kiểm tra hộp thư"; } else { r._mess = "Gửi email chưa thành công, có thể lỗi do đường truyền. Bạn vui lòng thử lại"; } } catch (Exception ax) { r._content = "error"; r._mess = ax.Message; } } else { r._content = "error"; r._mess = "Tài khoản và email không đúng, vui lòng kiểm tra lại"; } return(r); }
private void btnImport_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; DataTable dtMaterial = new DataTable(); DataTable sortedDT = new DataTable(); try { foreach (GridColumn column in grd_view1.VisibleColumns) { if (column.FieldName != string.Empty) { dtMaterial.Columns.Add(column.FieldName, column.ColumnType); } } for (int i = 0; i < grd_view1.DataRowCount; i++) { DataRow row = dtMaterial.NewRow(); foreach (GridColumn column in grd_view1.VisibleColumns) { row[column.FieldName] = grd_view1.GetRowCellValue(i, column); } dtMaterial.Rows.Add(row); } DataView dv = dtMaterial.DefaultView; dv.Sort = "EmpUnqID asc"; sortedDT = dv.ToTable(); using (SqlConnection con = new SqlConnection(Utils.Helper.constr)) { DateTime tdt; con.Open(); foreach (DataRow dr in sortedDT.Rows) { string tEmpUnqID = dr["EmpUnqID"].ToString(); try { tdt = Convert.ToDateTime(dr["SanDate"]); } catch (Exception ex) { dr["Remarks"] = "Sanction Date Conversion failed..."; continue; } string err = DataValidate(dr); if (!string.IsNullOrEmpty(err)) { dr["Remarks"] = err; continue; } clsEmp Emp = new clsEmp(); #region Chk_Primary try { DateTime tAddDt = Convert.ToDateTime(Utils.Helper.GetDescription("Select GetDate()", Utils.Helper.constr)); //added on 02-12-2014 full rights skip the validation if (Utils.User.IsAdmin == false) { //'check does not allow morethan 2 days blank intime and outtime TimeSpan ts = tAddDt - Convert.ToDateTime(dr["SanDate"]); if (ts.Days > rSanDayLimit && (dr["InTime"].ToString() != "" || dr["OutTime"].ToString() != "")) { if (dr["InTime"].ToString() != "") { dr["InTime"] = DBNull.Value; } if (dr["OutTime"].ToString() != "") { dr["Outtime"] = DBNull.Value; } dr["Remarks"] = "Did not consider In/Out time (Limit Exceed)"; } //'added on 30/06/2016 if (Globals.GetWrkGrpRights(GFormID, "", tEmpUnqID) == false) { //dr["InTime"] = DBNull.Value; //dr["OutTime"] = DBNull.Value; //dr["ShiftCode"] = DBNull.Value; //dr["TPAHours"] = DBNull.Value; dr["Remarks"] = "Unauthorised.."; continue; } } Emp.CompCode = "01"; Emp.EmpUnqID = tEmpUnqID; Emp.GetEmpDetails(Emp.CompCode, Emp.EmpUnqID); } catch (Exception ex) { dr["Remarks"] = ex.ToString(); continue; } #endregion #region Chk_AllVals //check all values if all empty skip if (dr["InTime"].ToString() == "" && dr["OutTime"].ToString() == "" && dr["ShiftCode"].ToString() == "" && dr["TPAHours"].ToString() == "") { dr["Remarks"] = dr["Remarks"].ToString() + " Nothing to update..."; continue; } #endregion DateTime tInTime = new DateTime(), tOutTime = new DateTime(), tDate = new DateTime(); #region Chk_InTime if (dr["InTime"].ToString().Trim() != "" && dr["SanDate"] != DBNull.Value) { tInTime = Convert.ToDateTime(dr["SanDate"]); string[] inary = dr["InTime"].ToString().Split(':'); if (inary.GetLength(0) == 2) { tInTime = tInTime.AddHours(Convert.ToInt32(inary[0].ToString().Trim())); tInTime = tInTime.AddMinutes(Convert.ToInt32(inary[1].ToString().Trim())); } else { dr["InTime"] = DBNull.Value; dr["Remarks"] = dr["Remarks"].ToString() + " Invalid InTime, will not be considered.."; } } #endregion #region Chk_OutTime if (dr["OutTime"].ToString().Trim() != "" && dr["SanDate"] != DBNull.Value) { tOutTime = Convert.ToDateTime(dr["SanDate"]); string[] inary = dr["OutTime"].ToString().Split(':'); if (inary.GetLength(0) == 2) { tOutTime = tOutTime.AddHours(Convert.ToInt32(inary[0].ToString().Trim())); tOutTime = tOutTime.AddMinutes(Convert.ToInt32(inary[1].ToString().Trim())); } else { dr["OutTime"] = DBNull.Value; dr["Remarks"] = dr["Remarks"].ToString() + " Invalid OutTime, will not be considered.."; } } #endregion #region Chk_ShiftCode if (dr["ShiftCode"].ToString().Trim() != "") { if (!Globals.G_ShiftList.Contains(dr["ShiftCode"].ToString())) { dr["ShiftCode"] = ""; dr["Remarks"] = dr["Remarks"].ToString() + " Invalid ShiftCode, will not be considered.."; } } #endregion #region Chk_OverTime if (dr["TPAHours"].ToString() != "") { double t = 0; if (double.TryParse(dr["TPAHours"].ToString(), out t)) { if (t > 24) { dr["TPAHours"] = ""; dr["Remarks"] = dr["Remarks"].ToString() + " Invalid TPAHours, will not be considered.."; } } else { dr["TPAHours"] = ""; dr["Remarks"] = dr["Remarks"].ToString() + " Invalid TPAHours, will not be considered.."; } } #endregion #region Chk_AllVals //check all values if all empty skip if (dr["InTime"].ToString() == "" && dr["OutTime"].ToString() == "" && dr["ShiftCode"].ToString() == "" && dr["TPAHours"].ToString() == "") { dr["Remarks"] = dr["Remarks"].ToString() + " Nothing to update..."; continue; } #endregion string sWrkGrp = "", sDate = "", sInTime = "", sOutTime = "", sShiftCode = "", sOverTime = ""; sWrkGrp = Emp.WrkGrp; #region Set_InTime if (tInTime == DateTime.MinValue || tInTime == Convert.ToDateTime(dr["SanDate"])) { sInTime = " NULL "; } else if (tInTime.Hour > 0 || tInTime.Minute > 0) { sInTime = "'" + tInTime.ToString("yyyy-MM-dd HH:mm:ss") + "'"; } else { sInTime = " NULL "; } #endregion #region Set_OutTime if (tOutTime == DateTime.MinValue || tOutTime == Convert.ToDateTime(dr["SanDate"])) { sOutTime = " NULL "; } else if (tOutTime.Hour > 0 || tOutTime.Minute > 0) { sOutTime = "'" + tOutTime.ToString("yyyy-MM-dd HH:mm:ss") + "'"; } else { sOutTime = " NULL "; } #endregion #region Set_ShiftCode if (string.IsNullOrEmpty(dr["ShiftCode"].ToString())) { sShiftCode = " Null "; } else { sShiftCode = "'" + dr["ShiftCode"].ToString().ToUpper().Trim() + "'"; } #endregion #region Set_OverTime if (string.IsNullOrEmpty(dr["TPAHours"].ToString())) { sOverTime = " Null "; } else { sOverTime = "'" + dr["TPAHours"].ToString().Trim() + "'"; } #endregion #region Final_Update using (SqlCommand cmd = new SqlCommand()) { try { sDate = Convert.ToDateTime(dr["SanDate"]).ToString("yyyy-MM-dd"); tDate = Convert.ToDateTime(dr["SanDate"]); cmd.Connection = con; cmd.CommandType = CommandType.Text; string sql = "Insert Into MastLeaveSchedule " + " (tDate,EmpUnqID,WrkGrp,ConsInTime,ConsOutTime,ConsShift,ConsOverTime,AddId,AddDt) Values (" + " '" + sDate + "','" + Emp.EmpUnqID + "','" + sWrkGrp + "'," + sInTime + "," + sOutTime + "," + sShiftCode + "," + sOverTime + ",'" + Utils.User.GUserID + "',GetDate())"; cmd.CommandText = sql; cmd.CommandTimeout = 0; cmd.ExecuteNonQuery(); clsProcess pro = new clsProcess(); int result = 0; string proerr = string.Empty; pro.AttdProcess(Emp.EmpUnqID, tDate, tDate.AddDays(1), out result, out proerr); if (result > 0) { pro.LunchInOutProcess(Emp.EmpUnqID, tDate, tDate.AddDays(1), out result); dr["remarks"] = dr["remarks"].ToString() + "Record updated..."; } } catch (Exception ex) { dr["remarks"] = dr["remarks"].ToString() + ex.ToString(); continue; } } //using sqlcommand #endregion } //using foreach con.Close(); }//using connection Cursor.Current = Cursors.Default; MessageBox.Show("file uploaded Successfully, please check the remarks for indivisual record status...", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } DataSet ds = new DataSet(); ds.Tables.Add(sortedDT); grd_view.DataSource = ds; grd_view.DataMember = ds.Tables[0].TableName; grd_view.Refresh(); Cursor.Current = Cursors.Default; }
public void productTab() { clsProcess cl = new clsProcess(); CFManagerDataContext db = new CFManagerDataContext(); string result = "", content = ""; var type = from x in db.tProductTypes where x.BranchTypeId == branchTypeId && x.ParentTypeId == null && x.Status == 1 select x; foreach (var item in type.ToList()) { result += "<li rel='" + cl.ConvertToUnSign(item.ProductTypeName) + "'><span>" + item.ProductTypeName + "</span></li>"; content += "<div id='" + cl.ConvertToUnSign(item.ProductTypeName) + "' class='tab_content'><div class='owl-demo-tabproduct'>"; string ref_member = getRefMember(); var pro = db.sp_web_cf_loadProductByType(branchTypeId.ToString(), item.Id); foreach (var x in pro.ToList()) { content += "<div class='row_items'><div class='item'><div class='item-inner'><div class='images-container'>"; if (x.NoteSale != null && x.NoteSale != "") { content += "<div class='label-pro-new'><span>" + x.NoteSale + "</span></div>"; } content += "<a class='product-image' href='/" + ref_member + "detail/" + x.Id.ToString() + "/" + cl.ConvertToUnSign(x.ProductName) + ".html'><div class='product-image'>"; content += "<img src='" + (x.Image == null || x.Image == "" ? "/image/image-coming-soon.png" : x.Image) + "' alt='" + x.ProductName + "' class='img-responsive lazy imgzoom' /></div></a>"; content += "</div><div class='des-container'>"; content += "<p class='tags-product'>"; if (x.Tag != null && x.Tag != "") { if (x.Tag.Contains(",")) { var t = x.Tag.Split(','); foreach (var tg in t) { content += "<a href='/search/?k=" + Server.UrlEncode(tg) + "'>#" + tg + "</a>"; } } else { content += "<a href='/search/?k=" + Server.UrlEncode(x.Tag.Trim()) + "'>#" + x.Tag.Trim() + "</a>"; } } else { result += "<a href='#'></a>"; } content += "</p>"; content += " <h2 class='product-name'>"; content += "<a href='/" + ref_member + "detail/" + x.Id.ToString() + "/" + cl.ConvertToUnSign(x.ProductName) + ".html'>" + x.ProductTypeCode + " - " + x.ProductName + "</a></h2>"; content += "<div class='price-box'>"; content += "<p class='special-price'>"; if (x.PriceSale == 0 || x.PriceSale == x.Price) { content += "<span class='price'>" + string.Format("{0:0,0 đ}", x.Price) + "</span>"; } else { content += "<span class='price'>" + string.Format("{0:0,0 đ}", x.PriceSale) + "</span><span class='price' style='font-size:12px;padding-left:5px;'><del>" + string.Format("{0:0,0 đ}", x.Price) + "</del></span>"; } content += "</p>"; content += "</div>"; content += "<button class='button btn-cart' type='button' onclick=\"addCart(" + x.Id.ToString() + ",'" + x.ProductName + "',1" + ",'" + x.Image + "','" + string.Format("{0:0,0}", (x.Price == x.PriceSale ? x.Price.Value : x.PriceSale.Value)) + "',0)\" data-toggle='tooltip' title='Thêm nhanh vào giỏ hàng'>"; content += "<span>Giỏ hàng</span></button>-"; content += "<button class='button btn-quick' type='button' data-toggle='modal' data-target='#addQuickModal' onclick=\"showAddQuick(" + x.Id.ToString() + ",'" + x.ProductName + "','" + string.Format("{0:0,0}", (x.Price == x.PriceSale ? x.Price.Value : x.PriceSale.Value)) + "'," + (x.Price == x.PriceSale ? x.Price.ToString() : x.PriceSale.ToString()) + ")\" data-toggle='tooltip' title='Thử đồ sản phẩm này'>"; content += "<span><span>Thử đồ</span></span></button>"; content += "<div class='box-hover'><div class='ratings'><div class='rating-box'><div class='rating5'>"; content += "rating</div></div></div></div></div></div></div></div>"; } content += "</div></div>"; } lbTab.Text = result; lbProduct.Text = content; }
public void productFeature() { clsProcess cl = new clsProcess(); CFManagerDataContext db = new CFManagerDataContext(); var pro = db.sp_web_cf_loadProductFeature(branchTypeId.ToString()); string result = ""; int count = 0; string ref_member = getRefMember(); foreach (var item in pro.ToList()) { count++; if (count == 1 || count % 2 == 1) { result += "<div class='row_items'>"; } result += "<div class='item'><div class='item-inner'><div class='images-container'>"; if (item.NoteSale != null && item.NoteSale != "") { result += "<div class='label-pro-new'><span>" + item.NoteSale + "</span></div>"; } result += "<a class='product-image' href='/" + ref_member + "detail/" + item.Id.ToString() + "/" + cl.ConvertToUnSign(item.ProductName) + ".html'><img src='" + (item.Image == null || item.Image == "" ? "/image/image-coming-soon.png" : item.Image) + "' alt='" + item.ProductName + "' class='img-responsive lazy imgzoom' /></a>"; result += "</div><div class='des-container'>"; result += "<p class='tags-product'>"; if (item.Tag != null && item.Tag != "") { if (item.Tag.Contains(",")) { var t = item.Tag.Split(','); foreach (var tg in t) { result += "<a href='/search/?k=" + Server.UrlEncode(tg) + "'>#" + tg + "</a>"; } } else { result += "<a href='/search/?k=" + Server.UrlEncode(item.Tag.Trim()) + "'>#" + item.Tag.Trim() + "</a>"; } } else { result += "<a href='#'></a>"; } result += "</p>"; result += "<h2 class='product-name'><a href='/" + ref_member + "detail/" + item.Id.ToString() + "/" + cl.ConvertToUnSign(item.ProductName) + ".html'>" + item.ProductTypeCode + " - " + item.ProductName + "</a></h2>"; result += "<div class='price-box box-special'><p class='special-price'>"; if (item.PriceSale == 0 || item.Price == item.PriceSale) { result += "<span class='price'>" + string.Format("{0:0,0 đ}", item.Price) + "</span>"; } else { result += "<span class='price'>" + string.Format("{0:0,0 đ}", item.PriceSale) + "</span><span class='price' style='font-size:12px;padding-left:5px;'><del>" + string.Format("{0:0,0 đ}", item.Price) + "</del></span>"; } result += "</p></div>"; result += "<button class='button btn-cart' type='button' onclick=\"addCart(" + item.Id.ToString() + ",'" + item.ProductName + "',1" + ",'" + item.Image + "','" + string.Format("{0:0,0}", (item.Price == item.PriceSale ? item.Price.Value : item.PriceSale.Value)) + "',0)\" data-toggle='tooltip' title='Thêm nhanh vào giỏ hàng'>"; result += "<span><span>Giỏ hàng</span></span></button>-"; result += "<button class='button btn-quick' type='button' data-toggle='modal' data-target='#addQuickModal' onclick=\"showAddQuick(" + item.Id.ToString() + ",'" + item.ProductName + "','" + string.Format("{0:0,0}", (item.Price == item.PriceSale ? item.Price.Value : item.PriceSale.Value)) + "'," + (item.Price == item.PriceSale ? item.Price.ToString() : item.PriceSale.ToString()) + ")\" data-toggle='tooltip' title='Thử đồ sản phẩm này'>"; result += "<span><span>Thử đồ</span></span></button>"; result += "<div class='box-hover'><div class='ratings'><div class='rating-box'><div class='rating5'>rating</div>"; result += "</div></div></div></div></div></div>"; if (count % 2 == 0) { result += "</div>"; } } lbFProduct.Text = result; }
private void btnImport_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; DataTable LunchMachines = Utils.Helper.GetData("Select * from [LunchMachine]", Utils.Helper.constr).Tables[0]; DataTable dtMaterial = new DataTable(); DataTable sortedDT = new DataTable(); try { foreach (GridColumn column in grd_view1.VisibleColumns) { if (column.FieldName != string.Empty) { dtMaterial.Columns.Add(column.FieldName, column.ColumnType); } } for (int i = 0; i < grd_view1.DataRowCount; i++) { DataRow row = dtMaterial.NewRow(); foreach (GridColumn column in grd_view1.VisibleColumns) { row[column.FieldName] = grd_view1.GetRowCellValue(i, column); } dtMaterial.Rows.Add(row); } DataView dv = dtMaterial.DefaultView; dv.Sort = "EmpUnqID asc"; sortedDT = dv.ToTable(); using (SqlConnection con = new SqlConnection(Utils.Helper.constr)) { DateTime tdt; con.Open(); foreach (DataRow dr in sortedDT.Rows) { string tEmpUnqID = dr["EmpUnqID"].ToString(); try { tdt = Convert.ToDateTime(dr["SanDate"]); } catch (Exception ex) { dr["Remarks"] = "Sanction Date Conversion failed..."; continue; } string err = DataValidate(dr); if (!string.IsNullOrEmpty(err)) { dr["Remarks"] = err; continue; } if (string.IsNullOrEmpty(dr["Location"].ToString().Trim())) { dr["Remarks"] = "Location Must be Required.."; continue; } clsEmp Emp = new clsEmp(); #region Chk_Primary try { Emp.CompCode = "01"; Emp.EmpUnqID = tEmpUnqID; Emp.GetEmpDetails(Emp.CompCode, Emp.EmpUnqID); } catch (Exception ex) { dr["Remarks"] = ex.ToString(); continue; } #endregion #region Chk_AllVals //check all values if all empty skip if (dr["LunchInTime"].ToString() == "" && dr["LunchOutTime"].ToString() == "") { dr["Remarks"] = dr["Remarks"].ToString() + " Nothing to update..."; continue; } #endregion DateTime tInTime = new DateTime(), tOutTime = new DateTime(), tDate = new DateTime(); DateTime tSanDate = Convert.ToDateTime(dr["SanDate"]).Date; #region Chk_InTime if (dr["LunchInTime"].ToString().Trim() != "" && dr["SanDate"] != DBNull.Value) { tInTime = Convert.ToDateTime(dr["SanDate"]); string[] inary = dr["LunchInTime"].ToString().Split(':'); if (inary.GetLength(0) >= 2) { tInTime = tInTime.AddHours(Convert.ToInt32(inary[0].ToString().Trim())); tInTime = tInTime.AddMinutes(Convert.ToInt32(inary[1].ToString().Trim())); } else { dr["LunchInTime"] = DBNull.Value; dr["Remarks"] = dr["Remarks"].ToString() + " Invalid InTime, will not be considered.."; } } #endregion #region Chk_OutTime if (dr["LunchOutTime"].ToString().Trim() != "" && dr["SanDate"] != DBNull.Value) { tOutTime = Convert.ToDateTime(dr["SanDate"]); string[] inary = dr["LunchOutTime"].ToString().Split(':'); if (inary.GetLength(0) >= 2) { tOutTime = tOutTime.AddHours(Convert.ToInt32(inary[0].ToString().Trim())); tOutTime = tOutTime.AddMinutes(Convert.ToInt32(inary[1].ToString().Trim())); } else { dr["LunchOutTime"] = DBNull.Value; dr["Remarks"] = dr["Remarks"].ToString() + " Invalid OutTime, will not be considered.."; } } #endregion #region Chk_AllVals //check all values if all empty skip if (dr["LunchInTime"].ToString().Trim() == "" && dr["LunchOutTime"].ToString().Trim() == "") { dr["Remarks"] = dr["Remarks"].ToString() + " Nothing to update..."; continue; } string sWrkGrp = "", sDate = "", sInTime = "", sOutTime = "", sLocation = "", sInMachine = "", sOutMachine = ""; sWrkGrp = Emp.WrkGrp; sLocation = dr["Location"].ToString().Trim(); string expression; expression = "Location = '" + sLocation + "'"; DataRow[] foundRows; foundRows = LunchMachines.Select(expression); if (foundRows.Length <= 0) { dr["Remarks"] = dr["Remarks"].ToString() + " Invalid Location..."; continue; } else { sInMachine = foundRows[0]["InMachine"].ToString(); sOutMachine = foundRows[0]["OutMachine"].ToString(); } #endregion #region Set_InTime if (tInTime == DateTime.MinValue || tInTime == Convert.ToDateTime(dr["SanDate"])) { sInTime = " NULL "; } else if (tInTime.Hour > 0 || tInTime.Minute >= 0) { sInTime = "'" + tInTime.ToString("yyyy-MM-dd HH:mm:ss") + "'"; } else { sInTime = " NULL "; } #endregion #region Set_OutTime if (tOutTime == DateTime.MinValue || tOutTime == Convert.ToDateTime(dr["SanDate"])) { sOutTime = " NULL "; } else if (tOutTime.Hour > 0 || tOutTime.Minute >= 0) { sOutTime = "'" + tOutTime.ToString("yyyy-MM-dd HH:mm:ss") + "'"; } else { sOutTime = " NULL "; } #endregion #region Final_Update string sql = string.Empty; using (SqlCommand cmd = new SqlCommand()) { try { sDate = Convert.ToDateTime(dr["SanDate"]).ToString("yyyy-MM-dd"); tDate = Convert.ToDateTime(dr["SanDate"]); sql = string.Empty; cmd.Connection = con; cmd.CommandType = CommandType.Text; if (!string.IsNullOrEmpty(sInTime) && sInTime != " NULL ") { sql = "Insert Into AttdLunchGate " + " (PunchDate,EmpUnqID,IOFLG,MachineIP,LunchFlg,tYear,tYearMt,t1Date,AddDt,AddID) Values (" + " " + sInTime + ",'" + Emp.EmpUnqID + "','I','" + sInMachine + "',0,'" + tDate.Year + "','" + tDate.ToString("yyyyMM") + "','" + sDate + "',GetDate(),'" + Utils.User.GUserID + "-San" + "')"; } cmd.CommandText = sql; cmd.CommandTimeout = 0; cmd.ExecuteNonQuery(); if (!string.IsNullOrEmpty(sOutTime) && sOutTime != " NULL ") { sql = "Insert Into AttdLunchGate " + " (PunchDate,EmpUnqID,IOFLG,MachineIP,LunchFlg,tYear,tYearMt,t1Date,AddDt,AddID) Values (" + " " + sOutTime + ",'" + Emp.EmpUnqID + "','O','" + sOutMachine + "',0,'" + tDate.Year + "','" + tDate.ToString("yyyyMM") + "','" + sDate + "',GetDate(),'" + Utils.User.GUserID + "-San" + "')"; } cmd.CommandText = sql; cmd.CommandTimeout = 0; cmd.ExecuteNonQuery(); clsProcess pro = new clsProcess(); int result = 0; string proerr = string.Empty; pro.AttdProcess(Emp.EmpUnqID, tDate, tDate.AddDays(1), out result, out proerr); if (result > 0) { pro.LunchInOutProcess(Emp.EmpUnqID, tDate, tDate.AddDays(1), out result); dr["remarks"] = dr["remarks"].ToString() + "Record updated..."; } } catch (Exception ex) { dr["remarks"] = dr["remarks"].ToString() + ex.ToString(); continue; } } //using sqlcommand #endregion } //using foreach con.Close(); }//using connection Cursor.Current = Cursors.Default; MessageBox.Show("file uploaded Successfully, please check the remarks for indivisual record status...", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } DataSet ds = new DataSet(); ds.Tables.Add(sortedDT); grd_view.DataSource = ds; grd_view.DataMember = ds.Tables[0].TableName; grd_view.Refresh(); Cursor.Current = Cursors.Default; }
private void btnImport_Click(object sender, EventArgs e) { txtYearMT.Enabled = false; btnBrowse.Enabled = false; btnImport.Enabled = false; btnPreview.Enabled = false; if (grd_view1.DataRowCount <= 0) { MessageBox.Show("No Rows to Upload", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } Cursor.Current = Cursors.WaitCursor; DataTable dtMaterial = new DataTable(); DataTable sortedDT = new DataTable(); try { foreach (GridColumn column in grd_view1.VisibleColumns) { if (column.FieldName != string.Empty) { dtMaterial.Columns.Add(column.FieldName, column.ColumnType); } } for (int i = 0; i < grd_view1.DataRowCount; i++) { DataRow row = dtMaterial.NewRow(); foreach (GridColumn column in grd_view1.VisibleColumns) { row[column.FieldName] = grd_view1.GetRowCellValue(i, column); } dtMaterial.Rows.Add(row); } DataView dv = dtMaterial.DefaultView; dv.Sort = "EmpUnqID asc"; sortedDT = dv.ToTable(); using (SqlConnection cn = new SqlConnection(Utils.Helper.constr)) { DateTime StartDt = new DateTime(), EndDt = new DateTime(); string sql = string.Empty; string tYearMt = txtYearMT.DateTime.ToString("yyyyMM"); string stdt = Utils.Helper.GetDescription("Select CAL_MthStart From V_CAL0815 where Cal_Date ='" + txtYearMT.DateTime.ToString("yyyy-MM-dd") + "'", Utils.Helper.constr); string endt = Utils.Helper.GetDescription("Select CAL_MthEnd From V_CAL0815 where Cal_Date ='" + txtYearMT.DateTime.ToString("yyyy-MM-dd") + "'", Utils.Helper.constr); StartDt = Convert.ToDateTime(stdt); EndDt = Convert.ToDateTime(endt); foreach (DataRow dr in sortedDT.Rows) { if (cn.State == ConnectionState.Open) { cn.Close(); } bool ProcessFlg = chkProcessFlg.Checked; cn.Open(); bool brkflg = false; string tEmpUnqID = dr["EmpUnqID"].ToString(); string tCompCode = Utils.Helper.GetDescription("Select CompCode From MastEmp where EmpUnqID ='" + tEmpUnqID + "'", Utils.Helper.constr); clsEmp Emp = new clsEmp(); Emp.GetEmpDetails(tCompCode, tEmpUnqID); if (!Emp.Active) { dr["Remarks"] = "Invalid/InActive Employee.."; continue; } if (!Globals.GetWrkGrpRights(GFormID, Emp.WrkGrp, Emp.EmpUnqID)) { dr["Remarks"] = "you are not authorised.."; continue; } List <int> woidx = new List <int>(); #region Chk_ValidShift for (int i = 1; i <= EndDt.Day; i++) { string fldnm = "D" + i.ToString("00"); string fldval = dr[fldnm].ToString().Trim().ToUpper(); if (fldval != "WO") { if (!Globals.G_ShiftList.Contains(fldval)) { dr["Remarks"] = dr["Remarks"].ToString() + " Invalid Shift.."; brkflg = true; break; } } else { woidx.Add(i); } if (fldval.Trim() == string.Empty) { dr["Remarks"] = dr["Remarks"].ToString() + " Invalid Shift.."; brkflg = true; break; } } if (woidx.Count == 0) { dr["Remarks"] = dr["Remarks"].ToString() + " No Week of has been defined.."; brkflg = true; } if (brkflg) { continue; } #region Check_WO_Order //int firstWOon = woidx.First(); //int tchk = 0; //for (int i = 1; i <= woidx.Count - 1; i++) //{ // tchk = (7 * i) + firstWOon; // if(woidx.ElementAt(i) != tchk) // { // dr["Remarks"] = dr["Remarks"].ToString() + string.Format("{0} WeekOff is not in correct order..",i); // //brkflg = true; // break; // } //} //if (brkflg) //{ // continue; //} #endregion #endregion SqlTransaction trn = cn.BeginTransaction("ShiftSch-" + Emp.EmpUnqID); SqlCommand cmd = new SqlCommand(); #region Chk_ShiftSchedule_Rec try { int cnt = Convert.ToInt32(Utils.Helper.GetDescription("Select Count(*) from MastShiftSchedule where EmpUnqID = '" + tEmpUnqID + "' And YearMt ='" + tYearMt + "'", Utils.Helper.constr)); if (cnt == 0) { sql = "Insert into MastShiftSchedule (YearMt,EmpUnqID,AddDt,AddId) Values ('" + tYearMt + "','" + tEmpUnqID + "',GetDate(),'" + Utils.User.GUserID + "')"; cmd = new SqlCommand(sql, cn, trn); cmd.ExecuteNonQuery(); } else { sql = "insert into MastShiftScheduleHistory ( [YearMt],[EmpUnqID], " + " [D01],[D02],[D03],[D04],[D05],[D06],[D07],[D08],[D09],[D10]," + " [D11],[D12],[D13],[D14],[D15],[D16],[D17],[D18],[D19],[D20],[D21], " + " [D22],[D23],[D24],[D25],[D26],[D27],[D28],[D29],[D30],[D31],[ADDID], " + " [ADDDT],[UPDID],[UPDDT]) " + " Select " + " [YearMt],[EmpUnqID]," + " [D01],[D02],[D03],[D04],[D05],[D06],[D07],[D08],[D09],[D10]," + " [D11],[D12],[D13],[D14],[D15],[D16],[D17],[D18],[D19],[D20],[D21], " + " [D22],[D23],[D24],[D25],[D26],[D27],[D28],[D29],[D30],[D31],[ADDID]," + " [ADDDT],[UPDID],[UPDDT] from MastShiftSchedule " + " where YearMt = '" + tYearMt + "' " + " and EmpUnqID = '" + tEmpUnqID + "' "; cmd = new SqlCommand(sql, cn, trn); cmd.ExecuteNonQuery(); sql = "Update MastShiftSchedule Set UpdDt = GetDate() , UpdID = '" + Utils.User.GUserID + "' Where YearMt = '" + tYearMt + "' And EmpUnqID ='" + tEmpUnqID + "'"; cmd = new SqlCommand(sql, cn, trn); cmd.ExecuteNonQuery(); } } catch (Exception ex) { brkflg = true; dr["Remarks"] = dr["Remarks"].ToString() + Environment.NewLine + ex.ToString(); } if (brkflg) { trn.Rollback(); cn.Close(); trn.Dispose(); continue; } #endregion #region Get_IFAnyLeavePosted sql = "Select * from LeaveEntry Where " + " compcode = '" + Emp.CompCode + "'" + " and WrkGrp ='" + Emp.WrkGrp + "'" + " And tYear ='" + tYearMt.Substring(0, 4) + "'" + " And EmpUnqID='" + tEmpUnqID + "'" + " And ( FromDt between '" + StartDt.ToString("yyyy-MM-dd") + "' And '" + EndDt.ToString("yyyy-MM-dd") + "' " + " OR ToDt Between '" + StartDt.ToString("yyyy-MM-dd") + "' And '" + EndDt.ToString("yyyy-MM-dd") + "' " + " ) Order by FromDt "; DataSet dsLeave = Utils.Helper.GetData(sql, Utils.Helper.constr); List <LeaveData> leave = new List <LeaveData>(); bool hasRows = dsLeave.Tables.Cast <DataTable>().Any(table => table.Rows.Count != 0); if (hasRows) { foreach (DataRow drl in dsLeave.Tables[0].Rows) { LeaveData t = new LeaveData(); t.FromDt = Convert.ToDateTime(drl["FromDt"]); t.ToDt = ((Convert.ToDateTime(drl["ToDt"]) > EndDt) ? EndDt : Convert.ToDateTime(drl["ToDt"])); t.LeaveTyp = drl["LeaveTyp"].ToString(); leave.Add(t); } } #endregion #region Upd_ShiftSchedule_AttdData string ShiftSql = string.Empty; for (DateTime date = StartDt; date.Date <= EndDt.Date; date = date.AddDays(1)) { string fldnm = "D" + date.ToString("dd"); string fldval = dr[fldnm].ToString().Trim().ToUpper(); try { string sqlattd = "Update AttdData " + " Set ScheduleShift ='" + fldval + "' Where tYear = '" + date.Year.ToString() + "' And tDate ='" + date.ToString("yyyy-MM-dd") + "' " + " And CompCode = '" + Emp.CompCode + "' And WrkGrp ='" + Emp.WrkGrp + "' And EmpUnqID='" + Emp.EmpUnqID + "'"; cmd = new SqlCommand(sqlattd, cn, trn); cmd.ExecuteNonQuery(); } catch (Exception ex) { brkflg = true; dr["Remarks"] = dr["Remarks"].ToString() + Environment.NewLine + ex.ToString(); break; } ShiftSql += fldnm + " = '" + fldval + "',"; } //end foreach date if (brkflg) { trn.Rollback(); cn.Close(); trn.Dispose(); continue; } try { //update shiftschedule sql = "Update MastShiftSchedule Set " + ShiftSql.Substring(0, ShiftSql.Length - 1) + " Where Yearmt = '" + tYearMt + "' and EmpUnqId ='" + Emp.EmpUnqID + "' "; cmd = new SqlCommand(sql, cn, trn); cmd.ExecuteNonQuery(); } catch (Exception ex) { brkflg = true; dr["Remarks"] = dr["Remarks"].ToString() + Environment.NewLine + ex.ToString(); } if (brkflg) { trn.Rollback(); cn.Close(); trn.Dispose(); continue; } #endregion #region chk_LeavePosted if (leave.Count == 0) { #region ifnoleavefound //delete schedule wo string delsql = "Delete From MastLeaveSchedule Where tYear ='" + StartDt.Year.ToString() + "' " + " And tYearMT='" + tYearMt + "' " + " And EmpUnqID ='" + Emp.EmpUnqID + "' And SchLeave='WO' "; try { cmd = new SqlCommand(delsql, cn, trn); cmd.ExecuteNonQuery(); } catch (Exception ex) { dr["Remarks"] = dr["Remarks"].ToString() + Environment.NewLine + ex.ToString(); brkflg = true; } if (brkflg) { trn.Rollback(); cn.Close(); trn.Dispose(); continue; } //'Insert "WO" MastLeaveSchedule Table for (DateTime date = StartDt; date.Date <= EndDt.Date; date = date.AddDays(1)) { string fldnm = "D" + date.ToString("dd"); string fldval = dr[fldnm].ToString().Trim().ToUpper(); if (fldval == "WO") { string inssql = " Insert into MastLeaveSchedule " + " ( EmpUnqID,WrkGrp,tDate,SchLeave,Adddt,AddId )" + " Values ('" + Emp.EmpUnqID + "','" + Emp.WrkGrp + "','" + date.ToString("yyyy-MM-dd") + "','WO',GetDate(),'ShiftSch')"; try { cmd = new SqlCommand(inssql, cn, trn); cmd.ExecuteNonQuery(); } catch (Exception ex) { dr["Remarks"] = dr["Remarks"].ToString() + Environment.NewLine + ex.ToString(); brkflg = true; break; } } } if (brkflg) { trn.Rollback(); cn.Close(); trn.Dispose(); continue; } #endregion } else { #region ifleavefound DateTime LastWO = new DateTime(); for (DateTime date = StartDt; date.Date <= EndDt.Date; date = date.AddDays(1)) { string fldnm = "D" + date.ToString("dd"); string fldval = dr[fldnm].ToString().Trim().ToUpper(); bool LeavPos = false; if (fldval == "WO") { foreach (LeaveData t in leave) { //check if date is fall between leave posted if (date >= t.FromDt && date <= t.ToDt) { LeavPos = true; date = t.ToDt; LastWO = t.ToDt; break; } } if (LeavPos) { continue; } //'if there is no leave posted on tdate if (!LeavPos) { if (LastWO != DateTime.MinValue) { try { string delwo = "Delete from MastLeaveSchedule Where EmpUnqID = '" + Emp.EmpUnqID + "' " + " and tDate > '" + LastWO.ToString("yyyy-MM-dd") + "' and tDate <= '" + date.ToString("yyyy-MM-dd") + "' and SchLeave ='WO'"; LastWO = date; cmd = new SqlCommand(delwo, cn, trn); cmd.ExecuteNonQuery(); } catch (Exception ex) { dr["Remarks"] = dr["Remarks"].ToString() + Environment.NewLine + ex.ToString(); brkflg = true; break; } } else { try { string delwo = "Delete from MastLeaveSchedule Where EmpUnqID = '" + Emp.EmpUnqID + "' and tDate = '" + date.ToString("yyyy-MM-dd") + "' and SchLeave ='WO'"; cmd = new SqlCommand(delwo, cn, trn); cmd.ExecuteNonQuery(); } catch (Exception ex) { dr["Remarks"] = dr["Remarks"].ToString() + Environment.NewLine + ex.ToString(); brkflg = true; break; } } try { string inssql = " Insert into MastLeaveSchedule ( EmpUnqID,WrkGrp,tDate,SchLeave,Adddt,AddId )" + " Values ('" + Emp.EmpUnqID + "','" + Emp.WrkGrp + "','" + date.ToString("yyyy-MM-dd") + "','WO',GetDate(),'ShiftSch')"; cmd = new SqlCommand(inssql, cn, trn); cmd.ExecuteNonQuery(); }catch (Exception ex) { dr["Remarks"] = dr["Remarks"].ToString() + Environment.NewLine + ex.ToString(); brkflg = true; break; } } }//end if WO else { LeavPos = false; foreach (LeaveData t in leave) { //check if date is fall between leave posted if (date >= t.FromDt && date <= t.ToDt) { LeavPos = true; break; } } if (!LeavPos) { try { sql = "Delete from MastLeaveSchedule Where EmpUnqID = '" + Emp.EmpUnqID + "' " + " and tDate = '" + date.ToString("yyyy-MM-dd") + "' and SchLeave ='WO'"; cmd = new SqlCommand(sql, cn, trn); cmd.ExecuteNonQuery(); } catch (Exception ex) { dr["Remarks"] = dr["Remarks"].ToString() + Environment.NewLine + ex.ToString(); brkflg = true; break; } } } } //end of eachday if (brkflg) { trn.Rollback(); cn.Close(); trn.Dispose(); continue; } //remove any extra "WO" if try { if (LastWO != DateTime.MinValue) { sql = "Delete from MastLeaveSchedule Where EmpUnqID = '" + Emp.EmpUnqID + "' and tDate > '" + LastWO.ToString("yyyy-MM-dd") + "' " + " and tDate <= '" + EndDt.ToString("yyyy-MM-dd") + "' and SchLeave ='WO'"; cmd = new SqlCommand(sql, cn, trn); cmd.ExecuteNonQuery(); } } catch (Exception ex) { dr["Remarks"] = dr["Remarks"].ToString() + Environment.NewLine + ex.ToString(); brkflg = true; break; } #endregion } //end if leavefound if (brkflg) { trn.Rollback(); cn.Close(); trn.Dispose(); continue; } #endregion try { trn.Commit(); dr["Remarks"] = "Uploded"; //process data if (ProcessFlg) { clsProcess pro = new clsProcess(); int result = 0; string proerr = string.Empty; pro.AttdProcess(Emp.EmpUnqID, StartDt, EndDt, out result, out proerr); if (result > 0) { pro.LunchInOutProcess(Emp.EmpUnqID, StartDt, EndDt, out result); //dr["remarks"] = dr["remarks"].ToString() + "Record updated..."; } } } catch (Exception ex) { trn.Rollback(); dr["Remarks"] = dr["Remarks"].ToString() + Environment.NewLine + ex.ToString(); brkflg = true; } trn.Dispose(); cn.Close(); } //using foreach of all employee } //using connection Cursor.Current = Cursors.Default; MessageBox.Show("file uploaded Successfully, please check the remarks for indivisual record status...", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } DataSet ds = new DataSet(); ds.Tables.Add(sortedDT); grd_view.DataSource = ds; grd_view.DataMember = ds.Tables[0].TableName; grd_view.Refresh(); Cursor.Current = Cursors.Default; txtYearMT.Enabled = true; btnBrowse.Enabled = true; btnPreview.Enabled = true; if (GRights.Contains("A") || GRights.Contains("U") || GRights.Contains("D")) { btnImport.Enabled = true; } else { btnImport.Enabled = false; } }
private void btnProcess_Click(object sender, EventArgs e) { string err = DataValidate(); if (!string.IsNullOrEmpty(err)) { MessageBox.Show(err, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (!string.IsNullOrEmpty(txtEmpUnqID.Text.Trim())) { if (string.IsNullOrEmpty(txtEmpName.Text.Trim())) { MessageBox.Show("Please Enter Valid Employee", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } if (!GRights.Contains("AUDV")) { MessageBox.Show("You are not fully authorised..", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } string sql = string.Empty; string question = string.Empty; DialogResult drq; string sWrkGrp = txtWrkGrpCode.Text.Trim().ToString(); string sEmpUnqID = txtEmpUnqID.Text.Trim().ToString(); if (string.IsNullOrEmpty(txtEmpUnqID.Text.Trim())) { question = "Are You Sure to Process HalfDay Rules Check For : " + sWrkGrp + Environment.NewLine + "Processed Data will be deleted between '" + txtFromDt.DateTime.ToString("yyyy-MM-dd") + "' And '" + txtToDate.DateTime.ToString("yyyy-MM-dd") + "' "; sql = "Select CompCode,WrkGrp,EmpUnqID,OTFlg,WeekOff from mastemp where CompCode = '01' and Wrkgrp = '" + sWrkGrp + "' And Active = 1 Order By EmpUnqID"; } else { question = "Are You Sure to to Process HalfDay Rules Check For : " + txtEmpUnqID.Text.Trim().ToString() + Environment.NewLine + "Processed Data will be deleted between '" + txtFromDt.DateTime.ToString("yyyy-MM-dd") + "' And '" + txtToDate.DateTime.ToString("yyyy-MM-dd") + "' "; sql = "Select CompCode,WrkGrp,EmpUnqID,OTFlg,WeekOff From MastEmp Where CompCode ='" + txtCompCode.Text.Trim() + "' " + " and WrkGrp = '" + sWrkGrp + "' " + " and EmpUnqID ='" + sEmpUnqID + "' "; } drq = MessageBox.Show(question, "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (drq == DialogResult.No) { MessageBox.Show("Process Canceled..", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } btnProcess.Enabled = false; txtWrkGrpCode.Enabled = false; txtEmpUnqID.Enabled = false; txtFromDt.Enabled = false; txtToDate.Enabled = false; DateTime tFromDt = txtFromDt.DateTime; DateTime tToDt = txtToDate.DateTime; Cursor.Current = Cursors.WaitCursor; DataSet ds = Utils.Helper.GetData(sql, Utils.Helper.constr); pBar.Properties.Maximum = ds.Tables[0].Rows.Count + 1; clsProcess pro = new clsProcess(); foreach (DataRow drs in ds.Tables[0].Rows) { //update progressbar pBar.PerformStep(); pBar.Update(); string tEmpUnqID = drs["EmpUnqID"].ToString(); string tWrkGrp = drs["WrkGrp"].ToString(); txtError.Text = "Processing Emp :" + sEmpUnqID + Environment.NewLine; string status = string.Empty; pro.HalfDay_Rules_Process(tWrkGrp, tEmpUnqID, tFromDt, tToDt, out status); if (!string.IsNullOrEmpty(status)) { txtError.Text += status + Environment.NewLine; } } //foreach loop drs MessageBox.Show("Process Completed...", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); Cursor.Current = Cursors.Default; ResetCtrl(); SetRights(); }
/// <summary> /// Process Names (ATTD,MESS,LUNCHINOUT) GLOBAL VAR OF FORM /// Process Mode (APP,SERVER) -> Kind of Process wether application side , server side /// ProcessType (EMP,WRKGRP) -> Employee Wise or WrkGrp Wise /// </summary> /// <param name="sender"></param> /// <param name="e"></param> /// <param name="ProcessMode">APP/SERVER</param> /// <param name="ProcessType">EMP/WRKGRP</param> private void ProcessDATA(object sender, EventArgs e, string tProcessMode = "APP", string tProcessType = "EMP") { if (ProcessList.Rows.Count <= 0) { MessageBox.Show("No Records found to process..", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } btnAdd.Enabled = false; btnDelete.Enabled = false; btnClearList.Enabled = false; btnProcessWrkGrp.Enabled = false; txtWrkFromDt.Enabled = false; txtWrkToDate.Enabled = false; txtWrkGrpCode.Enabled = false; ISProcessStarted = true; appstatus_Tick(sender, e); Cursor.Current = Cursors.WaitCursor; clsProcess pr = new clsProcess(); if (ProcessName == "ATTD") { foreach (DataRow dr in ProcessList.Rows) { string tEmpUnqID = dr["EmpUnqID"].ToString(); DateTime tFromDt = Convert.ToDateTime(dr["FromDate"]); DateTime tToDt = Convert.ToDateTime(dr["ToDate"]); int res; string proerr = string.Empty; pr.AttdProcess(tEmpUnqID, tFromDt, tToDt, out res, out proerr); //update processed status if (res > 0) { dr.BeginEdit(); dr["IsDone"] = 1; dr["Status"] = "Processed"; dr.EndEdit(); dr.AcceptChanges(); RefreshAppGrid(sender, e); Application.DoEvents(); } if (!string.IsNullOrEmpty(proerr)) { dr["Status"] = "Processed but with error : " + proerr; } } } else if (ProcessName == "MESS") { foreach (DataRow dr in ProcessList.Rows) { string tEmpUnqID = dr["EmpUnqID"].ToString(); DateTime tFromDt = Convert.ToDateTime(dr["FromDate"]); DateTime tToDt = Convert.ToDateTime(dr["ToDate"]); int res; pr.LunchProcess(tEmpUnqID, tFromDt, tToDt, out res); Application.DoEvents(); //update processed status if (res > 0) { dr.BeginEdit(); dr["IsDone"] = 1; dr["Status"] = "Processed"; dr.EndEdit(); dr.AcceptChanges(); RefreshAppGrid(sender, e); } } } else if (ProcessName == "LUNCHINOUT") { foreach (DataRow dr in ProcessList.Rows) { string tEmpUnqID = dr["EmpUnqID"].ToString(); DateTime tFromDt = Convert.ToDateTime(dr["FromDate"]); DateTime tToDt = Convert.ToDateTime(dr["ToDate"]); int res; pr.LunchInOutProcess(tEmpUnqID, tFromDt, tToDt, out res); Application.DoEvents(); //update processed status if (res > 0) { dr.BeginEdit(); dr["IsDone"] = 1; dr["Status"] = "Processed"; dr.EndEdit(); dr.AcceptChanges(); RefreshAppGrid(sender, e); } } } Cursor.Current = Cursors.Default; btnAdd.Enabled = true; btnDelete.Enabled = true; btnProcessWrkGrp.Enabled = true; txtWrkFromDt.Enabled = true; txtWrkToDate.Enabled = true; txtWrkGrpCode.Enabled = true; btnClearList.Enabled = true; ISProcessStarted = false; appstatus_Tick(sender, e); MessageBox.Show("Process Completed...", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); }
public static result updateReceiverPayment(string name, string phone, string add, string countryid, string country, string districtid, string district, int type) { var r = new result(); if (!string.IsNullOrEmpty(Convert.ToString(HttpContext.Current.Session["cn_mb_user_id"]))) { CNManagerDataContext db = new CNManagerDataContext(); clsProcess cl = new clsProcess(); var x = from n in db.tMembers where n.Id == int.Parse(HttpContext.Current.Session["cn_mb_user_id"].ToString()) select n; if (x.Count() == 1) { if (type == 1) { x.FirstOrDefault().r_name = name.Trim(); x.FirstOrDefault().r_phone = phone.Trim(); x.FirstOrDefault().r_add = add.Trim(); if (countryid.Trim() != "") { x.FirstOrDefault().r_countryid = int.Parse(countryid.Trim()); x.FirstOrDefault().r_countryname = country; } else { x.FirstOrDefault().r_countryid = null; x.FirstOrDefault().r_countryname = ""; } if (districtid.Trim() != "") { x.FirstOrDefault().r_districtid = int.Parse(districtid.Trim()); x.FirstOrDefault().r_districtname = district; } else { x.FirstOrDefault().r_districtid = null; x.FirstOrDefault().r_districtname = ""; } db.SubmitChanges(); } else { x.FirstOrDefault().p_name = name.Trim(); x.FirstOrDefault().p_phone = phone.Trim(); x.FirstOrDefault().p_add = add.Trim(); if (countryid.Trim() != "") { x.FirstOrDefault().p_countryid = int.Parse(countryid.Trim()); x.FirstOrDefault().p_countryname = country; } else { x.FirstOrDefault().p_countryid = null; x.FirstOrDefault().p_countryname = ""; } if (districtid.Trim() != "") { x.FirstOrDefault().p_districtid = int.Parse(districtid.Trim()); x.FirstOrDefault().p_districtname = district; } else { x.FirstOrDefault().p_districtid = null; x.FirstOrDefault().p_districtname = ""; } db.SubmitChanges(); } r._mess = "Cập nhật thành công"; r._content = "ok"; } else { r._mess = "Không tìm thấy thông tin thành viên, vui lòng thử lại"; r._content = "error"; } } else { r._mess = "Hết phiên đăng nhập, vui lòng đăng nhập lại"; r._content = "error"; } return(r); }