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);
}
