public static string AddOrUpdateItem(int itemID, string maLoai, string tenLoai, string ghiChu) { try { //Initial data context variable, this class is declared in .dbml file in xRPDAL namespace xRPDataContext dts = new xRPDataContext(); //Get current user info var user = (from u in dts.aspnet_Users where u.UserName == HttpContext.Current.User.Identity.Name select u).FirstOrDefault(); int?id = null; if (itemID == 0 || itemID == -1) { } else { id = itemID; } Sp_Qlvt_LoaiVatTu_SelectResult current = null; if (id.HasValue) { current = dts.Sp_Qlvt_LoaiVatTu_Select(1, id.Value, "", null, null, "").FirstOrDefault(); } string result = dts.Sp_Qlvt_LoaiVatTu_Add_Edit_Deli(!id.HasValue ? "ADD" : "EDIT", id, maLoai, tenLoai, "", ghiChu, current == null || !current.KichHoat.HasValue ? 1 : (current.KichHoat.Value ? 1 : 0), current != null ? current.MaNguoiTao : user.UserId, current != null ? user.UserId : (Guid?)null, ref id, "IP", "PC").FirstOrDefault().Column1; return(result != null && result != "" ? result : id.ToString()); } catch (Exception ex) { return("ERROR: " + ex.Message + ex.StackTrace); } }
public string GetMaLoaiVatTuJSONData(int maVatTu) { xRPDataContext dts = new xRPDataContext(); string data = "[]"; try { var vatTu = dts.Sp_Qlvt_VatTu_Select(2, maVatTu, (int?)null, (int?)null).FirstOrDefault(); if (vatTu == null) { return("{\"ERROR\":\"Vật tư không tồn tại.\"}"); } List <object> list = new List <object>(); foreach (var lvt in dts.Sp_Qlvt_LoaiVatTu_Select(1, vatTu.MaLoaiVatTu, "", (int?)null, (int?)null)) { list.Add(new { data = lvt.MaHieuLoaiVatTu }); } data = new JavaScriptSerializer().Serialize(list); } catch (Exception ex) { data = "{error:\"" + ex.Message + "\"}"; } return(data); }