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());
}
