private void ProcessDemo()
{
DemoDTO dto = this.CreateDemoDto();
// Serialize the dto to xml.
string strXml = DTOSerializerHelper.SerializeDTO(dto);
// Write the serialized dto as xml.
Console.WriteLine("Serialized DTO");
Console.WriteLine("=======================");
Console.WriteLine("\r");
Console.WriteLine(strXml);
Console.WriteLine("\r");
// Deserialize the xml to the data transfer object.
DemoDTO desDto =
(DemoDTO) DTOSerializerHelper.DeserializeXml(strXml,
new DemoDTO());
// Write the deserialized dto values.
Console.WriteLine("Deseralized DTO");
Console.WriteLine("=======================");
Console.WriteLine("\r");
Console.WriteLine("DemoId : " + desDto.DemoId);
Console.WriteLine("Demo Name : " + desDto.DemoName);
Console.WriteLine("Demo Programmer: " + desDto.DemoProgrammer);
Console.WriteLine("\r");
}
public List <DemoDTO> GetAll(string searchString)
{
searchString = searchString == null ? "" : searchString;
List <DemoDTO> GridRecords = new List <DemoDTO>();
var command = dbContext.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "sp_Get_All";
command.AddParameter("@searchString", searchString, DbType.String, 16);
command.OpenConnection();
var reader = command.OpenReader();
while (reader.Read())
{
DemoDTO GridRecord = new DemoDTO();
if (!reader.IsDBNull(reader.GetOrdinal("row_id")))
{
GridRecord.RowId = reader.GetInt32(reader.GetOrdinal("row_id"));
}
if (!reader.IsDBNull(reader.GetOrdinal("name")))
{
GridRecord.Name = reader.GetString(reader.GetOrdinal("name"));
}
if (!reader.IsDBNull(reader.GetOrdinal("email_field")))
{
GridRecord.Email = reader.GetString(reader.GetOrdinal("email_field"));
}
if (!reader.IsDBNull(reader.GetOrdinal("date_field")))
{
GridRecord.DateField = reader.GetDateTime(reader.GetOrdinal("date_field"));
}
if (!reader.IsDBNull(reader.GetOrdinal("decimal_field")))
{
GridRecord.Decimal2Digit = reader.GetDecimal(reader.GetOrdinal("decimal_field"));
}
if (!reader.IsDBNull(reader.GetOrdinal("decimal4_field")))
{
GridRecord.Decimal4Digit = reader.GetDecimal(reader.GetOrdinal("decimal4_field"));
}
if (!reader.IsDBNull(reader.GetOrdinal("number_field")))
{
GridRecord.NumberField = reader.GetInt32(reader.GetOrdinal("number_field"));
}
if (!reader.IsDBNull(reader.GetOrdinal("phone")))
{
GridRecord.Phone = reader.GetString(reader.GetOrdinal("phone"));
}
if (!reader.IsDBNull(reader.GetOrdinal("currency_field")))
{
GridRecord.CurrencyField = reader.GetDecimal(reader.GetOrdinal("currency_field"));
}
GridRecord.Percentage = GridRecord.Decimal2Digit / 100;
GridRecord.PercentageDecimal = GridRecord.Decimal2Digit / 100;
GridRecords.Add(GridRecord);
}
command.CloseConnection();
return(GridRecords);
}
public ActionResult Demo()
{
var model = new DemoDTO()
{
EnumDDL = "721c3846-e4bd-4cc9-8f75-00080f30918a", DemoTime = DateTime.Now.ToYYYYMMDDString()
};
return(View(model));
}
private DemoDTO CreateDemoDto()
{
DemoDTO dto = new DemoDTO();
dto.DemoId = "1";
dto.DemoName = "Data Transfer Object Demonstration Program";
dto.DemoProgrammer = "Kenny Young";
return dto;
}
public static DemoDTO DemoToDemoDTO(Demo demo, List <Demo> demos)
{
DemoDTO objDemoDTO = new DemoDTO();
objDemoDTO.DemoId = demo.DemoId.Value;
foreach (var subDemo in demos)
{
SubDemoDTO objSubDemoDTO = DemoToSubDemoDTO(subDemo);
objDemoDTO.SubDemoDTO.Add(objSubDemoDTO);
}
return(objDemoDTO);
}
public HttpStatusCodeResult UpdateDemo(int id, DemoDTO demoDTO)
{
_demoServices.UpdateDemo(id, demoDTO);
return(new HttpStatusCodeResult(HttpStatusCode.OK));
}
public HttpStatusCodeResult SaveDemo(DemoDTO demoDTO)
{
_demoServices.SaveDemo(demoDTO);
return(new HttpStatusCodeResult(HttpStatusCode.OK));
}
