public JsonResult Register(WebService.Contact contact, string seria, string note, string reseller, string capcha) { string _msg = ""; //contact.District = ""; //contact.Province=""; contact.StoreId = StoreID.ToString(); seria = seria.Replace(" ", string.Empty).Trim(); contact.IdCard = contact.IdCard.Replace(" ", string.Empty).Trim(); string rs = service.RegisterSeria(contact, seria, reseller, note, capcha, StoreID, TokenKey, out _msg); return(Json(new { code = rs, msg = _msg })); }
public void SQLStore(SqlConnection conn) { DataTable StoreData = new DataTable(); SqlCommand SelectStore = new SqlCommand("Select * From Store Where StoreNumber = @Store and RegisterCount = @Registers", conn); SelectStore.Parameters.AddWithValue("@Store", Workgroup); SelectStore.Parameters.AddWithValue("@Registers", RegisterCount); try { conn.Open(); SqlDataAdapter da = new SqlDataAdapter(SelectStore); da.Fill(StoreData); conn.Close(); if (StoreData.Rows.Count != 0) { StoreID = Convert.ToInt32(StoreData.Rows[0][0]); } else { SqlCommand AddStore = new SqlCommand("Insert Into Store (StoreNumber,RegisterCount) Values (@Store,@Registers)", conn); AddStore.Parameters.AddWithValue("@Store", Workgroup); AddStore.Parameters.AddWithValue("@Registers", RegisterCount); conn.Open(); AddStore.ExecuteNonQuery(); SqlDataAdapter ad = new SqlDataAdapter(SelectStore); ad.Fill(StoreData); ad.Dispose(); conn.Close(); StoreID = Convert.ToInt32(StoreData.Rows[0][0]); MessageBox.Show("added store " + StoreID.ToString()); } da.Dispose(); } catch (Exception e) { MessageBox.Show(e.ToString()); } }
public PartialViewResult LoadParentCategory(string[] StoreID, string ProductTypeID) { List <SBInventoryBaseCateGroupViewModel> lstData = new List <SBInventoryBaseCateGroupViewModel>(); if (StoreID == null) { StoreID = new string[] { }; } List <string> lstStoreId = StoreID.Where(w => !string.IsNullOrEmpty(w)).ToList(); if (lstStoreId != null && lstStoreId.Any()) { lstData = _factory.GetListCategorySortParent(lstStoreId, null, ProductTypeID, CurrentUser.ListOrganizationId); } SBInventoryBaseModel model = new SBInventoryBaseModel(); model.lstCateGroup = lstData; return(PartialView("_DDLParentCategory", model)); }
public string GetKey() { return(StoreID.ToString() + Year.ToString()); }
public bool Save(ModelStateDictionary modelState, int userID, int employeeID) { if (!Validate(modelState)) { return(Result = false); } QueryOutput queryResult; var query = ""; var action = ""; var id = ID.ToString(); if (!StartDate.HasValue) { StartDate = DateTime.Now; } if (ID > 0) { query += String.Format( @"update Employee set Name = N'{0}', Address = N'{1}', Phone = N'{2}', Position = N'{3}', Image = N'{4}', BussinessID = {5}, StoreID = {6}, StartDate = {7}, WorkTime = N'{8}', MonthlySale = {9}, BaseSalary = {10}, AdditionalSalary = {11}, WorkDays = {12}, OffDays = {13}, Summary = N'{14}', EndDate = {16}, BankNumber = N'{17}', BankName = N'{18}', BankBranch = N'{19}', WorkStatus = N'{20}', DOB = {21} where ID = {15}", new object[] { Name, Address, Phone, Position, Image, BussinessID, StoreID.DbValue(), StartDate.DbValue(Constants.DatabaseDateString), WorkTime, MonthlySale, BaseSalary, AdditionalSalary, WorkDays, OffDays, Summary, ID, EndDate.DbValue(Constants.DatabaseDateString), BankNumber, BankName, BankBranch, WorkStatus, DOB.DbValue(Constants.DatabaseDateString) }); if (LoginID > 0) { query += String.Format(" update Login set EmployeeID = {0} where ID = {1}", ID, LoginID); } else { query += String.Format(" update Login set EmployeeID = null where EmployeeID = {0}", ID); } action = DbAction.Employee.Modify; } else { query += String.Format(@"declare @ID table (ID int) insert Employee(Name, Address, Phone, BussinessID, StoreID, Position, Image, StartDate, WorkTime, MonthlySale, BaseSalary, AdditionalSalary, WorkDays, OffDays, Summary, Status, EndDate, BankNumber, BankName, BankBranch, WorkStatus, DOB) output inserted.ID into @ID values (N'{0}', N'{1}', N'{2}', {3}, {4}, N'{5}', N'{6}', {7}, N'{8}', {9}, {10}, {11}, {12}, {13}, N'{14}', 'active', {15}, N'{16}', N'{17}', N'{18}', N'{19}', {20})", new object[] { Name, Address, Phone, BussinessID, StoreID.DbValue(), Position, Image, StartDate.DbValue(Constants.DatabaseDateString), WorkTime, MonthlySale, BaseSalary, AdditionalSalary, WorkDays, OffDays, Summary, EndDate.DbValue(Constants.DatabaseDateString), BankNumber, BankName, BankBranch, WorkStatus, DOB.DbValue(Constants.DatabaseDateString) }); id = "(select top 1 ID from @ID)"; if (LoginID > 0) { query += String.Format(" update Login set EmployeeID = (select top 1 ID from @ID) where ID = {0}", LoginID); } action = DbAction.Employee.Create; } Result = Execute(new DbQuery(userID, employeeID, action, query, true, id, "Name"), out queryResult); if (Result) { Messages = new List <string>() { "Lưu thông tin thành công" } } ; return(Result); }
public override int GetHashCode() { return(ItemID.GetHashCode() + StoreID.GetHashCode()); }
protected void lvINVStore_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 StoreID; Int64.TryParse(e.CommandArgument.ToString(), out StoreID); if (StoreID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _StoreID = StoreID; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(INVStoreEntity.FLD_NAME_StoreID, StoreID.ToString(), SQLMatchType.Equal); INVStoreEntity iNVStoreEntity = new INVStoreEntity(); result = FCCINVStore.GetFacadeCreate().Delete(iNVStoreEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _StoreID = 0; _INVStoreEntity = new INVStoreEntity(); PrepareInitialView(); BindINVStoreList(); MiscUtil.ShowMessage(lblMessage, "I NVStore has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete I NVStore.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }