public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from Rol a where ");
Rol rol = (Rol)data;
if (rol != null)
{
Parms = new List<Object[]>();
if (rol.RolID != 0)
{
sql.Append(" a.RolID = :id and ");
Parms.Add(new Object[] { "id", rol.RolID });
}
if (!String.IsNullOrEmpty(rol.RolCode))
{
sql.Append(" a.RolCode = :nom and ");
Parms.Add(new Object[] { "nom", rol.RolCode });
}
if (!String.IsNullOrEmpty(rol.Name))
{
sql.Append(" a.Name = :nom1 and ");
Parms.Add(new Object[] { "nom1", rol.Name });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.RolID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public List<Book> LoadToList()
{
List<Book> books = new List<Book>();
try
{
XDocument document = XDocument.Load(filePath);
var boooks = document.Elements("books").Elements("book");
foreach (XElement e in boooks)
{
Book b = new Book();
b.Title = e.Element("title").Value;
b.Author = e.Element("author").Value;
b.Publiser = e.Element("publisher").Value;
b.Year = int.Parse(e.Element("year").Value);
b.NumberOfPages = int.Parse(e.Element("numberOfPages").Value);
books.Add(b);
}
return books;
}
catch (FileNotFoundException)
{
throw new InvalidDataException("Error while saving");
}
}
public IQueryable<ComplejoModelResponse> GetAllComplejos()
{
try
{
var complejos = from complejo in complejoRepository.All
select complejo;
List<ComplejoModelResponse> list = new List<ComplejoModelResponse>();
list.Add(new ComplejoModelResponse()
{
HttpStatusCode = 200,
HttpStatusDesc = "Ok",
Complejos = complejos
});
return list.AsQueryable();
}
catch (Exception ex)
{
List<ComplejoModelResponse> list = new List<ComplejoModelResponse>();
list.Add(new ComplejoModelResponse()
{
HttpStatusCode = 400,
HttpStatusDesc = "Bad Request",
Complejos = new List<Complejo>().AsQueryable(),
Exception = ex
});
return list.AsQueryable();
}
}
protected override void BuildBetTeam(ITicket ticket, ITicketHelper ticketHelper, List<ITicketData> ticketData)
{
var betTeam = string.Empty;
switch (ticket.BetTeam)
{
case "0:0":
betTeam = CoreBetList.NoGoalBetType14;
break;
case "1:1":
betTeam = CoreBetList.HomeFG;
break;
case "1:2":
betTeam = CoreBetList.HomeLG;
break;
case "2:1":
betTeam = CoreBetList.AwayFG;
break;
case "2:2":
betTeam = CoreBetList.AwayLG;
break;
}
Template.betTeam = betTeam;
}
public IList<KitAssembly> Select(KitAssembly data, int showRegs)
{
IList<KitAssembly> datos = new List<KitAssembly>();
/*
datos = GetHsql(data).List<KitAssembly>();
if (!Factory.IsTransactional)
Factory.Commit();
return datos;
*/
try
{
if (showRegs > 0)
datos = GetHsql(data).SetMaxResults(showRegs).List<KitAssembly>();
else
datos = GetHsql(data).List<KitAssembly>();
if (!Factory.IsTransactional)
Factory.Commit();
}
catch (Exception e)
{
NHibernateHelper.WriteEventLog(WriteLog.GetTechMessage(e));
}
return datos;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from NodeRoute a where ");
NodeRoute noderoute = (NodeRoute)data;
if (noderoute != null)
{
Parms = new List<Object[]>();
if (noderoute.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", noderoute.RowID });
}
if (noderoute.NextNode != null && noderoute.NextNode.NodeID != 0)
{
sql.Append(" a.NextNode.NodeID = :id1 and ");
Parms.Add(new Object[] { "id1", noderoute.NextNode.NodeID });
}
if (noderoute.CurNode != null && noderoute.CurNode.NodeID != 0)
{
sql.Append(" a.CurNode.NodeID = :id2 and ");
Parms.Add(new Object[] { "id2", noderoute.CurNode.NodeID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.RowID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
protected override void BuildBetTeam(ITicket ticket, ITicketHelper ticketHelper, List<ITicketData> ticketData)
{
string team = ticket.BetTeam != null && ticket.BetTeam.Contains(BetTeamValue.H) ? Template.Match.homeTeam : Template.Match.awayTeam;
string yesNo = ticket.BetTeam != null && ticket.BetTeam.Contains(BetTeamValue.Y) ? CoreBetList.lblYes : CoreBetList.lblNo;
Template.betTeam = string.Join(null, new string[] { team, " <span class=\"", Favorite, "\">", yesNo.ToUpper(), "</span>" });
}
public List<Person> getExamplePersons()
{
List<Person> PERSON = null;
try
{
CONNECTION.Open();
String query = "SELECT TOP 100 [FirstName],[MiddleName],[LastName] FROM [Person].[Person]";
COMMAND = new SqlCommand(query, CONNECTION);
READER = COMMAND.ExecuteReader();
if (READER.HasRows)
{
PERSON = new List<Person>();
EntityMapper MAPPER = new EntityMapper();
while (READER.Read())
PERSON.Add(MAPPER.convertToPerson(READER));
}
CONNECTION.Close();
}
catch (Exception EX)
{
errorMessage = EX.Message;
Console.WriteLine("Error: " + EX.Message);
}
return PERSON;
}
public static List<Kategori> getCategories()
{
List<Kategori> Value = new List<Kategori>();
SqlConnection con = new SqlConnection("Server=.;Database=KutuphaneOtomasyon;Trusted_Connection=true");
SqlCommand cmd = new SqlCommand("select * from dbo.Kategori", con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt32(0);
string adi = reader.GetString(1);
Kategori Current = new Kategori(id, adi);
string aciklama;
try
{
aciklama = reader.GetString(2);
}
catch (SqlNullValueException snve)
{
aciklama = "";
}
Current.Aciklama = aciklama;
Value.Add(Current);
}
reader.Close();
con.Close();
return Value;
}
private IList<byte[]> CreateBlocks(byte[] file)
{
var size = chunkSize;
var blocksCount = Math.Ceiling((decimal)file.Length / size);
var remainingSize = file.Length;
var blocks = new List<byte[]>();
for (int i = 0; i < blocksCount; i++)
{
if (remainingSize > size)
{
remainingSize -= size;
}
else
{
size = remainingSize;
}
var block = file.Skip(i * chunkSize).Take(size).ToArray();
if (block.Length >= chunkSize)
{
blocks.Add(block);
}
else
{
var chunk = new byte[chunkSize];
Array.Copy(block, 0, chunk, 0, block.Length);
blocks.Add(chunk);
}
}
return blocks;
}
public override IQuery GetHsql(object data)
{
StringBuilder sql = new StringBuilder("select a from MenuOption a where ");
MenuOption menuoption = (MenuOption)data;
if (menuoption != null)
{
Parms = new List<Object[]>();
if (menuoption.MenuOptionID != 0)
{
sql.Append(" a.MenuOptionID = :id and ");
Parms.Add(new Object[] { "id", menuoption.MenuOptionID });
}
if (!String.IsNullOrEmpty(menuoption.Name))
{
sql.Append(" a.Name = :nom and ");
Parms.Add(new Object[] { "nom", menuoption.Name });
}
if (!String.IsNullOrEmpty(menuoption.Url))
{
sql.Append(" a.Url = :nom1 and ");
Parms.Add(new Object[] { "nom1", menuoption.Url });
}
if (menuoption.MenuOptionType != null && menuoption.MenuOptionType.MenuOptionTypeID != 0)
{
sql.Append(" a.MenuOptionType.MenuOptionTypeID = :id1 and ");
Parms.Add(new Object[] { "id1", menuoption.MenuOptionType.MenuOptionTypeID });
}
if (menuoption.NumOrder != 0)
{
sql.Append(" a.NumOrder = :id2 and ");
Parms.Add(new Object[] { "id2", menuoption.NumOrder });
}
if (menuoption.Active != null)
{
sql.Append(" a.Active = :ia2 and ");
Parms.Add(new Object[] { "ia2", menuoption.Active });
}
if (menuoption.OptionType != null && menuoption.OptionType.OpTypeID != 0)
{
sql.Append(" a.OptionType.OpTypeID = :io2 and ");
Parms.Add(new Object[] { "io2", menuoption.OptionType.OpTypeID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.MenuOptionID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public List<Entities.AutoMerge> Execute(out int total, int pageSize = -1, int pageNumber = -1)
{
List<Entities.AutoMerge> merges = new List<Entities.AutoMerge>();
StringBuilder query = new StringBuilder();
if(pageSize == -1 || pageNumber == -1)
{
query.AppendLine("SELECT * FROM [dbo].[AutoMerge]");
}
else
{
query.AppendLine("SELECT * FROM [dbo].[AutoMerge] ORDER BY [Id] OFFSET (@pageSize * (@pageNumber - 1)) ROWS FETCH NEXT @pageSize ROWS ONLY");
}
query.AppendLine("SELECT COUNT([Id]) FROM [dbo].[AutoMerge]");
using (IDbConnection connection = database.CreateConnection())
{
using (var multi = connection.QueryMultiple(query.ToString(), new { pageNumber, pageSize }))
{
merges = multi.Read<Entities.AutoMerge>().ToList();
total = multi.Read<int>().First();
}
}
return merges;
}
public List<Book> FindBookByTag(string value,string Key)
{
List<Book> books = new List<Book>();
switch (Key.ToUpperInvariant())
{
case "TITLE":
{
books=Formater.GetByTitle(value);
break;
}
case "AUTHOR":
{
books = Formater.GetByAuthor(value);
break;
}
case "GENRE":
{
books = Formater.GetByGenre(value);
break;
}
case "YEAR":
{
int x;
if (!Int32.TryParse(value, out x)) throw new ArgumentException();
books = Formater.GetByYear(x);
break;
}
}
return books;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from ConnectionType a where ");
ConnectionType ConnectionType = (ConnectionType)data;
if (ConnectionType != null)
{
Parms = new List<Object[]>();
if (ConnectionType.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", ConnectionType.RowID });
}
if (ConnectionType.IsEditable != null)
{
sql.Append(" a.IsEditable = :edt and ");
Parms.Add(new Object[] { "edt", ConnectionType.IsEditable });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.RowID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from C_CasNumber a where ");
C_CasNumber C_CasNumber = (C_CasNumber)data;
if (C_CasNumber != null)
{
Parms = new List<Object[]>();
if (C_CasNumber.CasNumberID != 0)
{
sql.Append(" a.CasNumberID = :id and ");
Parms.Add(new Object[] { "id", C_CasNumber.CasNumberID });
}
if (!String.IsNullOrEmpty(C_CasNumber.Name))
{
sql.Append(" (a.Name like :nom OR a.Code like :nomz) and ");
Parms.Add(new Object[] { "nom", "%" + C_CasNumber.Name + "%" });
Parms.Add(new Object[] { "nomz", C_CasNumber.Name + "%" });
}
if (!String.IsNullOrEmpty(C_CasNumber.Code))
{
sql.Append(" a.Code = :nom1 and ");
Parms.Add(new Object[] { "nom1", C_CasNumber.Code });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.CasNumberID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from MeasureType a where ");
MeasureType measuretype = (MeasureType)data;
if (measuretype != null)
{
Parms = new List<Object[]>();
if (measuretype.MeasureTypeID != 0)
{
sql.Append(" a.MeasureTypeID = :id and ");
Parms.Add(new Object[] { "id", measuretype.MeasureTypeID });
}
if (!String.IsNullOrEmpty(measuretype.Name))
{
sql.Append(" a.Name = :nom and ");
Parms.Add(new Object[] { "nom", measuretype.Name });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.measureTypeID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public static List<Yazar> getAuthors()
{
List<Yazar> Value = new List<Yazar>();
SqlConnection con = new SqlConnection("Server=.;Database=KutuphaneOtomasyon;Trusted_Connection=true");
SqlCommand cmd = new SqlCommand("select * from dbo.Yazar", con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt32(0);
string adi = reader.GetString(1);
string soyadi = reader.GetString(2);
Yazar Current = new Yazar(id, adi, soyadi);
string ozgecmis;
try
{
ozgecmis = reader.GetString(3);
}
catch(SqlNullValueException snve)
{
ozgecmis = "";
}
Current.Ozgecmis = ozgecmis;
Value.Add(Current);
}
reader.Close();
con.Close();
return Value;
}
protected override void BuildBetTeam(ITicket ticket, ITicketHelper ticketHelper, List<ITicketData> ticketData)
{
bool betHomeTeam = ticket.BetTeam != null && ticket.BetTeam.Contains(BetTeamValue.H);
var betTeam = betHomeTeam ? Template.Match.homeTeam : CoreBetList.lblDraw;
Template.betTeam = betTeam;
}
public List<Movie> GetTopTenWorstMovies()
{
using (var ctx = new DatabaseContext())
{
var bests = (from r in ctx.Review
group r by r.MovieId into groupIds
select new { groupIds.Key, Average = groupIds.Sum(x => x.Note) / groupIds.Count() })
.OrderByDescending(x => x.Average)
.Take(10)
.ToList();
var worst = (from r in ctx.Review
group r by r.MovieId into groupIds
select new { groupIds.Key, Average = groupIds.Sum(x => x.Note) / groupIds.Count() })
.ToList()
.Where(r => !bests.Any(y => y.Key == r.Key))
.OrderBy(x => x.Average)
.Take(10)
.ToList();
var listWorst = new List<Movie>();
foreach (var movie in worst)
listWorst.Add(GetById(movie.Key));
return listWorst;
}
}
public static List<BookModel> GetAllBooks(string skip, string top)
{
var cache = HttpContext.Current.Cache["allBooks"];
var model = new BookModel();
List<BookModel> listAllBooks = new List<BookModel>();
if (cache == null)
{
GetApiResponse<BookModel> apiModelBook= new GetApiResponse<BookModel>();
listAllBooks = apiModelBook.GetAllBooksFromDb("api/APIDbBook?");
BookCount = listAllBooks.Count;
if (top=="0")
{
listAllBooks = apiModelBook.GetAllBooksFromDb("api/APIDbBook?");
}
else
{
listAllBooks = apiModelBook.GetAllBooksFromDb("api/APIDbBook?$skip=" + skip + "&$top=" + top );
}
cache = listAllBooks;
}
else
{
listAllBooks = cache as List<BookModel>;
}
return listAllBooks;
}
public List<Team> FillTeams(Team homeTeam, Team awayTeam)
{
List<Team> teams = new List<Team>();
teams.Add(homeTeam);
teams.Add(awayTeam);
return teams;
}
public List<Item> ItemsGridview(string name)
{
var griditems = new List<Item>();
Item item = null;
using (var db = new Database())
{
db.OpenConnection();
db.CreateCommand(
"SELECT Item.*, Quality.Name AS Quality FROM Item, Quality WHERE Item.Quality_ID=Quality.Quality_ID AND Item.Name LIKE @name");
db.AddParameter("@name", "%" + name + "%");
MySqlDataReader dr = db.Command.ExecuteReader();
while (dr.Read())
{
item = new Item();
item.Name = (string)dr["name"];
item.Level = (int)dr["level"];
item.ReqLevel = (int)dr["Reqlevel"];
item.Quality = (string)dr["Quality"];
griditems.Add(item);
}
}
return griditems;
}
/// <summary>
/// Constructor with user's way keeping
/// </summary>
/// <param name="repository">Object describing storage kind</param>
public BookList(IRepository repository)
{
if (repository == null)
throw new ArgumentNullException("Repository is undefined");
books = new List<Book>();
this.repository = repository;
}
/// <summary>
/// Builds the bet team.
/// </summary>
/// <param name="ticket">The ticket.</param>
/// <param name="ticketHelper">The ticket helper.</param>
/// <param name="ticketData">The ticket data.</param>
protected override void BuildBetTeam(ITicket ticket, ITicketHelper ticketHelper, List<ITicketData> ticketData)
{
string choice = ticket.BetTeam;
var betTeam = string.Empty;
switch (choice)
{
case "01":
betTeam = "4 " + CoreBetList.points;
break;
case "02":
betTeam = "5 " + CoreBetList.points;
break;
case "03":
betTeam = "6 " + CoreBetList.points;
break;
case "04":
betTeam = "7 " + CoreBetList.upPoints;
break;
}
// " " because export format
Template.betTeam = HtmlCharacters.NoneBreakingSpace + betTeam;
}
// Get all categories of products
public List<Category> GetCategory()
{
try
{
List<Category> ListOfCategory = new List<Category>();
connect = new Connection().Connect;
connect.Open();
Command = new SqlCommand("sp_getAllCategory", connect);
Command.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader dr = Command.ExecuteReader();
while (dr.Read())
{
Category objCategory = new Category();
objCategory.CategoryID = dr.GetInt32(0);
objCategory.CategoryName = dr.GetString(1);
ListOfCategory.Add(objCategory);
}
connect.Close();
return ListOfCategory;
}
catch (Exception)
{
connect.Close();
return null;
}
}
/// <summary>
/// Builds the bet team.
/// </summary>
/// <param name="ticket">The ticket.</param>
/// <param name="ticketHelper">The ticket helper.</param>
/// <param name="ticketData">The ticket data.</param>
protected override void BuildBetTeam(ITicket ticket, ITicketHelper ticketHelper, List<ITicketData> ticketData)
{
bool betHome = IsBetHome(ticket);
bool betAway = IsBetAway(ticket);
if (betHome)
{
Template.betTeam = Template.Match.homeTeam;
}
else if (betAway)
{
Template.betTeam = Template.Match.awayTeam;
}
else
{
if (ticket.Handicap2 > ticket.Handicap1)
{
Template.betTeam = string.Join(null, new string[] { CoreBetList.lblDraw, " (", CoreBetList.h, "+", ConvertByBetType.Hdp(ticket.Handicap2) + ")" });
}
else
{
Template.betTeam = string.Join(null, new string[] { CoreBetList.lblDraw, " (", CoreBetList.a, "+", ConvertByBetType.Hdp(ticket.Handicap1), ")" });
}
}
}
#pragma warning disable 1587
/// <summary>
/// Set bet team to template by ticket bet team pattern with following rules:
/// <para>ho: Home and Over, hu: Home and Under</para>
/// <para>ao: Away and Over, au: Away and Under</para>
/// <para>do: Draw and Over, du: Draw and Over</para>
/// </summary>
/// <param name="ticket"> Ticket with bet type id is 143.</param>
/// <param name="ticketHelper"> Not null ticket helper.</param>
/// <param name="ticketData"> Not need this.</param>
#pragma warning restore 1587
protected override void BuildBetTeam(ITicket ticket, ITicketHelper ticketHelper, List<ITicketData> ticketData)
{
var teamName = string.Empty;
// Bet team pattern length is always 2
if (ticket.BetTeam.Length == 2)
{
switch (ticket.BetTeam[0])
{
case 'h':
teamName = ticketHelper.GetTeamNameById(ticket.HomeId);
break;
case 'a':
teamName = ticketHelper.GetTeamNameById(ticket.AwayId);
break;
case 'd':
teamName = CoreBetList.draw;
break;
}
var resultOverUnder = (ticket.BetTeam[1].ToString(CultureInfo.InvariantCulture) == BetTeamValue.O)
? CoreBetList.over
: CoreBetList.under;
Template.betTeam = string.Join(" & ", new string[] { teamName, resultOverUnder });
}
}
/// <summary>
/// Creates the bonuses, obstacles and power ups contained in a level.
/// </summary>
/// <param name="interactiveEntityDescriptions">A list of interactive entity descriptions.</param>
/// <param name="physicsWorld">The physics world to create the entities in.</param>
/// <param name="interactiveEntities">An empty list to store the interactive entities in.</param>
/// <param name="mineCart">The mine cart entity.</param>
/// <param name="cartSwitch">The switch entity.</param>
/// <param name="spriteBatch">The sprite batch to use for rendering.</param>
/// <param name="contentManager">The game's content manager.</param>
public static void CreateInteractiveEntities(List<InteractiveEntityDescription> interactiveEntityDescriptions, ref World physicsWorld, ref List<InteractiveEntity> interactiveEntities, ref MineCart mineCart, ref Switch cartSwitch, SpriteBatch spriteBatch, ContentManager contentManager)
{
if (interactiveEntities.Count == 0)
{
foreach (InteractiveEntityDescription description in interactiveEntityDescriptions)
{
if (EntityConstants.PowerUpNames.Contains(description.Name))
{
interactiveEntities.Add(new PowerUp(ref physicsWorld, spriteBatch, contentManager, description, EntitySettingsLoader.GetPowerUpSettings(description.Name)));
}
else if (EntityConstants.BonusNames.Contains(description.Name) || EntityConstants.ObstacleNames.Contains(description.Name))
{
interactiveEntities.Add(new BonusOrObstacle(ref physicsWorld, spriteBatch, contentManager, description, EntitySettingsLoader.GetObstacleOrBonusSetting(description.Name)));
}
else if (description.Name == EntityConstants.CartBody)
{
mineCart = new MineCart(spriteBatch, contentManager, ref physicsWorld, description.Position, 100.0f, 240.0f, 350.0f, 80.0f, -80.0f);
}
else if (description.Name == EntityConstants.Switch)
{
cartSwitch = new Switch(spriteBatch, contentManager, ref physicsWorld, description.Position, mineCart);
}
}
}
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from ZoneBinRelation a where ");
ZoneBinRelation zoneRel = (ZoneBinRelation)data;
if ( zoneRel != null)
{
Parms = new List<Object[]>();
if ( zoneRel.Zone != null && zoneRel.Zone.ZoneID != 0 )
{
sql.Append(" a.Zone.ZoneID = :id and ");
Parms.Add(new Object[] { "id", zoneRel.Zone.ZoneID });
}
if (zoneRel.Bin != null && zoneRel.Bin.BinID != 0)
{
sql.Append(" a.Bin.BinID = :id1 and ");
Parms.Add(new Object[] { "id1", zoneRel.Bin.BinID });
}
if (zoneRel.BinType != 0)
{
sql.Append(" a.BinType = :id2 and ");
Parms.Add(new Object[] { "id2", zoneRel.BinType });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.Rank asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return query;
}
public Order(int id, string customerid, int employeeid, DateTime orderdate, DateTime requireddate,
DateTime shippeddate, int shipvia, double freight, string shipname, string shipaddress, string shipcity,
string shiparegion, string shippostalcode, string shipcountry, List<OrderDetails> details)
{
ID = id;
CustomerID = customerid;
EmployeeID = employeeid;
OrderDate = orderdate;
RequiredDate = requireddate;
ShippedDate = shippeddate;
ShipVia = shipvia;
Freight = freight;
ShipName = shipname;
ShipAddress = shipaddress;
ShipCity = shipcity;
ShipRegion = shiparegion;
ShipPostalCode = shippostalcode;
ShipCountry = shipcountry;
Details = details;
if (orderdate.Equals(DateTime.MinValue))
Status = OrderStatus.NEW;
else if (ShippedDate.Equals(DateTime.MinValue))
Status = OrderStatus.NOTSHIPPED;
else
Status = OrderStatus.SHIPPED;
}
