public PRO_tblProvinceDRO DeleteProvince(string Username, string LanguageID, string ProvinceIDList) { PRO_tblProvinceDRO result = new PRO_tblProvinceDRO(); try { using (var scope = Container.BeginLifetimeScope()) { string temp = ""; var db = scope.Resolve<IPRO_tblProvinceDAO>(); if (ProvinceIDList.Contains("$")) temp = db.DeleteProvinceList(ProvinceIDList, Username, LanguageID); else temp = db.DeleteProvince(ProvinceIDList, Username, LanguageID); result.ResponseItem = new DCO.ResponseItem { Result = string.IsNullOrEmpty(temp) ? true : false, Status = string.IsNullOrEmpty(temp) ? DCO.ResponseStatus.Success : DCO.ResponseStatus.Failure, Message = string.IsNullOrEmpty(temp) ? string.Empty : temp, RequestUser = Username, TotalItemCount = string.IsNullOrEmpty(temp) ? 1 : 0 }; } } catch (Exception ex) { result.ResponseItem = new DCO.ResponseItem { Result = false, Status = DCO.ResponseStatus.Exception, Message = "Delete province failed because: " + ex.Message, RequestUser = Username, TotalItemCount = 0 }; logger.Error(ex); } return result; }
public PRO_tblProvinceDRO GetProvinceByID(string Username, string LanguageID, string ProvinceID) { PRO_tblProvinceDRO result = new PRO_tblProvinceDRO(); try { using (var scope = Container.BeginLifetimeScope()) { var db = scope.Resolve<IPRO_tblProvinceDAO>(); var temp = db.GetDataByID(ProvinceID, Username, LanguageID); if (temp != null) { result.ProvinceItem = Mapper.Map<PRO_tblProvinceDCO>(temp); result.ResponseItem = new DCO.ResponseItem { Result = true, Status = DCO.ResponseStatus.Success, Message = "", RequestUser = Username, TotalItemCount = 1 }; } } } catch (Exception ex) { result.ProvinceItem = Mapper.Map<PRO_tblProvinceDCO>(new PRO_tblProvinceDTO()); result.ResponseItem = new DCO.ResponseItem { Result = false, Status = DCO.ResponseStatus.Exception, Message = "Load province item failed: " + ex.Message, RequestUser = Username, TotalItemCount = 0 }; logger.Error(ex); } return result; }
public PRO_tblProvinceDRO InsertUpdateProvince(PRO_tblProvinceDCO province) { PRO_tblProvinceDRO result = new PRO_tblProvinceDRO(); try { using (var scope = Container.BeginLifetimeScope()) { string temp = ""; var db = scope.Resolve<IPRO_tblProvinceDAO>(); var data = Mapper.Map<PRO_tblProvinceDTO>(province); if (province.Activity.Equals(BaseConstant.COMMAND_INSERT_EN)) temp = db.InsertProvince(data); else temp = db.UpdateProvince(data); result.ResponseItem = new DCO.ResponseItem { Result = string.IsNullOrEmpty(temp) ? true : false, Status = string.IsNullOrEmpty(temp) ? DCO.ResponseStatus.Success : DCO.ResponseStatus.Failure, Message = string.IsNullOrEmpty(temp) ? string.Empty : temp, RequestUser = province.UserID, TotalItemCount = string.IsNullOrEmpty(temp) ? 1 : 0 }; } } catch (Exception ex) { result.ResponseItem = new DCO.ResponseItem { Result = false, Status = DCO.ResponseStatus.Exception, Message = "Insert new province failed because: " + ex.Message, RequestUser = province.UserID, TotalItemCount = 0 }; logger.Error(ex); } return result; }
public PRO_tblProvinceDRO GetAllProvinces(string Username, string LanguageID, bool GetCombobox) { PRO_tblProvinceDRO result = new PRO_tblProvinceDRO(); try { using (var scope = Container.BeginLifetimeScope()) { List<PRO_tblProvinceDTO> temp = new List<PRO_tblProvinceDTO>(); var db = scope.Resolve<IPRO_tblProvinceDAO>(); if (!GetCombobox) temp = db.LoadAllData(Username, LanguageID); else temp = db.GetDataCombobox(Username, LanguageID); if (temp != null) { result.ProvinceList = Mapper.Map<List<PRO_tblProvinceDCO>>(temp); result.ResponseItem = new DCO.ResponseItem { Result = true, Status = DCO.ResponseStatus.Success, Message = "", RequestUser = Username, TotalItemCount = temp.Count }; } } } catch (Exception ex) { result.ProvinceList = Mapper.Map<List<PRO_tblProvinceDCO>>(new List<PRO_tblProvinceDTO>()); result.ResponseItem = new DCO.ResponseItem { Result = false, Status = DCO.ResponseStatus.Exception, Message = "Load province list failed: " + ex.Message, RequestUser = Username, TotalItemCount = 0 }; logger.Error(ex); } return result; }