public int InsertTables(TablesModel TablesModel) { int result = 0; using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { TablesModel.Status = (TablesModel.Status == 0) ? null : TablesModel.Status; CommonRepository commonRepository = new CommonRepository(_ConnectionString); int MaxId = commonRepository.GetMaxId("Tables"); con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var query = "INSERT INTO Tables (Id,TableName,OutletId,PersonCapacity,TableIcon,Status,IsActive)" + "VALUES ( " + MaxId + ",@TableName,@OutletId,@PersonCapacity,@TableIcon,@Status,@IsActive);" + " SELECT CAST(SCOPE_IDENTITY() as INT);"; result = con.Execute(query, TablesModel, sqltrans, 0, System.Data.CommandType.Text); if (result > 0) { sqltrans.Commit(); string output = commonRepository.SyncTableStatus("Tables"); } else { sqltrans.Rollback(); } } return(result); }
protected void FillTablesTree() { var query = from n in DataContext.LP_Tables where n.DateDeleted == null select n; if (!String.IsNullOrWhiteSpace(tbxKeyword.Text)) { query = from n in query where n.Name.Contains(tbxKeyword.Text.Trim()) select n; } var entities = query.OrderByDescending(n => n.DateCreated).ToList(); var converter = new TableEntityModelConverter(DataContext); var models = (from n in entities let m = converter.Convert(n) select m); var model = new TablesModel(); model.List = models.ToList(); tablesControl.Model = model; }
public int UpdateTables(TablesModel TablesModel) { int result = 0; using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { CommonRepository commonRepository = new CommonRepository(_ConnectionString); con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var query = "UPDATE Tables SET TableName=@TableName,OutletId=@OutletId," + "PersonCapacity=@PersonCapacity,TableIcon=@TableIcon,Status=@Status,IsActive=@IsActive " + "WHERE Id = @Id;"; result = con.Execute(query, TablesModel, sqltrans, 0, System.Data.CommandType.Text); if (result > 0) { sqltrans.Commit(); string output = commonRepository.SyncTableStatus("Tables"); } else { sqltrans.Rollback(); } } return(result); }
public IActionResult Tables() { TablesModel model = new TablesModel(); model.TablesList = SQLiteUtility.GetTables(connectionString); return(View(model)); }
public ActionResult Tables(TablesModel tableModel, string submitButton) { tableModel.OutletList = _iDropDownService.GetOutletList(); if (!ModelState.IsValid) { string errorString = this.ValidationTables(tableModel); if (!string.IsNullOrEmpty(errorString)) { ViewBag.Validate = errorString; return(View(tableModel)); } } if (tableModel.Id > 0) { var result = _iTablesService.UpdateTables(tableModel); ViewBag.Result = _locService.GetLocalizedHtmlString("EditSuccss"); } else { var result = _iTablesService.InsertTables(tableModel); ViewBag.Result = _locService.GetLocalizedHtmlString("SaveSuccess"); } return(RedirectToAction("Index", "Tables")); }
public TableModel ExcelTableLoader(string ExcelPath, string TableName) { TableModel LoadedTable = new TableModel(); MemoryStream inMemoryCopy = new MemoryStream(); try { using (FileStream fs = File.OpenRead(ExcelPath)) { fs.CopyTo(inMemoryCopy); } TablesModel Tables = new TablesModel(); ExcelPackage excelPackage = new ExcelPackage(inMemoryCopy); var package = excelPackage; Tables = Parse(package, false); LoadedTable = FetchTableByName(Tables, TableName); var count = LoadedTable.Body.Count; Debug.WriteLine("Row Count: " + count); } catch (Exception ex) { Debug.WriteLine(ex.Message); return(null); } return(LoadedTable); }
private void lvModels_SelectionChanged(object sender, SelectionChangedEventArgs e) { TablesModel test = (TablesModel)((ListView)sender).SelectedItem; // gvData.DataContext = sender; gvData.DataContext = test; }
public static void exmpl03() { //Явная загрузка db.Database.Log = Console.Write; TablesModel model = db.TablesModel.Find(1); db.Entry(model).Collection(c => c.TablesSNPrefix).Load(); }
static void Main(string[] args) { MCSEntities1 db = new MCSEntities1(); db.Database.Log = Console.Write; #region //Явная загрузка TablesModel model = db.TablesModels.Find(1); foreach (var source in db.TablesSNPrefixes.Where(w => w.intModelID == model.intModelID)) { model.TablesSNPrefixes.Add(source); } //db.Entry(model) // .Collection(c => c.TablesSNPrefixes) // .Load(); #endregion return; #region //Отложенная(ленивая) загрузка foreach (var tablesModel in db.TablesModels.Take(5)) { Console.WriteLine(tablesModel.strName); foreach (var tablesSnPrefix in tablesModel.TablesSNPrefixes) { Console.WriteLine(" - " + tablesSnPrefix.strPrefix); } } #endregion return; #region//Прямая загрузка List <newEquipment> qeuipments = db.newEquipments .Include(d => d.TablesLocation) .Include(d => d.TablesModel) .Include(d => d.TablesModel.TablesSNPrefixes) .ToList(); Console.WriteLine("--------------------------------------------------------------"); foreach (var newEquipment in qeuipments) { Console.WriteLine(newEquipment.intGarageRoom); foreach (var pref in newEquipment.TablesModel.TablesSNPrefixes) { Console.WriteLine("-> " + pref.strPrefix); } } Console.WriteLine("--------------------------------------------------------------"); #endregion }
//添加餐桌 private void btnAddMeal_Click(object sender, EventArgs e) { TablesModel tables = new TablesModel(); tables.RTID1 = -1; TheTableEditorForm tableEditor = new TheTableEditorForm(tables); tableEditor.Show(); }
public static TableModel FetchTableByName(TablesModel Tables, string tableName) { foreach (var table in Tables.Tables) { if (table.Name == tableName) { return(table); } } return(null); }
//修改餐桌 private void btnUpdateMeal_Click(object sender, EventArgs e) { int index = Convert.ToInt32(dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[0].Value); string name = dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[1].Value.ToString(); string area = dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[3].Value.ToString(); int start = 0; TablesModel tables = new TablesModel(index, name, 0, area, start); TheTableEditorForm tableEditor = new TheTableEditorForm(tables); tableEditor.Show(); }
public ActionResult tables() { List <PeopleModel> peopleList = peopleCollection.AsQueryable <PeopleModel>().ToList(); List <OrdersModel> ordersList = ordersCollection.AsQueryable <OrdersModel>().ToList(); TablesModel tdata = new TablesModel(); tdata.tPeopleList = peopleList; tdata.tOrdersList = ordersList; return(View(tdata)); }
private void 顾客开单ToolStripMenuItem_Click(object sender, EventArgs e) { DataTable dt = RommBLL.getTableMeal(name); if (dt.Rows[0]["餐台状态"].ToString() == "可用") { TablesModel tables = new TablesModel(); tables.TableName1 = name; tables.TableID1 = id; BillingForm bf = new BillingForm(tables, 6); bf.Show(); } }
private void btnCreate_Click(object sender, RoutedEventArgs e) { TablesModel tmodel = new TablesModel(); tmodel.strName = strName.Text; tmodel.intManufacturerID = Int32.Parse(intManufacturerID.Text); tmodel.intSMCSFamilyID = Int32.Parse(intSMCSFamilyID.Text); tmodel.strImage = strImage.Text; db.TablesModel.Add(tmodel); db.SaveChanges(); lvManuf.ItemsSource = db.TablesModel.ToList(); }
private void BillingForm_Load(object sender, EventArgs e) { //标题 this.Text = "顾客开单"; TablesModel tables2 = new TablesModel(); tables2.TableName1 = tables.TableName1; DataTable dt = RommBLL.getTableKD(tables2); lblType.Text = tables.TableName1; lblRoomType.Text = dt.Rows[0]["RTName"].ToString(); lblMinMoney.Text = dt.Rows[0]["RTConsume"].ToString(); }
private void lvManuf_SelectionChanged(object sender, SelectionChangedEventArgs e) { TablesModel tmodel = (TablesModel)lvManuf.SelectedItem; if (tmodel != null) { intModelID.Text = tmodel.intModelID.ToString(); strName.Text = tmodel.strName; intManufacturerID.Text = tmodel.intManufacturerID.ToString(); intSMCSFamilyID.Text = tmodel.intSMCSFamilyID.ToString(); strImage.Text = tmodel.strImage; } }
void lv_DoubleClick(object sender, EventArgs e) { ListView listV = sender as ListView; string name = listV.SelectedItems[0].Tag.ToString(); DataTable dt = RommBLL.getTableMeal(name); if (dt.Rows[0]["餐台状态"].ToString() == "可用") { TablesModel tables = new TablesModel(); tables.TableName1 = name; tables.TableID1 = id; BillingForm bf = new BillingForm(tables, 6); bf.Show(); } }
private void btnDelete_Click(object sender, RoutedEventArgs e) { TablesModel tmodel = (TablesModel)lvManuf.SelectedItem; if (tmodel != null) { db.TablesModel.Remove(tmodel); db.SaveChanges(); lvManuf.ItemsSource = db.TablesModel.ToList(); } else { MessageBox.Show("Please select the item you want to delete"); } }
static void Main(string[] args) { db.Database.Log = Console.Write; //Явная загрузка TablesModel model = db.TablesModel.Find(1); db.Entry(model).Collection(c => c.TablesSNPrefix).Load(); return; //Lazy load foreach (var tablesModel in db.TablesModel.Take(5)) { Console.WriteLine(tablesModel.strName); foreach (var tablesSnPrefix in tablesModel.TablesSNPrefix) { Console.WriteLine(" -" + tablesSnPrefix.strPrefix); } } return; //Прямая загрузка List <newEquipment> equipList = db.newEquipment //.Include(d => d.TablesLocation) //.Include(d => d.TablesModel) //.Include(d => d.TablesModel.TablesSNPrefix) .ToList(); Console.WriteLine("------------------------------------------------"); foreach (var newEquipment in equipList) { Console.WriteLine(newEquipment.intGarageRoom); foreach (var pref in newEquipment.TablesModel.TablesSNPrefix) { //Console.WriteLine("->" + pref.strPrefix); } } Console.WriteLine("--------------------------------------------------"); }
//删除餐桌 private void btnDeleteMeal_Click(object sender, EventArgs e) { int index = Convert.ToInt32(dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[0].Value); TablesModel tables = new TablesModel(); tables.TableID1 = index; int result = RommBLL.getDeleteMeal(tables); if (result > 0) { MessageBox.Show("OK"); } else { MessageBox.Show("NO"); } }
private string ValidationTables(TablesModel tablesModel) { string ErrorString = string.Empty; if (string.IsNullOrEmpty(tablesModel.TableName)) { ErrorString = _locService.GetLocalizedHtmlString("ValidAddOnesName"); return(ErrorString); } //if (string.IsNullOrEmpty(tablesModel.Price.ToString()) || tablesModel.Price == 0) //{ // ErrorString = _locService.GetLocalizedHtmlString("ValidPrice"); // return ErrorString; //} return(ErrorString); }
//增加消费 private void Insert_Click(object sender, EventArgs e) { TablesModel tables = new TablesModel(); tables.TableID1 = id; tables.TableName1 = name; //查询出当前餐桌得编号 ConsumerBillModel cbm = new ConsumerBillModel(); cbm.TableID1 = id; cbm.CBClose1 = 0; DataTable dt = ConsumerBillBLL.getNo(cbm); cbm.CBID1 = dt.Rows[0]["账单编号"].ToString(); AddForm af = new AddForm(tables, cbm); af.Show(); }
//结账 private void 宾客结账ToolStripMenuItem_Click(object sender, EventArgs e) { TablesModel tables = new TablesModel(); tables.TableID1 = id; tables.TableName1 = name; //查询出当前餐桌得编号 ConsumerBillModel cbm = new ConsumerBillModel(); cbm.TableID1 = id; cbm.CBClose1 = 0; DataTable dt = ConsumerBillBLL.getNo(cbm); cbm.CBID1 = dt.Rows[0]["账单编号"].ToString(); AccountsForm1 af = new AccountsForm1(cbm, tables); af.Show(); }
public ActionResult Tables(int?id) { TablesModel tableModel = new TablesModel(); if (UserRolePermissionForPage.Add == true || UserRolePermissionForPage.Edit == true) { if (id > 0) { int tableId = Convert.ToInt32(id); tableModel = _iTablesService.GetTablesById(tableId); } tableModel.OutletList = _iDropDownService.GetOutletList(); return(View(tableModel)); } else { return(RedirectToAction("NotFound", "Error")); } }
public RowsModel ExcelTableLoader(string ExcelPath, string TableName, bool RowModelFlag) { RowsModel LoadedRowTable = new RowsModel(); MemoryStream inMemoryCopy = new MemoryStream(); try { using (FileStream fs = File.OpenRead(ExcelPath)) { fs.CopyTo(inMemoryCopy); } TablesModel Tables = new TablesModel(); ExcelPackage excelPackage = new ExcelPackage(inMemoryCopy); var package = excelPackage; Tables = Parse(package, false); var Result = FetchTableByName(Tables, TableName); RowsModel rowsModel = new RowsModel(); foreach (var row in Result.Body) { RowsModel.RowModel row2 = new RowsModel.RowModel(); int cell2 = 0; foreach (var cell in row.Cells) { row2.Cells[cell2].Value = cell.Value; cell2 += 1; } rowsModel.Rows.Add(row2); } LoadedRowTable = rowsModel; var count = LoadedRowTable.Rows.Count; Debug.WriteLine("Row Count: " + count); } catch (Exception ex) { Debug.WriteLine(ex.Message); return(null); } return(LoadedRowTable); }
/*DB Crawler */ public ActionResult ListTables() { var metadata = ((IObjectContextAdapter)db).ObjectContext.MetadataWorkspace; var tables = metadata.GetItemCollection(DataSpace.SSpace) .GetItems <EntityContainer>() .Single() .BaseEntitySets .OfType <EntitySet>() .Where(s => !s.MetadataProperties.Contains("Type") || s.MetadataProperties["Type"].ToString() == "Tables"); TablesModel tableModel = new TablesModel(); List <TablesModel> tableModels = new List <TablesModel>(); foreach (var t in tables) { tableModel.TableName = t.Name; tableModels.Add(tableModel); } return(View("TablesList", tableModels)); }
private void btnOK_Click(object sender, EventArgs e) { if (tables.RTID1 == -1) { //增加 string name = txtName.Text.Trim(); int type = cmdType.SelectedIndex + 1; string area = txtAdrees.Text.Trim(); int start = 0; TablesModel tables2 = new TablesModel(name, type, area, start); int result = RommBLL.getAddMeal(tables2); if (result > 0) { MessageBox.Show("OK"); } else { MessageBox.Show("NO"); } } else { //修改 string name = txtName.Text.Trim(); int type = cmdType.SelectedIndex + 1; string area = txtAdrees.Text.Trim(); int start = 0; TablesModel tables2 = new TablesModel(tables.TableID1, name, type, area, start); int result = RommBLL.getUpdateMeal(tables2); if (result > 0) { MessageBox.Show("OK"); } else { MessageBox.Show("NO"); } } }
private void brnOK_Click(object sender, EventArgs e) { TablesModel tables2 = new TablesModel(); tables2.TableName1 = tables.TableName1; tables2.TableState1 = 1; int result = RommBLL.getUpdateZT(tables2); string count = txtCount.Text.Trim(); if (result > 0) { MessageBox.Show("OK"); if (cb.Checked) { string no = "ZD" + DateTime.Now.ToString("yyyyMMddhhmm"); string time = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); ConsumerBillModel cbm = new ConsumerBillModel(no, tables.TableID1, count, "-1", "1", time, "", admin, Convert.ToDouble("0"), 0); ConsumerBillBLL.getInsert(cbm); AddForm af = new AddForm(tables, cbm); af.Show(); } else { string no = "ZD" + DateTime.Now.ToString("yyyyMMddhhmm"); string time = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); ConsumerBillModel cbm = new ConsumerBillModel(no, tables.TableID1, count, "-1", "1", time, "", admin, Convert.ToDouble("0"), 0); ConsumerBillBLL.getInsert(cbm); } FunctionForm ff = new FunctionForm(); ff.FunctionForm_Load(null, null); this.Close(); } else { MessageBox.Show("NO"); } }
private void btnUpdate_Click(object sender, RoutedEventArgs e) { if (lvManuf.SelectedIndex >= 0) { TablesModel tmodel = (TablesModel)lvManuf.SelectedItem; foreach (var item in db.TablesModel) { if (item.intManufacturerID == tmodel.intManufacturerID) { item.intManufacturerID = Int32.Parse(intManufacturerID.Text); item.strName = strName.Text; item.intSMCSFamilyID = Int32.Parse(intSMCSFamilyID.Text); item.strImage = strImage.Text; break; } } db.SaveChanges(); lvManuf.ItemsSource = db.TablesModel.ToList(); } else { MessageBox.Show("Please select the item you want to update"); } }