/// <summary> /// Insert Department data to Database /// </summary> /// <param name="insertDto"> /// object that contains data to insert /// </param> /// <returns> /// 0: insert successful /// others: Sql Exception /// </returns> public int InsertData(IModel insertDto) { MS_ItemDao dao = new MS_ItemDao(); MS_ItemModel dto = (MS_ItemModel)insertDto; return(dao.InsertData(dto)); }
/// <summary> /// Update Department data to Database /// </summary> /// <param name="updateDto"> /// object that contains data to update /// </param> /// <returns> /// 0: insert successful /// others: Sql Exception /// </returns> public int UpdateData(IModel updateDto) { MS_ItemDao dao = new MS_ItemDao(); MS_ItemModel dto = (MS_ItemModel)updateDto; return(dao.UpdateData(dto)); }
/// <summary> /// Search Data in MS_Item table /// </summary> /// <param name="IModel"> /// Dto of Department form /// </param> /// <param name="dtResult"> /// Out a Datatable that contains search result(all columns) in Department table /// </param> /// <returns> /// 0: Update successful /// 1: Access denied, login to database fail(invalid username, invalid password) /// 2: Invalid host, cannot find server(host) that set in app config file /// 3: Invalid database, cannot find database that set in DbConfig file /// 4: Lost connection, cannot connect to database because lost connection /// 5: Duplicate key: insert Primary Key or Unique Key that already exist in database /// 6: Forgeign key not exist: insert a foreign key that not exist in primary key /// 7: Foreign Key Violation: Foreign Key Violation (delete primary key that is foreign key in other table) /// 8: Data not found: Delete or Update data that not exist in database /// 9: Exception occured: other exception /// </returns> public int SearchData(IModel searchDto, out List <IModel> lstResult) { MS_ItemDao dao = new MS_ItemDao(); MS_ItemModel dto = (MS_ItemModel)searchDto; return(dao.SelectData(dto, out lstResult)); }
protected override void SetSearchControlData() { base.SetSearchControlData(); DataSelectList <MS_ItemGroupModel> lstItemGrp = new DataSelectList <MS_ItemGroupModel>(CommonData.FunctionGr.MS_ItemGroups); lstItemGrp.HasNull = true; //lstItemGrp.DisplayMode = DropDownDisplayMode.CodeName; MS_ItemModel model = (MS_ItemModel)this.Model; //Solution 1 ViewBag.Model = model; //Solution 2 if (model != null) { //Reset value to search condition controls ViewBag.Code = model.Code; ViewBag.Name1 = model.Name1; ViewBag.Name2 = model.Name2; //Load data for dropdownlist controls lstItemGrp.SelectedValue = model.GroupCode; } ViewBag.GroupCodeList = lstItemGrp.FillData(); }
/// <summary> /// Search Data in ms_item table /// </summary> /// <param name="selectDto"> /// Dto that contains conditions: Code, Name(VN), Name(EN), Name(JP), GroupCode /// </param> /// <param name="dtResult"> /// Out a Datatable that contains search result(all columns) in ms_item table /// </param> /// <returns> /// 0: Search successful /// others: Sql Exception /// </returns> public int SelectData(MS_ItemModel selectDto, out DataTable dtResult) { int returnCode = CommonData.DbReturnCode.Succeed; dtResult = new DataTable(); try { IQueryable <ms_items> query = this.ms_items.AsQueryable(); #region Search Condition //Filter by Department Code if (!CommonMethod.IsNullOrEmpty(selectDto.Code)) { query = query.Where(d => d.Code.Contains(selectDto.Code)); } //Filter by Department Name if (!CommonMethod.IsNullOrEmpty(selectDto.Name1)) { query = query.Where(d => d.Name1.Contains(selectDto.Name1)); } if (!CommonMethod.IsNullOrEmpty(selectDto.Name2)) { query = query.Where(d => d.Name2.Contains(selectDto.Name2)); } #endregion #region Search data var queryResult = from d in query select new MS_ItemModel { ID = d.ID, Code = d.Code, Name1 = d.Name1, Name2 = d.Name2, }; dtResult = base.ToDataTable(queryResult); #endregion } catch (Exception ex) { returnCode = this.ProcessDbException(ex); } return(returnCode); }
/// <summary> /// Update Department /// </summary> /// <param name="updateDto"> /// Dto that contains all Department data /// </param> /// <returns> /// 0: insert successful /// others: Sql Exception /// </returns> public int UpdateData(MS_ItemModel updateDto) { int returnCode = CommonData.DbReturnCode.Succeed; try { using (BaseDao context = new BaseDao()) { ms_items _departments = context.ms_items.FirstOrDefault(d => d.ID.Equals(updateDto.ID)); if (_departments != null) { _departments.Code = updateDto.Code; _departments.Name1 = updateDto.Name1; _departments.Name2 = updateDto.Name2; _departments.GroupCode = updateDto.GroupCode; _departments.InvUnitCode = updateDto.InvUnitCode; //_departments.Insert_PIC = !CommonMethod.IsNullOrEmpty(updateDto.Insert_PIC) ? updateDto.Insert_PIC : string.Empty; //_departments.Update_PIC = !CommonMethod.IsNullOrEmpty(updateDto.Update_PIC) ? updateDto.Update_PIC : string.Empty; //Create insert information this.CreateUpdateHistory(_departments, CommonData.FunctionGr.MS_Items); //Save to database returnCode = context.Saves(CommonData.FunctionGr.MS_Items, CommonData.Action.Update, new { _departments.Code, _departments.Name1, _departments.Name2, _departments.Name3, _departments.Remark, }, typeof(ms_items).Name); } else { returnCode = CommonData.DbReturnCode.DataNotFound; } } } catch (Exception ex) { returnCode = this.ProcessDbException(ex); } return(returnCode); }
/// <summary> /// Insert new Department /// </summary> /// <param name="insertDto"> /// Dto that contains all Department data /// </param> /// <returns> /// 0: insert successful /// others: Sql Exception /// </returns> public int InsertData(MS_ItemModel insertDto) { int returnCode = CommonData.DbReturnCode.Succeed; try { ms_items _departments = new ms_items(); _departments.Code = insertDto.Code; _departments.Name1 = insertDto.Name1; _departments.Name2 = insertDto.Name2; _departments.GroupCode = insertDto.GroupCode; _departments.InvUnitCode = insertDto.InvUnitCode; //_departments.Insert_PIC = !CommonMethod.IsNullOrEmpty(insertDto.Insert_PIC) ? insertDto.Insert_PIC : string.Empty; //Create insert information //this.CreateInsertHistory(_departments, CommonData.FunctionGr.ms_items); //Add Factory this.ms_items.AddObject(_departments); //Save to database returnCode = this.Saves(CommonData.FunctionGr.MS_Items, CommonData.Action.Insert, new { _departments.Code, _departments.Name1, _departments.Name2, _departments.Name3, _departments.Remark, }, typeof(ms_items).Name); } catch (Exception ex) { string error = ex.Message.ToString(); returnCode = this.ProcessDbException(ex); } return(returnCode); }
/// <summary> /// Search Data in ms_item table /// </summary> /// <param name="selectDto"> /// Dto that contains conditions: Code, Name(VN), Name(EN), Name(JP), GroupCode /// </param> /// <param name="dtResult"> /// Out a Datatable that contains search result(all columns) in ms_item table /// </param> /// <returns> /// 0: Search successful /// others: Sql Exception /// </returns> public int SelectData(MS_ItemModel selectDto, out List <IModel> lstResult) { int returnCode = CommonData.DbReturnCode.Succeed; lstResult = new List <IModel>(); try { var query = this.ms_items .Join(this.ms_units, it => it.InvUnitCode, un => un.Code, (it, un) => new { Item = it, InvUnit = un }) .Join(this.ms_itemgrp, it => it.Item.GroupCode, un => un.Code, (it, un) => new { ItemUnit = it, Group = un }) .Select(x => new { ID = x.ItemUnit.Item.ID, Code = x.ItemUnit.Item.Code, Name1 = x.ItemUnit.Item.Name1, Name2 = x.ItemUnit.Item.Name2, Name3 = x.ItemUnit.Item.Name3, GroupCode = x.Group.Code, GroupName1 = x.Group.Name1, GroupName2 = x.Group.Name2, GroupName3 = x.Group.Name3, InvUnitCode = x.ItemUnit.InvUnit.Code, InvUnitName1 = x.ItemUnit.InvUnit.Name1, InvUnitName2 = x.ItemUnit.InvUnit.Name2, }) .AsQueryable(); #region Search Condition //Filter by Department Code if (!CommonMethod.IsNullOrEmpty(selectDto.Code)) { query = query.Where(d => d.Code.Contains(selectDto.Code)); } //Filter by Department Name if (!CommonMethod.IsNullOrEmpty(selectDto.Name1)) { query = query.Where(d => d.Name1.Contains(selectDto.Name1)); } if (!CommonMethod.IsNullOrEmpty(selectDto.Name2)) { query = query.Where(d => d.Name2.Contains(selectDto.Name2)); } if (!CommonMethod.IsNullOrEmpty(selectDto.GroupCode)) { query = query.Where(d => d.GroupCode.Contains(selectDto.GroupCode)); } #endregion #region Search data lstResult = query.Select(ss => new MS_ItemModel { ID = ss.ID, Code = ss.Code, Name1 = ss.Name1, Name2 = ss.Name2, GroupCode = ss.GroupCode, GroupName = UserSession.LangId == CommonData.LanguageDB.VietNamese ? ss.GroupName1 : UserSession.LangId == CommonData.LanguageDB.Japanese ? ss.GroupName3 : ss.GroupName2, InvUnitCode = ss.InvUnitCode, }) .ToList() .Cast <IModel>() .ToList(); #endregion } catch (Exception ex) { returnCode = this.ProcessDbException(ex); } return(returnCode); }