public void CreateRoom() { roomID = GenerateID.NumberOnly(5); connectAction = ConnectAction.CREATE; Connect(); }
protected void GridViewExpense_RowCommand(object sender, GridViewCommandEventArgs e) { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); if (e.CommandName == "AddNew") { string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID); try { dbo_RevenueExpenseClass rev = new dbo_RevenueExpenseClass(); rev.Post_No = txtPost_No.Text;// GenerateID.Post_No(user_class.CV_CODE); rev.CV_Code = user_class.CV_CODE; rev.Post_Date = DateTime.Now; TextBox txtFooterRevenue_Amount = (TextBox)GridViewExpense.FooterRow.FindControl("txtFooter_Amount"); rev.Amount = txtFooterRevenue_Amount.Text == "" ? 0 : decimal.Parse(txtFooterRevenue_Amount.Text); DropDownList _ddlFooterDetail = (DropDownList)GridViewExpense.FooterRow.FindControl("ddlFooterDetail"); rev.Account_Code = _ddlFooterDetail.SelectedValue; rev.Account_No = GenerateID.EP(user_class.CV_CODE); TextBox txtFooterRemark = (TextBox)GridViewExpense.FooterRow.FindControl("txtFooterRemark"); rev.Remark = txtFooterRemark.Text; bool succes = false; succes = dbo_RevenueExpenseDataClass.Add(rev); if (succes) { System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("บันทึกสำเร็จ!"); } GridViewExpense.ShowFooter = false; InitialExpense(); System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); } catch (Exception ex) { logger.Error(ex.Message); } } else if (e.CommandName == "_Delete") { LinkButton lnkView = (LinkButton)e.CommandSource; string Account_No = lnkView.CommandArgument; dbo_RevenueExpenseDataClass.Delete(Account_No); System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("ลบข้อมูลสำเร็จ"); InitialExpense(); } }
protected void ButtonCreateNew_Click(object sender, EventArgs e) { // GridViewRole.EditIndex = -1; //DataTable dt = dbo_RoleDataClass.SelectAll(); //GridViewRole.DataSource = dt.DefaultView; //GridViewRole.DataBind(); GridViewRole.ShowFooter = true; SearchSubmit(); try { TextBox _Row_ID = (TextBox)GridViewRole.FooterRow.FindControl("txtNewRole_ID"); _Row_ID.Enabled = false; _Row_ID.Text = GenerateID.Role_ID(); TextBox _Row_Name = (TextBox)GridViewRole.FooterRow.FindControl("txtNewRole_Name"); DropDownList _Row_Type = (DropDownList)GridViewRole.FooterRow.FindControl("ddlNewRole_Type"); _Row_Name.Focus(); } catch (Exception) { } // ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", " window.scrollTo(0, document.body.clientHeight);", true); //ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), // "selectNode", @"var node = document.getElementById('ContentPlaceHolder1_TreeView2t22');node.scrollIntoView(true);elem.scrollLeft=0;", true); System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); }
public bool InsertCompanyNoteInfo(NoteInfo noteInfo, List <NoteInfoDetail> noteInfoDetails) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = NoteInfoDAO.GetMaxSEQ(BSServerConst.NoteInfoSymbol) + 1; noteInfo.NoteID = GenerateID.NewID(BSServerConst.NoteInfoSymbol, seq, false, false); NoteInfoDAO.InsertNoteInfo(noteInfo); // Thêm chi tiết foreach (var data in noteInfoDetails) { data.NoteID = noteInfo.NoteID; NoteInfoDetailDAO.InsertNoteInfoDetail(data); } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return(false); } } }
private void InsertRecord() { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); dbo_ProductClass clsdbo_Product = new dbo_ProductClass(); SetData(clsdbo_Product); bool success = false; string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; success = dbo_ProductDataClass.Add(clsdbo_Product, User_ID); dbo_ProductListClass clsdbo_ProductList = new dbo_ProductListClass(); List <dbo_PriceGroupClass> price_group = dbo_PriceGroupDataClass.Search(string.Empty, "0"); dbo_PriceGroupClass price_group_id = price_group.FirstOrDefault(f => f.StandardPrice == true); clsdbo_ProductList.Price_Group_ID = price_group_id.Price_Group_ID; clsdbo_ProductList.Product_List_ID = GenerateID.Product_List_ID(); var date = new DateTime(9456, 12, 31); clsdbo_ProductList.Agent_Price = clsdbo_Product.Agent_Price; clsdbo_ProductList.Product_Effective_Date = DateTime.Now; clsdbo_ProductList.Start_Effective_Date = DateTime.Now; clsdbo_ProductList.End_Effective_Date = date; clsdbo_ProductList.Product_ID = clsdbo_Product.Product_ID; clsdbo_ProductList.Product_Name = clsdbo_Product.Product_Name; clsdbo_ProductList.Point = clsdbo_Product.Point; clsdbo_ProductList.Vat = clsdbo_Product.Vat; //clsdbo_ProductList.CP_Meiji_Price = clsdbo_Product.CP_Meiji_Price; dbo_ProductListDataClass.Add(clsdbo_ProductList, User_ID); price_group = dbo_PriceGroupDataClass.Search(string.Empty, "1"); price_group_id = price_group.FirstOrDefault(f => f.StandardPrice == true); if (price_group_id != null) { clsdbo_ProductList.Price_Group_ID = price_group_id.Price_Group_ID; clsdbo_ProductList.SP_Price = clsdbo_Product.SP_Price; clsdbo_ProductList.CP_Meiji_Price = clsdbo_Product.CP_Meiji_Price; clsdbo_ProductList.Agent_Price = null; clsdbo_ProductList.Product_List_ID = GenerateID.Product_List_ID(); dbo_ProductListDataClass.Add(clsdbo_ProductList, User_ID); } if (success) { Show("บันทึกสำเร็จ"); } else { Show("error"); } }
public override void OnJoinRandomFailed(short returnCode, string message) { Debug.Log("Falhou ao se conectar a uma sala... Criando Sala"); roomID = GenerateID.NumberOnly(5); PhotonNetwork.CreateRoom(roomID, new RoomOptions { MaxPlayers = maxPlayers }); }
public bool InsertCompany(Company data) { long seq = this.CompanyDAO.GetCompanySEQ() + 1; data.CompanyID = GenerateID.CompanyID(seq); return(this.CompanyDAO.InsertCompany(data)); }
public bool SaveDMQLConnectQL(List <QuanLy> quanLies, DMQuanLy dMQuanLies) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = DMQLConnectQLDAO.GetDMQLConnectQLSEQ(); foreach (QuanLy data in quanLies) { #region chuẩn bị dữ liệu cho DMQLConnectQL //Khi insert Quan Lý thì Quản Lý sẽ thuộc một Danh mục quản lý được chọn trước đó. //Đảm bảo rằng khi thay đổi năm quyết toán của QuanLy thì dữ liệu quyết toán năm cũ không thay đổi. DMQLConnectQL dMQLConnectQL = new DMQLConnectQL(); dMQLConnectQL.DMQuanLyID = dMQuanLies.DMQuanLyID; dMQLConnectQL.QLID = data.QLID; dMQLConnectQL.QLMa = data.QLMa; dMQLConnectQL.QLTen = data.QLTen; dMQLConnectQL.QLNamQT = data.QLNamQT; dMQLConnectQL.QLNgayHopDong = data.QLNgayHopDong; dMQLConnectQL.QLSoHopDong = data.QLSoHopDong; dMQLConnectQL.QLSoLuongHD = data.QLSoLuongHD; dMQLConnectQL.QLDoanhThu = data.QLDoanhThu; dMQLConnectQL.QLVAT = data.QLVAT; dMQLConnectQL.QLNgayKhoiCong = data.QLNgayKhoiCong; dMQLConnectQL.QLNgayKetThuc = data.QLNgayKetThuc; dMQLConnectQL.QLHopDong = data.QLHopDong; dMQLConnectQL.QLDuToan = data.QLDuToan; dMQLConnectQL.QLQuyetToan = data.QLQuyetToan; dMQLConnectQL.QLKLHoanThanh = data.QLKLHoanThanh; dMQLConnectQL.QLBBNghiemThu = data.QLBBNghiemThu; dMQLConnectQL.QLBBThanhLy = data.QLBBThanhLy; dMQLConnectQL.QLHSChuan = data.QLHSChuan; dMQLConnectQL.QLNhatKy = data.QLNhatKy; dMQLConnectQL.QLYCBoSung = data.QLYCBoSung; dMQLConnectQL.QLNo = data.QLNo; dMQLConnectQL.QLStatus = data.QLStatus; dMQLConnectQL.UserCreate = UserInfo.UserID; dMQLConnectQL.CompanyID = CommonInfo.CompanyInfo.CompanyID; #endregion chuẩn bị dữ liệu cho DMQLConnectQL seq++; dMQLConnectQL.DMQLConnectQLID = GenerateID.DMQLConnectQLID(seq); this.DMQLConnectQLDAO.InsertDMQLConnectQL(dMQLConnectQL); } transaction.Commit(); return(true); } catch (Exception e) { transaction.Rollback(); Console.WriteLine("Update data fail.\r\n" + e.Message); return(false); } } }
public bool SaveWareHouseDetail(List <WareHouseDetail> saveData, string voucherID) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = WareHouseDetailDAO.GetWareHouseDetailSEQ(); foreach (WareHouseDetail data in saveData) { switch (data.Status) { // Add new case ModifyMode.Insert: seq++; data.WareHouseDetailID = GenerateID.WareHouseDetailID(seq); this.WareHouseDetailDAO.InsertWareHouseDetail(data); break; // Update case ModifyMode.Update: this.WareHouseDetailDAO.UpdateWareHouseDetail(data); break; // Delete case ModifyMode.Delete: this.WareHouseDetailDAO.DeleteWareHouseDetail(data.WareHouseDetailID, data.CompanyID); DUTOANCONGTRINHmodel itemDTCTModel = new DUTOANCONGTRINHmodel { DonGiaXuat = 0, SoLuongXuat = 0, ThanhTienXuat = 0, WareHouseDetailID = data.WareHouseDetailID, VouchersID = voucherID, ItemID = data.ItemID, ItemUnitID = data.ItemUnitID }; this.DUTOANCONGTRINHDAO.EditDUTOANCONGTRINH(itemDTCTModel); //update Dự Toán Công Trình break; } } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return(false); } } }
protected void ButtonAddNew_Click(object sender, EventArgs e) { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); try { string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID); string Post_No = GenerateID.Post_No(user_class.CV_CODE); List <dbo_RevenueExpenseClass> item_rev = dbo_RevenueExpenseDataClass.Search(Post_No, null, null, user_class.CV_CODE); if (item_rev.Count == 0) { pnlForm.Visible = true; pnlGrid.Visible = false; Textbox1.Text = "0"; Textbox2.Text = "0"; txtPost_Date.Text = DateTime.Now.ToShortDateString(); txtPost_No.Text = GenerateID.Post_No(user_class.CV_CODE); List <dbo_RevenueExpenseClass> item = dbo_RevenueExpenseDataClass.Search(txtPost_No.Text, null, null, user_class.CV_CODE); List <dbo_RevenueExpenseClass> item_rv = item.Where(f => f.Account_No.Substring(6, 2) == "RV").ToList(); //รายรับ List <dbo_RevenueExpenseClass> item_ep = item.Where(f => f.Account_No.Substring(6, 2) == "EP").ToList(); //รายจ่าย GridViewRevenue.DataSource = item_rv; GridViewRevenue.DataBind(); GridViewExpense.DataSource = item_ep; GridViewExpense.DataBind(); System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); } else { System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("คุณได้ทำการบันทึกรายรับรายจ่ายของวันนี้แล้ว กรุณากลับไปแก้ไขรายการเดิม"); } } catch (Exception ex) { logger.Error(ex.Message); } }
public bool SaveItems(List <Items> saveData, out string itemID) { itemID = string.Empty; using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = this.ItemsDAO.GetItemSEQ(); foreach (Items data in saveData) { switch (data.Status) { // Add new case ModifyMode.Insert: seq++; data.ItemID = GenerateID.ItemID(seq); itemID = data.ItemID; this.ItemsDAO.InsertItems(data); break; // Update case ModifyMode.Update: this.ItemsDAO.UpdateItems(data); itemID = data.ItemID; break; // Delete case ModifyMode.Delete: this.ItemsDAO.DeleteItems(data); break; } } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return(false); } } }
public bool SaveCustommers(List <Customer> customers, out string customerID) { customerID = string.Empty; using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = this.CustomerDAO.GetCustomerSEQ(); foreach (Customer customer in customers) { switch (customer.Status) { // Add new case ModifyMode.Insert: seq++; customerID = GenerateID.CustomerID(seq); customer.CustomerID = GenerateID.CustomerID(seq); this.CustomerDAO.InsertCustomer(customer); break; // Update case ModifyMode.Update: customerID = customer.CustomerID; this.CustomerDAO.UpdateCustomer(customer); break; // Delete case ModifyMode.Delete: this.CustomerDAO.DeleteCustomer(customer); break; } } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return(false); } } }
public bool SaveItemType(List <ItemType> saveData) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = this.ItemsDAO.GetItemTypeSEQ(); foreach (ItemType data in saveData) { switch (data.Status) { // Add new case ModifyMode.Insert: seq++; data.ItemTypeID = GenerateID.ItemTypeID(seq); data.CompanyID = CommonInfo.CompanyInfo.CompanyID; this.ItemTypeDAO.InsertItemType(data); break; // Update case ModifyMode.Update: data.CompanyID = CommonInfo.CompanyInfo.CompanyID; this.ItemTypeDAO.UpdateItemType(data); break; // Delete case ModifyMode.Delete: this.ItemTypeDAO.DeleteItemType(data); break; } } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return(false); } } }
public void AddItem(Item item) { PurchaseDetails purchaseDetails = null; try { purchaseDetails = Purchases.Find(x => x.Item.Id == item.Id); } catch (Exception ex) { Console.WriteLine("error looking for the same item\n"); Logging.log.Error(ex); } if (purchaseDetails != null) { purchaseDetails.PurchaseItem.Quantity += 1; purchaseDetails.PurchaseItem.SubTotal = purchaseDetails.PurchaseItem.Quantity * item.Price; if (PurchaseItemManager.Update(purchaseDetails.PurchaseItem)) { Console.WriteLine("Item Successfully added."); } else { Console.WriteLine("Item not added! Please try again."); } } else { PurchaseItem purchaseItem = new PurchaseItem(GenerateID.GetGeneratedID(), PurchaseId, item.Id, 1, item.Price); if (PurchaseItemManager.Add(purchaseItem)) { Purchases.Add(new PurchaseDetails(purchaseItem, item)); Console.WriteLine("Item successfully added."); } else { Console.WriteLine("Item not added! Please try again."); } } }
public bool SaveVoucherCoverDetail(List <VoucherCoverDetail> saveData) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = this.VoucherCoverDetailDAO.GetVoucherCoverDetailSEQ(); foreach (VoucherCoverDetail data in saveData) { switch (data.Status) { // Add new case ModifyMode.Insert: seq++; data.VoucherCoverDetailID = GenerateID.VoucherCoverDetailID(seq); this.VoucherCoverDetailDAO.InsertVoucherCoverDetail(data); break; // Update case ModifyMode.Update: this.VoucherCoverDetailDAO.UpdateVoucherCoverDetail(data); break; // Delete case ModifyMode.Delete: this.VoucherCoverDetailDAO.DeleteVoucherCoverDetail(data); break; } } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return(false); } } }
//Dùng để thao tác đơn lẻ với S35 public bool SaveS35MenuSanXuat(List <S35MenuSanXuat> saveData) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = S35MenuSanXuatDAO.GetS35MenuSanXuatSEQ(); foreach (S35MenuSanXuat data in saveData) { switch (data.Status) { // Add new case ModifyMode.Insert: seq++; data.S35MenuSXID = GenerateID.S35MenuSXID(seq); this.S35MenuSanXuatDAO.InsertS35MenuSanXuat(data); break; // Update case ModifyMode.Update: // this.S35MenuSanXuatDAO.UpdateS35MenuVoucher(data); // this.S35MenuDAO.UpdateS35Menu(data); break; // Delete case ModifyMode.Delete: this.S35MenuSanXuatDAO.DeleteS35MenuSanXuat(data); //Khi delete S35Menu thì DB sẽ tự delete S35MenuDetail break; } } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return(false); } } }
public bool SaveAccountGroup(List <AccountGroup> saveData) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = this.AccountsDAO.GetAccountGroupSEQ(); foreach (AccountGroup data in saveData) { switch (data.Status) { // Add new case ModifyMode.Insert: seq += 1; data.AccountGroupID = GenerateID.AccountGroupID(seq); this.AccountsDAO.InsertAccountGroup(data); break; // Update case ModifyMode.Update: this.AccountsDAO.UpdateAccountGroup(data); break; // Delete case ModifyMode.Delete: this.AccountsDAO.DeleteAccountGroup(data); break; } } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return(false); } } }
public bool SaveWareHouseList(List <WarehouseList> saveData) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = WareHouseListDAO.GetWareHouseListSEQ(); foreach (WarehouseList data in saveData) { switch (data.Status) { // Add new case ModifyMode.Insert: seq++; data.WarehouseListID = GenerateID.WareHouseListID(seq); this.WareHouseListDAO.InsertWareHouseList(data); break; // Update case ModifyMode.Update: this.WareHouseListDAO.UpdateWareHouseList(data); break; // Delete case ModifyMode.Delete: this.WareHouseListDAO.DeleteWareHouseList(data.WarehouseListID, data.CompanyID); break; } } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return(false); } } }
//Dùng để thao tác đơn lẻ với S35 public bool SaveInvoiceS35(List <InvoiceS35> saveData) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = InvoiceS35DAO.GetInvoiceS35SEQ(); foreach (InvoiceS35 data in saveData) { switch (data.Status) { // Add new case ModifyMode.Insert: seq++; data.InvoiceS35ID = GenerateID.InvoiceS35ID(seq); this.InvoiceS35DAO.InsertInvoiceS35(data); break; // Update case ModifyMode.Update: this.InvoiceS35DAO.UpdateInvoiceS35(data); break; // Delete case ModifyMode.Delete: this.InvoiceS35DAO.DeleteInvoiceS35(data); //Khi delete InvoiceS35 thì DB sẽ tự delete InvoiceS35Detail break; } } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return(false); } } }
public bool SaveProductMenu(List<ProductMenu> saveData, List<ProductMenu> saveDataBase) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = ProductMenuDAO.GetProductMenuSEQ(); foreach (ProductMenu data in saveData) { switch (data.Status) { // Add new case ModifyMode.Insert: seq++; data.ProductMenuID = GenerateID.ProductMenuID(seq); this.ProductMenuDAO.InsertProductMenu(data); break; // Update case ModifyMode.Update: this.ProductMenuDAO.UpdateProductMenu(data); break; // Delete case ModifyMode.Delete: this.ProductMenuDAO.DeleteProductMenu(data); break; } } transaction.Commit(); return true; } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return false; } } }
public bool SaveVoucherDetail(List <VoucherDetail> saveData) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = VoucherDetailDAO.GetVoucherDetailSEQ(); foreach (VoucherDetail data in saveData) { switch (data.Status) { // Add new case ModifyMode.Insert: seq++; data.VouchersDetailID = GenerateID.VoucherDetailID(seq); this.VoucherDetailDAO.InsertVouchersDetail(data); break; // Update case ModifyMode.Update: this.VoucherDetailDAO.UpdateVoucherDetail(data); break; // Delete case ModifyMode.Delete: this.VoucherDetailDAO.DeleteVoucherDetail(data.VouchersDetailID, data.CompanyID); break; } } transaction.Commit(); return(true); } catch (Exception e) { transaction.Rollback(); Console.WriteLine("Update data fail.\r\n" + e.Message); return(false); } } }
public bool SaveLockDB(List <LockDBCompany> saveData) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = LockDBCompanyDAO.GetLockDBCompanySEQ(); foreach (LockDBCompany data in saveData) { switch (data.Status) { // Add new case ModifyMode.Insert: seq++; data.ClockDBID = GenerateID.LockDBID(seq); this.LockDBCompanyDAO.InsertLockDB(data); break; // Update case ModifyMode.Update: this.LockDBCompanyDAO.UpdateLockDB(data); break; // Delete case ModifyMode.Delete: this.LockDBCompanyDAO.DeleteLockDB(data); break; } } transaction.Commit(); return(true); } catch (Exception e) { transaction.Rollback(); Console.WriteLine("Update data fail.\r\n" + e.Message); return(false); } } }
public bool SaveS35MenuSelected(List <S35MenuSelected> saveData) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = S35MenuSelectedDAO.GetS35MenuSelectedSEQ(); foreach (S35MenuSelected data in saveData) { switch (data.Status) { // Add new case ModifyMode.Insert: seq++; data.S35MenuSelectedID = GenerateID.S35MenuSelectedID(seq); this.S35MenuSelectedDAO.InsertS35MenuSelected(data); break; // Update case ModifyMode.Update: this.S35MenuSelectedDAO.UpdateS35MenuSelected(data); break; // Delete case ModifyMode.Delete: this.S35MenuSelectedDAO.DeleteS35MenuSelected(data); break; } } transaction.Commit(); return(true); } catch (Exception e) { transaction.Rollback(); Console.WriteLine("Update data fail.\r\n" + e.Message); return(false); } } }
public bool SaveBalance(List <Balance> saveData) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = BalanceDAO.GetBalanceSEQ(); foreach (Balance data in saveData) { switch (data.Status) { // Add new case ModifyMode.Insert: seq++; data.BalanceID = GenerateID.BalanceID(seq); this.BalanceDAO.InsertBalance(data); break; // Update case ModifyMode.Update: this.BalanceDAO.UpdateBalance(data); break; // Delete case ModifyMode.Delete: this.BalanceDAO.DeleteBalance(data); break; } } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return(false); } } }
//Thêm, xóa, sửa dự toán công trình public bool SaveDUTOANCONGTRINH(List <DUTOANCONGTRINHmodel> saveData) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long seq = DUTOANCONGTRINHDAO.GetDUTOANCONGTRINHSEQ(); foreach (DUTOANCONGTRINHmodel data in saveData) { switch (data.Status) { // Add new case ModifyMode.Insert: seq++; data.DTCTID = GenerateID.DuToanCongTrinhID(seq); this.DUTOANCONGTRINHDAO.InsertDUTOANCONGTRINH(data); break; // Update case ModifyMode.Update: this.DUTOANCONGTRINHDAO.UpdateDUTOANCONGTRINH(data); break; // Delete case ModifyMode.Delete: this.DUTOANCONGTRINHDAO.DeleteDUTOANCONGTRINH(data); break; } } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return(false); } } }
private static int GetID() { int id = GenerateID.GetID(table); SqlConnection sql = new SqlConnection(constr); sql.Open(); String command = "SELECT * FROM " + table + " ;"; SqlCommand sql1 = new SqlCommand(command, sql); SqlDataReader sqlDataReader = sql1.ExecuteReader(); ; int ID = 1; while (sqlDataReader.Read()) { ID = (int)sqlDataReader[0] + 1; } sqlDataReader.Close(); sql.Close(); sql1.Dispose(); return(ID); }
protected void GridViewCycle_RowCommand(object sender, GridViewCommandEventArgs e) { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); if (e.CommandName == "EditCycle") { int RowIndex = Convert.ToInt32((e.CommandArgument).ToString()); List <dbo_OrderAndDeliveryCycleClass> item1 = dbo_OrderAndDeliveryCycleDataClass.SelectAll(); if (item1.Count < GridViewCycle.Rows.Count && RowIndex > int.Parse(ViewState["current_index"].ToString())) { RowIndex--; } current_index = RowIndex; ViewState["current_index"] = current_index; LinkButton currbtn = (LinkButton)GridViewCycle.Rows[RowIndex].FindControl("lnkB_SetOrder_Cycle_Name"); //Label cycle_id = (Label)GridViewCycle.Rows[RowIndex].FindControl("lblOrder_Cycle_ID"); string orderCycleID = item1[RowIndex].Order_Cycle_ID; if (currbtn.Text == "แก้ไขรอบสั่งรอบส่ง") { dbo_OrderAndDeliveryCycleClass cycle = new dbo_OrderAndDeliveryCycleClass() { }; List <dbo_OrderAndDeliveryCycleClass> item = dbo_OrderAndDeliveryCycleDataClass.SelectAll(); item.Insert(RowIndex + 1, new dbo_OrderAndDeliveryCycleClass() { }); GridViewCycle.DataSource = item; GridViewCycle.DataBind(); currbtn = (LinkButton)GridViewCycle.Rows[RowIndex].FindControl("lnkB_SetOrder_Cycle_Name"); currbtn.Text = "ปิด"; //List<dbo_OrderAndDeliveryCycleValueClass> item_value = dbo_OrderAndDeliveryCycleValueDataClass.Search(cycle_id.Text); List <dbo_OrderAndDeliveryCycleValueClass> item_value = dbo_OrderAndDeliveryCycleValueDataClass.Search(orderCycleID); GridView gv = (GridView)GridViewCycle.Rows[RowIndex + 1].FindControl("grdNewValue"); Button newbutton1 = (Button)GridViewCycle.Rows[RowIndex + 1].FindControl("btnNewValue"); LinkButton Cycle_Name = (LinkButton)GridViewCycle.Rows[RowIndex + 1].FindControl("lnkB_SetOrder_Cycle_Name"); gv.DataSource = item_value; gv.DataBind(); gv.Visible = true; newbutton1.Visible = true; Cycle_Name.Visible = false; GridViewCycle.Rows[RowIndex + 1].Cells[2].ColumnSpan = 5; GridViewCycle.Rows[RowIndex + 1].Cells[0].Visible = false; GridViewCycle.Rows[RowIndex + 1].Cells[1].Visible = false; GridViewCycle.Rows[RowIndex + 1].Cells[3].Visible = false; GridViewCycle.Rows[RowIndex + 1].Cells[4].Visible = false; GridViewCycle.Rows[RowIndex + 1].Cells[5].Visible = false; Label currlbl = (Label)GridViewCycle.Rows[RowIndex + 1].FindControl("lblOrder"); currlbl.Visible = false; // currbtn.Visible = true; for (int i = RowIndex + 1; i < GridViewCycle.Rows.Count; i++) { Label lbl_Amount = (Label)GridViewCycle.Rows[i].FindControl("lblOrder"); lbl_Amount.Text = i.ToString(); } } else { List <dbo_OrderAndDeliveryCycleClass> item = dbo_OrderAndDeliveryCycleDataClass.SelectAll(); GridViewCycle.DataSource = item.OrderBy(f => f.Order_Cycle_ID);; GridViewCycle.DataBind(); } } else if (e.CommandName == "AddNew") { string _Order_Cycle_ID = GenerateID.Order_Cycle_ID(); TextBox _Order_Cycle_Name = (TextBox)GridViewCycle.FooterRow.FindControl("txtNewOrder_Cycle_Name"); if (_Order_Cycle_Name.Text.Trim() != string.Empty) { dbo_OrderAndDeliveryCycleClass cycle = new dbo_OrderAndDeliveryCycleClass() { Order_Cycle_ID = _Order_Cycle_ID, Order_Cycle_Name = _Order_Cycle_Name.Text }; bool success = false; string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; success = dbo_OrderAndDeliveryCycleDataClass.Add(cycle, User_ID); if (success) { //string script = @"swal(""บันทึกสำเร็จ!"", """", ""success"")"; //ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", script, true); // Show("บันทึกสำเร็จ"); GridViewCycle.ShowFooter = false; List <dbo_OrderAndDeliveryCycleClass> item = dbo_OrderAndDeliveryCycleDataClass.SelectAll(); GridViewCycle.DataSource = item.OrderBy(f => f.Order_Cycle_ID);; GridViewCycle.DataBind(); } System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); } else { System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("กรุณากรอกข้อมูลที่จำเป็นให้ครบถ้วน"); } } }
//S35MenuFinal //S35MenuFinalEx //S35MenuFinalWH public bool SaveS35MenuFinalFull(List <S35MenuFinalEx> dataList, List <S35MenuFinal> detailListData, List <S35MenuFinalWH> finalWHData) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { foreach (S35MenuFinalEx data in dataList) { List <S35MenuFinal> detailData = detailListData.Where(o => o.S35MenuFinalExID == data.S35MenuFinalExID).ToList(); long seq = S35MenuFinalExDAO.GetS35MenuFinalExSEQ(); long seqdetail = S35MenuFinalDAO.GetS35MenuFinalSEQ(); switch (data.Status) { // Thêm warehouse mới thì sẽ thực hiện thêm Detail mới nếu ListDetail có giá trị case ModifyMode.Insert: seq++; data.S35MenuFinalExID = GenerateID.S35MenuFinalExID(seq); this.S35MenuFinalExDAO.InsertS35MenuFinalEx(data); if (detailData.Count > 0) { //thêm S35MenuFinal #region insert S35MenuFinal foreach (S35MenuFinal s35MenuFinal in detailData) { if (s35MenuFinal.Status == ModifyMode.Insert) { seqdetail++; s35MenuFinal.S35MenuFinalID = GenerateID.S35MenuFinalID(seqdetail); s35MenuFinal.S35MenuFinalExID = data.S35MenuFinalExID; this.S35MenuFinalDAO.InsertS35MenuFinal(s35MenuFinal); } } #endregion insert S35MenuFinal } break; // Delete case ModifyMode.Delete: this.S35MenuFinalExDAO.DeleteS35MenuFinalEx(data); //Khi delete warehouse thì DB sẽ tự delete warehouse break; } } //Them Final Warehouse foreach (S35MenuFinalWH s35MenuFinalWH in finalWHData) { long seq = S35MenuFinalWHDAO.GetS35MenuFinalWHSEQ(); switch (s35MenuFinalWH.Status) { case ModifyMode.Insert: seq++; s35MenuFinalWH.S35MenuFinalWHID = GenerateID.S35MenuFinalWHID(seq); this.S35MenuFinalWHDAO.InsertS35MenuFinalWH(s35MenuFinalWH); break; } } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return(false); } } }
} //Không có ID riêng public bool SaveS35MenuDetailSanXuatFinal(ThanhPhamKey thanhpham, List <S35MenuDetailSanXuatFinal> s35menudetailsx, List <S35MenuSanXuatWH> nguyenlieu, List <ItemDetailS35MenuSX> congthucsd, List <S35MenuSanXuat> s35menusx) { using (DbContextTransaction transaction = Context.Database.BeginTransaction()) { try { long tpseq = ThanhPhamKeyDAO.ThanhPhamSEQ(); tpseq++; thanhpham.TPID = GenerateID.ThanhPhamID(tpseq); ThanhPhamKeyDAO.InsertThanhPhamKey(thanhpham); //Insert truy vết MenuSanXuat foreach (S35MenuSanXuat s35MenuSanXuat in s35menusx) { S35MenuSXConnectDT tempData = new S35MenuSXConnectDT { TPID = thanhpham.TPID, S35MenuSXID = s35MenuSanXuat.S35MenuSXID, CompanyID = CommonInfo.CompanyInfo.CompanyID, CreateUser = UserInfo.UserID }; S35MenuSXConnectDTDAO.InsertS35MenuSXConnectDT(tempData); } long s35menudetailsxseq = S35MenuDetailSanXuatFinalDAO.S35MenuDetailSanXuatFinalSEQ(); long nguyenlieuseq = S35MenuSanXuatWHDAO.S35MenuSanXuatWHSEQ(); long congthucsdseq = ItemDetailS35MenuSXDAO.ItemDetailMenuSEQ(); //insert danh sách thành phẩm foreach (S35MenuDetailSanXuatFinal s35MenuDetailSanXuatFinal in s35menudetailsx) { //Chạy từng món switch (s35MenuDetailSanXuatFinal.Status) { // Thêm S35 mới thì sẽ thực hiện thêm Detail mới nếu ListDetail có giá trị case ModifyMode.Insert: s35menudetailsxseq++; s35MenuDetailSanXuatFinal.S35MenuDetailSXFNID = GenerateID.S35MenuDetailSXFNID(s35menudetailsxseq); s35MenuDetailSanXuatFinal.TPID = thanhpham.TPID; this.S35MenuDetailSanXuatFinalDAO.InsertS35MenuDetailSanXuatFinal(s35MenuDetailSanXuatFinal); s35MenuDetailSanXuatFinal.Status = ModifyMode.None; //Sau khi insert S35MenuDetailSanXuatFinal thành công thì insert danh sách nguyên liệu, lưu lại loại công thức, Lưu vết truy xuất liên quan menu List <ItemDetailS35MenuSX> nguyenlieuListmenu = congthucsd.Where(o => o.ItemID == s35MenuDetailSanXuatFinal.ItemID).ToList(); //Insert công thức liên quan của 1 món foreach (ItemDetailS35MenuSX itemDetailS35MenuSX in nguyenlieuListmenu) { congthucsdseq++; itemDetailS35MenuSX.ItemDetailS35MenuSXID = GenerateID.ItemDetailMenuID(congthucsdseq); itemDetailS35MenuSX.S35MenuDetailSXFNID = s35MenuDetailSanXuatFinal.S35MenuDetailSXFNID; ItemDetailS35MenuSXDAO.InsertItemDetailS35MenuSX(itemDetailS35MenuSX); } break; } } //Insert nguyên liệu foreach (S35MenuSanXuatWH nguyenlieuItem in nguyenlieu) { //Chạy từng món switch (nguyenlieuItem.Status) { // Thêm S35 mới thì sẽ thực hiện thêm Detail mới nếu ListDetail có giá trị case ModifyMode.Insert: nguyenlieuseq++; nguyenlieuItem.S35MenuSanXuatWHID = GenerateID.S35MenuSXWHID(nguyenlieuseq); nguyenlieuItem.TPID = thanhpham.TPID; this.S35MenuSanXuatWHDAO.InsertS35MenuSanXuatWH(nguyenlieuItem); nguyenlieuItem.Status = ModifyMode.None; break; } } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); BSLog.Logger.Error(ex.Message); return(false); } } }
static void Main(string[] args) { IView customerList = new CustomerListView(); IView customerView = null; while (customerView == null) { customerList.Show(); Console.WriteLine("\nAre you a new customer?\nPress 1 if yes, otherwise press 2."); int response = Console.ReadLine().ToInt(-1); Console.Clear(); if (response == 1) { Customer customer = new Customer(); customer.Id = GenerateID.GetGeneratedID(); Console.WriteLine("Enter your first name:"); customer.FirstName = Console.ReadLine(); Console.WriteLine("Enter your Middle name:"); customer.MiddleName = Console.ReadLine(); Console.WriteLine("Enter your Last name:"); customer.LastName = Console.ReadLine(); Console.WriteLine("Enter your gender 'M' - Male, 'F' - Female:"); customer.Gender = Console.ReadLine(); Console.WriteLine("Enter your contact no."); customer.ContactNo = Console.ReadLine(); Console.WriteLine("Enter your email address:"); customer.Email = Console.ReadLine(); Console.WriteLine("Enter your current address"); customer.Address = Console.ReadLine(); customerView = new CustomerView(customer); if (((CustomerView)customerView).CustomerManager.Add(customer)) { Console.WriteLine("Member succesfully added! See details below."); customerView.Show(); } else { Console.WriteLine("Member can't be added."); customerView = null; } } else if (response == 2) { Console.WriteLine("Enter your Id."); Customer customer = ((CustomerListView)customerList).Manager.GetById(Console.ReadLine().ToInt(-1), "Id"); if (customer == null) { Console.WriteLine($"Entered Id can't be found!"); } else { customerView = new CustomerView(customer); } } else { Console.WriteLine("Response not recognize. Please try again."); } } while (true) { Console.WriteLine($"\nHello {((CustomerView)customerView).Customer.Info.FirstName}! What would you like to do?"); Console.WriteLine("Press 1 to show your order history. Press 2 to shop! Press 3 to exit.\n"); int response = Console.ReadLine().ToInt(-1); Console.Clear(); if (response == 1) { customerView.Show(); } else if (response == 2) { IView cartView = null; bool doneShopping = false; PurchaseHistory purchaseHistory = ((CustomerView)customerView).Customer.PurchaseHistory.Find(x => x.Purchase.Status == "Pending"); Purchase purchase; if (purchaseHistory == null) { purchase = new Purchase(GenerateID.GetGeneratedID(), ((CustomerView)customerView).Customer.Info.Id, "Pending", DateTime.Now.ToString(), 0); if (((CustomerView)customerView).PurchaseManager.Add(purchase)) { Console.WriteLine("New purchase. Add items to your cart."); ((CustomerView)customerView).Customer.PurchaseHistory.Add(new PurchaseHistory(purchase)); cartView = new CartView(new List <PurchaseDetails>(), purchase.Id); } else { Console.WriteLine("Can't create new purchase. Please try again."); doneShopping = true; } } else { purchase = purchaseHistory.Purchase; Console.WriteLine("You have a pending purchase. Restoring."); cartView = new CartView(purchaseHistory.PurchaseDetails, purchaseHistory.Purchase.Id); } IView groceriesView = new GroceriesView(); while (!doneShopping) { Console.WriteLine("Press 1 to add an item, 2 to change the quantity of an item, " + "3 to show your cart, and 4 to check out, 5 to exit.\n"); groceriesView.Show(); Console.WriteLine(); int input; input = Console.ReadLine().ToInt(0); Actions action = (Actions)input; Console.Clear(); switch (action) { case Actions.ADD_ITEM: { Console.WriteLine("Enter the barcode of an item"); Item item = ((GroceriesView)groceriesView).Manager.GetById(Console.ReadLine().ToInt(-1), "Id"); if (item == null) { Console.WriteLine("Item can't be found."); } else { ((CartView)cartView).AddItem(item); } break; } case Actions.CHANGE_QUANTITY: { Console.WriteLine("Enter the barcode of an item to change quantity."); int id = Console.ReadLine().ToInt(-1); Item item = null; try { item = ((CartView)cartView).Purchases.Find(x => x.PurchaseItem.ItemId == id).Item; } catch (Exception ex) { Logging.log.Error(ex); } if (item != null) { Console.WriteLine("Enter the new quantity of the item"); int quantity = Console.ReadLine().ToInt(-1); if (quantity == -1) { Console.WriteLine("Can't change quantity for that value"); } else { ((CartView)cartView).ChangeQuantity(item, quantity); } } else { Console.WriteLine("Entered item can't be found!"); } break; } case Actions.SHOW_CART: { cartView.Show(); break; } case Actions.CHECK_OUT: { using (TransactionScope scope = new TransactionScope()) { float total = ((CartView)cartView).ComputeTotalPrice(); purchase.Status = "Purchased"; purchase.Date = DateTime.Now.ToString(); purchase.Total = total; if (((CustomerView)customerView).PurchaseManager.Update(purchase)) { Console.WriteLine("Thank you. Please come again."); doneShopping = true; } else { Console.WriteLine("Can't proceed to check out. Please try again."); break; } scope.Complete(); } break; } case Actions.EXIT: { doneShopping = true; break; } default: { Console.WriteLine("Action not recognize. Try again."); break; } } } } else if (response == 3) { break; } else { Console.WriteLine("Response not recognize. Please try again."); } } }