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); }
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() }); }
/// <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); }
public DataTypeList GetDataType(string FldKey) { DataTypeView dtv = _dataTypesService.GetDataTypeView(int.Parse(FldKey)); DataTypeList dataTypeList = new DataTypeList(); AddViewToList(dtv, ref dataTypeList); return(dataTypeList); }
private static void GetDataTypeView(int FldKey) { DataTypeView dtv = null; dtv = dts.GetDataTypeView(FldKey); Console.WriteLine(string.Format("*** GetDataTypeView ***")); Console.WriteLine(string.Format("DataTypeView FldKey: {0} FldNVarChar: {1} FldNVarChar: {2}", dtv.FldKey.ToString(), dtv.FldNVarChar, dtv.FldBigInt.ToString())); Console.WriteLine(Environment.NewLine); }
/// <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); }
public JsonObject GetDataTypeSaveView(long dataTypeId, long pageNo, long itemsPerPage, long dataIndex, string templateSuffix) { JsonObject retMessage = new JsonObject(); string htmlText = DataTypeView.GetSaveDetailView(dataTypeId, pageNo, itemsPerPage, dataIndex, templateSuffix); retMessage.Put("html", htmlText); return(retMessage); }
private static void UpdateDataTypeRow(int FldKey) { // Get DataTypeView DataTypeView dtv = null; dtv = dts.GetDataTypeView(FldKey); Console.WriteLine(string.Format("*** UpdateDataTypeRow ***")); Console.WriteLine(string.Format("Original DataTypeView FldKey: {0} FldNVarChar: {1} FldBigInt: {2}", dtv.FldKey, dtv.FldNVarChar, dtv.FldBigInt.ToString())); // Change DataTypeView dtv.FldBigInt = "1911"; dtv.FldBit = "false"; dtv.FldChar = "zon"; //dtv.FldDate dtv.FldDateTime = "1/9/2012"; //dtv.FldDateTime2 dtv.FldDecimal = "2911.11"; //dtv.FldFloat //dtv.FldImage dtv.FldInt = "3911"; dtv.FldMoney = "4911.11"; dtv.FldNChar = "zonald"; dtv.FldNText = "zonnie"; dtv.FldNumeric = "5911.11"; dtv.FldNVarChar = "zonaldo"; dtv.FldNVarCharMax = "zjl"; //dtv.FldReal dtv.FldSmallDateTime = "2/9/2012"; dtv.FldSmallInt = "69"; dtv.FldSmallMoney = "7911.11"; dtv.FldText = "zinaldo"; //TODO: FldTime should be DateTime not Timespan //dtv.FldTime = Convert.ToDateTime("3/1/2012 17:32:19"); //dtv.FldTimeStamp dtv.FldTinyInt = "89"; //dtv.FldUniqueIdentifier //dtv.FldVarBinary //dtv.FldVarBinaryMax dtv.FldVarChar = "zeynaldo"; dtv.FldVarCharMax = "zownaldo"; //dtv.FldXml // Save DataType dts.SaveDataType(dtv); // Get updated DataTypeView dtv = dts.GetDataTypeView(FldKey); Console.WriteLine(string.Format("Updated DataTypeView FldKey: {0} FldNVarChar: {1} FldBigInt: {2}", dtv.FldKey, dtv.FldNVarChar, dtv.FldBigInt.ToString())); Console.WriteLine(Environment.NewLine); }
public JsonObject GetDataTypeListView(long pageNo, long itemsPerPage, long dataIndex, string templateSuffix) { JsonObject retMessage = new JsonObject(); string htmlText = DataTypeView.GetListAllItemView(pageNo, itemsPerPage, dataIndex, templateSuffix); if (string.IsNullOrEmpty(htmlText) == true) { htmlText = " "; } retMessage.Put("html", htmlText); return(retMessage); }
public Segment AddSegment(Packet currentPacket) { var segment = new Segment { Name = "", Description = "", OrderId = currentPacket.Segments.Count + 1, Type = new DataTypeView { Type = DataType.Byte }, Size = DataTypeView.SizeOfType(DataType.Byte) }; currentPacket.Segments.Add(segment); return(segment); }
private static void AddDataTypeRow() { DataTypeView dtv = new DataTypeView(); dtv.FldKey = 0; dtv.FldBigInt = "1111"; dtv.FldBit = "true"; dtv.FldChar = "ron"; //dtv.FldDate dtv.FldDateTime = "1/1/2012"; //dtv.FldDateTime2 dtv.FldDecimal = "2111.11"; //dtv.FldFloat //dtv.FldImage dtv.FldInt = "3111"; dtv.FldMoney = "4111.11"; dtv.FldNChar = "ronald"; dtv.FldNText = "ronnie"; dtv.FldNumeric = "5111.11"; dtv.FldNVarChar = "ronaldo"; dtv.FldNVarCharMax = "rjl"; //dtv.FldReal dtv.FldSmallDateTime = "2/1/2012"; dtv.FldSmallInt = "6"; dtv.FldSmallMoney = "7111.11"; dtv.FldText = "rinaldo"; //TODO: FldTime should be DateTime not Timespan //dtv.FldTime = Convert.ToDateTime("3/1/2012 17:32:19"); //dtv.FldTimeStamp dtv.FldTinyInt = "8"; //dtv.FldUniqueIdentifier //dtv.FldVarBinary //dtv.FldVarBinaryMax dtv.FldVarChar = "reynaldo"; dtv.FldVarCharMax = "rownaldo"; //dtv.FldXml newDataTypeFldKey = dts.SaveDataType(dtv); Console.WriteLine(string.Format("*** AddDataTypeRow ***")); Console.WriteLine(string.Format("New FldKey: {0}", newDataTypeFldKey.ToString())); Console.WriteLine(Environment.NewLine); }
private void CbDataTypeOnSelectionChanged(object sender, SelectionChangedEventArgs e) { if (CurrentSegment == null) { return; } if (CbDataType.SelectedIndex == -1) { return; } CurrentSegment.Type = (DataTypeView)CbDataType.SelectedItem; var fixedSize = DataTypeView.SizeOfType(CurrentSegment.Type.Type); if (fixedSize > 0) { CurrentSegment.Size = fixedSize; TxtSegmentSize.Text = CurrentSegment.Size.ToString(CultureInfo.InvariantCulture); TxtSegmentSize.IsEnabled = false; } else { TxtSegmentSize.IsEnabled = true; } }