public static DataTypeView MapEntityToView(DataType dt) { DataTypeView dtv = new DataTypeView(); dtv.FldKey = dt.FldKey; dtv.FldBigInt = dt.FldBigInt.ToString(); dtv.FldBit = dt.FldBit.ToString(); dtv.FldChar = dt.FldChar.Trim(); dtv.FldDateTime = dt.FldDateTime.ToString(); dtv.FldDecimal = dt.FldDecimal.ToString(); dtv.FldInt = dt.FldInt.ToString(); dtv.FldMoney = dt.FldMoney.ToString(); dtv.FldNChar = dt.FldNChar.Trim(); dtv.FldNText = dt.FldNText.Trim(); dtv.FldNumeric = dt.FldNumeric.ToString(); dtv.FldNVarChar = dt.FldNVarChar.Trim(); dtv.FldNVarCharMax = dt.FldNVarCharMax.Trim(); dtv.FldSmallDateTime = dt.FldSmallDateTime.ToString(); dtv.FldSmallInt = dt.FldSmallInt.ToString(); dtv.FldSmallMoney = dt.FldSmallMoney.ToString(); dtv.FldText = dt.FldText.Trim(); dtv.FldTinyInt = dt.FldTinyInt.ToString(); dtv.FldVarChar = dt.FldVarChar.Trim(); dtv.FldVarCharMax = dt.FldVarCharMax.Trim(); return dtv; }
public static DataType MapViewToEntity(DataTypeView dtv) { DataType dt = new DataType(); dt.FldKey = dtv.FldKey; dt.FldBigInt = Convert.ToInt64(dtv.FldBigInt); dt.FldBit = Boolean.Parse(dtv.FldBit); dt.FldChar = dtv.FldChar; dt.FldDateTime = Convert.ToDateTime(dtv.FldDateTime); dt.FldDecimal = Convert.ToDecimal(dtv.FldDecimal); dt.FldInt = Convert.ToInt32(dtv.FldInt); dt.FldMoney = Convert.ToDecimal(dtv.FldMoney); dt.FldNChar = dtv.FldNChar; dt.FldNText = dtv.FldNText; dt.FldNumeric = Convert.ToDecimal(dtv.FldNumeric); dt.FldNVarChar = dtv.FldNVarChar; dt.FldNVarCharMax = dtv.FldNVarCharMax; dt.FldSmallDateTime = Convert.ToDateTime(dtv.FldSmallDateTime); dt.FldSmallInt = Convert.ToInt16(dtv.FldSmallInt); dt.FldSmallMoney = Convert.ToDecimal(dtv.FldSmallMoney); dt.FldText = dtv.FldText; dt.FldTinyInt = Convert.ToByte(dtv.FldTinyInt); dt.FldVarChar = dtv.FldVarChar; dt.FldVarCharMax = dtv.FldVarCharMax; return dt; }
public int SaveDataType(string FldKey, DataType addDataType) { int result = 0; DataTypesBusinessEntities.DataTypeView dtv = new DataTypesBusinessEntities.DataTypeView(); dtv.FldKey = addDataType.FldKey; dtv.FldBigInt = addDataType.FldBigInt.Trim(); dtv.FldBit = addDataType.FldBit.Trim(); dtv.FldChar = addDataType.FldChar.Trim(); dtv.FldDateTime = addDataType.FldDateTime.Trim(); dtv.FldDecimal = addDataType.FldDecimal.Trim(); dtv.FldInt = addDataType.FldInt.Trim(); dtv.FldMoney = addDataType.FldMoney.Trim(); dtv.FldNChar = addDataType.FldNChar.Trim(); dtv.FldNText = addDataType.FldNText.Trim(); dtv.FldNumeric = addDataType.FldNumeric.Trim(); dtv.FldNVarChar = addDataType.FldNVarChar.Trim(); dtv.FldNVarCharMax = addDataType.FldNVarCharMax.Trim(); dtv.FldSmallDateTime = addDataType.FldSmallDateTime.Trim(); dtv.FldSmallInt = addDataType.FldSmallInt.Trim(); dtv.FldSmallMoney = addDataType.FldSmallMoney.Trim(); dtv.FldText = addDataType.FldText.Trim(); dtv.FldTinyInt = addDataType.FldTinyInt.Trim(); dtv.FldVarChar = addDataType.FldVarChar.Trim(); dtv.FldVarCharMax = addDataType.FldVarCharMax.Trim(); result = _dataTypesService.SaveDataType(dtv); return result; }
public int SaveDataType(string FldKey, DataType addDataType) { int result = 0; DataTypesBusinessEntities.DataTypeView dtv = new DataTypesBusinessEntities.DataTypeView(); dtv.FldKey = addDataType.FldKey; dtv.FldBigInt = addDataType.FldBigInt.Trim(); dtv.FldBit = addDataType.FldBit.Trim(); dtv.FldChar = addDataType.FldChar.Trim(); dtv.FldDateTime = addDataType.FldDateTime.Trim(); dtv.FldDecimal = addDataType.FldDecimal.Trim(); dtv.FldInt = addDataType.FldInt.Trim(); dtv.FldMoney = addDataType.FldMoney.Trim(); dtv.FldNChar = addDataType.FldNChar.Trim(); dtv.FldNText = addDataType.FldNText.Trim(); dtv.FldNumeric = addDataType.FldNumeric.Trim(); dtv.FldNVarChar = addDataType.FldNVarChar.Trim(); dtv.FldNVarCharMax = addDataType.FldNVarCharMax.Trim(); dtv.FldSmallDateTime = addDataType.FldSmallDateTime.Trim(); dtv.FldSmallInt = addDataType.FldSmallInt.Trim(); dtv.FldSmallMoney = addDataType.FldSmallMoney.Trim(); dtv.FldText = addDataType.FldText.Trim(); dtv.FldTinyInt = addDataType.FldTinyInt.Trim(); dtv.FldVarChar = addDataType.FldVarChar.Trim(); dtv.FldVarCharMax = addDataType.FldVarCharMax.Trim(); result = _dataTypesService.SaveDataType(dtv); return(result); }
/// <summary> /// /// </summary> /// <param name="FldKey"></param> /// <returns></returns> public DataTypeView GetDataTypeView(int FldKey) { DataTypeView dataTypeView = new DataTypeView(); DataType dataType = _repository.GetDataType(FldKey); dataTypeView = DataTypesMapper.MapEntityToView(dataType); return dataTypeView; }
/// <summary> /// /// </summary> /// <param name="dtv"></param> /// <returns></returns> public int SaveDataType(DataTypeView dtv) { int result = 0; // Validation this.Errors.Clear(); try { // Data access if (!this.HasErrors) { // Save DataType entity = DataTypesMapper.MapViewToEntity(dtv); result = this._repository.SetDataType(entity); } } catch (System.Data.UpdateException ex) { if (ex.InnerException != null && ex.InnerException is System.Data.SqlClient.SqlException && ((System.Data.SqlClient.SqlException)ex.InnerException).ErrorCode == 8152) Errors.Add(ResourceStrings.ErrorMaxLength); else Errors.Add(ex.Message); } return result; }
private void AddViewToList(DataTypeView dtv, ref DataTypeList list) { // Map DataTypeView to DataType and add to DataTypeList list.Add(new DataType() { FldKey = dtv.FldKey, FldBigInt = dtv.FldBigInt.Trim(), FldBit = dtv.FldBit.Trim(), FldChar = dtv.FldChar.Trim(), FldDateTime = dtv.FldDateTime.Trim(), FldDecimal = dtv.FldDecimal.Trim(), FldInt = dtv.FldInt.Trim(), FldMoney = dtv.FldMoney.Trim(), FldNChar = dtv.FldNChar.Trim(), FldNText = dtv.FldNText.Trim(), FldNumeric = dtv.FldNumeric.Trim(), FldNVarChar = dtv.FldNVarChar.Trim(), FldNVarCharMax = dtv.FldNVarCharMax.Trim(), FldSmallDateTime = dtv.FldSmallDateTime.Trim(), FldSmallInt = dtv.FldSmallInt.Trim(), FldSmallMoney = dtv.FldSmallMoney.Trim(), FldText = dtv.FldText.Trim(), FldTinyInt = dtv.FldTinyInt.Trim(), FldVarChar = dtv.FldVarChar.Trim(), FldVarCharMax = dtv.FldVarCharMax.Trim() }); }