private void PopulateInterfaceFromModel(int id) { using (var facade = new PositionModuleCore()) { var positionModel = facade.Get <IPositionModel>(WhereTerm.DefaultParam(id, "ID")).FirstOrDefault(); if (positionModel == null || !facade.IsSuccess) { MsgHelpers.ShowError(this, string.IsNullOrEmpty(facade.Message) ? "Employee Position not found" : facade.Message); return; } createdBy.Text = positionModel.CreatedBy; createdDate.Value = positionModel.CreatedDate; recordId.Text = positionModel.Id.ToString(); positionName.Text = positionModel.PositionName; createdBy.Text = positionModel.CreatedBy; createdDate.Value = positionModel.CreatedDate; modifiedBy.Text = positionModel.ModifiedBy; modifiedDate.Value = positionModel.ModifiedDate.HasValue ? positionModel.ModifiedDate.Value : DateTime.Now; } }
private void PopulateInterfaceFromModel(int id) { using (var facade = new EmployeeCore()) { var employee = facade.Get <IEmployeeModel>(WhereTerm.DefaultParam(id, "ID")).FirstOrDefault(); if (employee == null || !facade.IsSuccess) { MsgHelpers.ShowError(this, string.IsNullOrEmpty(facade.Message) ? "Employee not found" : facade.Message); return; } address.Text = employee.Address; bankAccount.Text = employee.BankAccount; bankName.Text = employee.BankName; birthDate.Value = employee.BirthDate; cityName.Text = employee.City; createdBy.Text = employee.CreatedBy; createdDate.Value = employee.CreatedDate; firstName.Text = employee.FirstName; gender.Text = employee.Gender; hireDate.Value = employee.HiredDate; recordId.Text = employee.Id.ToString(CultureInfo.InvariantCulture); lastName.Text = employee.LastName; maritalStatus.Text = employee.MaritalStatus; middleName.Text = employee.MiddleName; nationalIdNumber.Text = employee.NationalIDNumber; payrollGroupCode.Text = employee.PayrollGroupCode; positionName.Text = employee.PositionName; postalCode.Text = employee.PostalCode; stateName.Text = employee.State; titleName.Text = employee.Title; createdBy.Text = employee.CreatedBy; createdDate.Value = employee.CreatedDate; modifiedBy.Text = employee.ModifiedBy; modifiedDate.Value = employee.ModifiedDate.HasValue ? employee.ModifiedDate.Value : DateTime.Now; employeeId.Text = employee.EmployeeID; isTerminate.Text = employee.IsTerminate.ToString(); terminateDate.Value = employee.TerminateDate.HasValue ? employee.TerminateDate.Value : DateTime.Now; terminateDate.Checked = employee.TerminateDate.HasValue; terminateDescription.Text = employee.TerminateDescription; } }
private void PopulateInterfaceFromModel(int id) { using (var facade = new CityCore()) { var city = facade.Get <ICityModel>(WhereTerm.DefaultParam(id, "ID")).FirstOrDefault(); if (city == null || !facade.IsSuccess) { MsgHelpers.ShowError(this, string.IsNullOrEmpty(facade.Message) ? "Employee not found" : facade.Message); return; } recordId.Text = city.Id.ToString(); cityName.Text = city.CityName; createdBy.Text = city.CreatedBy; createdDate.Value = city.CreatedDate; modifiedBy.Text = city.ModifiedBy; if (city.ModifiedDate != null) { modifiedDate.Value = (DateTime)city.ModifiedDate; } } }
//public abstract int Save<T>(ref T businessModel) where T : IBaseModel; //public abstract int Update<T>(ref T businessModel) where T : IBaseModel; //public abstract int Delete(int id); //public abstract IList<T> Get<T>() where T : IBaseModel; //public abstract IList<T> Get<T>(params WhereTerm[] parameter) where T : IBaseModel; //public abstract IList<T> Get<T>(int id) where T : IBaseModel; //public abstract IList<T> GetPaging<T>(int start, int limit, string sort, string dir, out int totalCount, params IListParameter[] parameter) where T : IBaseModel; protected string GetQueryParameterLinq(IEnumerable <IListParameter> lparams) { var listparams = new List <IListParameter>(); if (lparams != null) { listparams.AddRange(lparams); } listparams.Add(WhereTerm.DefaultParam(0, "RowStatus")); var query = new StringBuilder(); ListValue = new Collection <object>(); var indexpass = 0; var d = listparams.Where(param => !string.IsNullOrEmpty(param.ColumnName)).ToList(); listparams = d; foreach (var param in listparams) { var index = listparams.ToList().IndexOf(param) + indexpass; switch (param.ParamDataType) { case EnumParamterDataTypes.DateTime: { var date1 = Convert.ToDateTime(param.GetValue()); var fdate = new DateTime(date1.Year, date1.Month, date1.Day, 0, 0, 0); var ldate = new DateTime(date1.Year, date1.Month, date1.Day, 23, 59, 59); var fparma = WhereTerm.DefaultParam(fdate, param.ColumnName, SqlOperator.GreatThanEqual); var lparma = WhereTerm.DefaultParam(ldate, param.ColumnName, SqlOperator.LesThanEqual); query.Append(GetValueParameterLinq(fparma, index) + DefaultValue.LOGICAL_SQL); ListValue.Add(fparma.GetValue()); index++; indexpass++; query.Append(GetValueParameterLinq(lparma, index) + DefaultValue.LOGICAL_SQL); ListValue.Add(lparma.GetValue()); } break; case EnumParamterDataTypes.DateTimeRange: { query.Append(GetValueParameterLinq(param, index) + DefaultValue.LOGICAL_SQL); ListValue.Add(param.GetValue()); var date1 = Convert.ToDateTime(((IListRangeParameter)param).GetValue2()); var ldate = new DateTime(date1.Year, date1.Month, date1.Day, 23, 59, 59); ListValue.Add(ldate); indexpass++; } break; default: query.Append(GetValueParameterLinq(param, index) + DefaultValue.LOGICAL_SQL); ListValue.Add(param.GetValue()); break; } } if (query.Length != 0) { var qresult = query.ToString().Trim(); if (qresult.Substring(qresult.Length - 3, 3) == DefaultValue.LOGICAL_SQL.Trim()) { qresult = qresult.Remove(qresult.Length - 3, 3); } return(qresult); } return(query.ToString()); }