public Magazine GetMagazine(int id)
{
Magazine magazine = null;
SqlConnection connection = new SqlConnection(ConnectionString);
connection.Open();
SqlCommand command = new SqlCommand("select * from magazine", connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (id == Convert.ToInt32(reader["id"]))
{
MagazineType type = Magazine.getmagazine(reader["type"].ToString().Trim());
magazine = new Magazine(type, reader["issue"].ToString(), reader["name"].ToString(), Convert.ToInt32(reader["id"]), Convert.ToDouble(reader["price"]), reader["picture"].ToString());
magazine.Id = Convert.ToInt32(reader["id"]);
if (magazine.Id > Product.Idcount)
{
Product.Idcount = magazine.Id;
}
}
}
connection.Close();
return(magazine);
}
public override void ExposeData(ObjectSerializer serializer)
{
base.ExposeData(serializer);
serializer.DataReadWriteFunction(
"magazineTypes",
new List <MagazineType>(),
types => types.ForEach(mag => _magazineTypes |= mag),
() =>
{
var types = new List <MagazineType>();
foreach (MagazineType mag in Enum.GetValues(typeof(MagazineType)))
{
if ((_magazineTypes & mag) != 0)
{
types.Add(mag);
}
}
return(types);
});
serializer.DataField(ref _caliber, "caliber", BallisticCaliber.Unspecified);
serializer.DataField(ref _magFillPrototype, "magFillPrototype", null);
serializer.DataField(ref _autoEjectMag, "autoEjectMag", false);
serializer.DataField(ref _magNeedsOpenBolt, "magNeedsOpenBolt", false);
serializer.DataField(ref _soundBoltOpen, "soundBoltOpen", null);
serializer.DataField(ref _soundBoltClosed, "soundBoltClosed", null);
serializer.DataField(ref _soundRack, "soundRack", null);
serializer.DataField(ref _soundMagInsert, "soundMagInsert", null);
serializer.DataField(ref _soundMagEject, "soundMagEject", null);
serializer.DataField(ref _soundAutoEject, "soundAutoEject", "/Audio/Weapons/Guns/EmptyAlarm/smg_empty_alarm.ogg");
}
public static MagazineType GetMagazineType(string Mtype)
{
MagazineType magazineType = new MagazineType();
switch (Mtype)
{
case "Gaming":
magazineType = MagazineType.Gaming;
break;
case "History":
magazineType = MagazineType.History;
break;
case "News":
magazineType = MagazineType.News;
break;
case "Computer":
magazineType = MagazineType.Computer;
break;
case "Geography":
magazineType = MagazineType.Geography;
break;
case "Actual":
magazineType = MagazineType.Actual;
break;
}
return(magazineType);
}
private void btnAddMagazine_Click(object sender, EventArgs e)
{
MagazineType type = Magazine.getmagazine(cmbMagazineTypes.SelectedItem.ToString());
adminUser.addNewMagazine(type, txtMagazineIssue.Text, txtMagazineName.Text, Product.Idcount, Convert.ToDouble(txtMagazinePrice.Text.Trim()), txtMagazineName.Text.Trim() + ".jpg");
DataTable dataTable = new DataTable();
DataTable = data.datagrid(dataTable, "magazine");
dtgMagazine.DataSource = DataTable;
}
public void addNewMagazine(MagazineType type, string issue, String name, int id, double price, String picture)
{
Magazine magazine = (Magazine)ProductFactory.CreateProduct(ProductNames.Magazine, name, id, price, picture, issue);
if (magazine is Magazine)
{
magazine.Type = type;
}
data.addMagazine(magazine);
}
public Magazine addNewMagazine(MagazineType type, string issue, String name, int id, double price)
{
Magazine magazine = (Magazine)ProductFactory.CreateProduct(ProductName.Magazine, name, id, price);
if (magazine is Magazine)
{
magazine.Type = type;
magazine.Issue = issue;
}
return(magazine);
}
public static MagazineType GetMagazineType(string Mtype)
{
MagazineType magazineType = new MagazineType();
switch (Mtype)
{
case "Gündem":
magazineType = MagazineType.Gündem;
break;
case "Haber":
magazineType = MagazineType.Haber;
break;
case "Spor":
magazineType = MagazineType.Spor;
break;
case "Bilişim":
magazineType = MagazineType.Bilişim;
break;
case "Teknoloji":
magazineType = MagazineType.Teknoloji;
break;
case "Siyaset":
magazineType = MagazineType.Siyaset;
break;
case "Bilim":
magazineType = MagazineType.Bilim;
break;
case "Tarih":
magazineType = MagazineType.Tarih;
break;
case "Yemek":
magazineType = MagazineType.Yemek;
break;
default:
magazineType = MagazineType.Gündem;
break;
}
return(magazineType);
}
public static string GetStringShortNameFromMagazineType(MagazineType magazineType)
{
switch (magazineType)
{
case MagazineType.NewsGoVn:
return("NewsGoVn");
case MagazineType.VnExpressNet:
return("VnExpressNet");
case MagazineType.DanTriComVn:
return("DanTriComVn");
case MagazineType.Hcm24hComVn:
return("Hcm24hComVn");
case MagazineType.BaoMoiCom:
return("BaoMoiCom");
case MagazineType.VietnamNetVn:
return("VietnamNetVn");
case MagazineType.LaoDongComVn:
return("LaoDongComVn");
case MagazineType.TuoiTreVn:
return("TuoiTreVn");
case MagazineType.TienPhongVn:
return("TienPhongVn");
case MagazineType.NewsZingVn:
return("NewsZingVn");
case MagazineType.NgoiSaoNet:
return("NgoiSaoNet");
case MagazineType.Kenh14Vn:
return("Kenh14Vn");
default:
return(string.Empty);
}
}
public static string GetStringNameFromMagazineType(MagazineType magazineType)
{
switch (magazineType)
{
case MagazineType.NewsGoVn:
return("Go News");
case MagazineType.VnExpressNet:
return("Vnexpress");
case MagazineType.DanTriComVn:
return("Dân Trí");
case MagazineType.Hcm24hComVn:
return("24h");
case MagazineType.BaoMoiCom:
return("Báo Mới");
case MagazineType.VietnamNetVn:
return("Vietnamnet");
case MagazineType.LaoDongComVn:
return("Lao Động");
case MagazineType.TuoiTreVn:
return("Tuổi Trẻ");
case MagazineType.TienPhongVn:
return("Tiền Phong");
case MagazineType.NewsZingVn:
return("Zing News");
case MagazineType.NgoiSaoNet:
return("Ngôi Sao");
case MagazineType.Kenh14Vn:
return("Mương 14");
default:
return(string.Empty);
}
}
public override void ExposeData(ObjectSerializer serializer)
{
base.ExposeData(serializer);
if (serializer.Reading)
{
var magTypes = serializer.ReadDataField("magazineTypes", new List <MagazineType>());
foreach (var mag in magTypes)
{
_magazineTypes |= mag;
}
}
serializer.DataField(ref _caliber, "caliber", BallisticCaliber.Unspecified);
serializer.DataField(ref _autoEjectMag, "autoEjectMag", false);
serializer.DataField(ref _magNeedsOpenBolt, "magNeedsOpenBolt", false);
serializer.DataField(ref _soundBoltOpen, "soundBoltOpen", null);
serializer.DataField(ref _soundBoltClosed, "soundBoltClosed", null);
serializer.DataField(ref _soundRack, "soundRack", null);
serializer.DataField(ref _soundMagInsert, "soundMagInsert", null);
serializer.DataField(ref _soundMagEject, "soundMagEject", null);
serializer.DataField(ref _soundAutoEject, "soundAutoEject", "/Audio/Guns/EmptyAlarm/smg_empty_alarm.ogg");
}
public Magazine(MagazineType type, string issue, String name, int id, double price) : base(name, id, price)
{
this.Issue = issue;
this.Type = type;
}
public SampleDataSource(MagazineType magazineType)
{
switch (magazineType)
{
case MagazineType.NewsGoVn:
Init_NewsGoVn();
break;
case MagazineType.VnExpressNet:
break;
case MagazineType.DanTriComVn:
break;
case MagazineType.Hcm24hComVn:
break;
case MagazineType.BaoMoiCom:
break;
case MagazineType.VietnamNetVn:
break;
case MagazineType.LaoDongComVn:
break;
case MagazineType.TuoiTreVn:
break;
case MagazineType.TienPhongVn:
break;
case MagazineType.NewsZingVn:
break;
case MagazineType.NgoiSaoNet:
break;
case MagazineType.Kenh14Vn:
break;
default:
break;
}
/*
String ITEM_CONTENT = String.Format("Item Content: {0}\n\n{0}\n\n{0}\n\n{0}\n\n{0}\n\n{0}\n\n{0}",
"Curabitur class aliquam vestibulum nam curae maecenas sed integer cras phasellus suspendisse quisque donec dis praesent accumsan bibendum pellentesque condimentum adipiscing etiam consequat vivamus dictumst aliquam duis convallis scelerisque est parturient ullamcorper aliquet fusce suspendisse nunc hac eleifend amet blandit facilisi condimentum commodo scelerisque faucibus aenean ullamcorper ante mauris dignissim consectetuer nullam lorem vestibulum habitant conubia elementum pellentesque morbi facilisis arcu sollicitudin diam cubilia aptent vestibulum auctor eget dapibus pellentesque inceptos leo egestas interdum nulla consectetuer suspendisse adipiscing pellentesque proin lobortis sollicitudin augue elit mus congue fermentum parturient fringilla euismod feugiat");
for (int g = 1; g < 8; g++)
{
var group = new DataGroup(string.Format("Group-{0}", g.ToString()),
string.Format("Group Title: {0}", g.ToString()),
string.Format("Group Subtitle: {0}", g.ToString()),
"http://1anh.com/500/Z6RKdtZWuK5Ns7Ucjof7iqK-wvKbZvdhI-dbwzJMU_yPIxtF7ROLSCzmk84MSzhuFSBO1IN6OubwU7sI4AYW2w/",
"Group Description: Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus tempor scelerisque lorem in vehicula. Aliquam tincidunt, lacus ut sagittis tristique, turpis massa volutpat augue, eu rutrum ligula ante a ante");
for (int i = 1; i < 10; i++)
{
group.Items.Add(new DataItem(string.Format("Group-{0}-Item-{1}", g.ToString(), i.ToString()),
string.Format("Item Title: {0}", i.ToString()),
string.Format("Item Subtitle: {0}", i.ToString()),
"http://farm10.gox.vn/tinmoi/store/images/thumb/07062013/104/1352811/iphone_gia_re_se_co_5_mau_sac_khac_nhau_cung_thiet_ke_giong_iphone_5_0.jpg",
"Item Description: Pellentesque porta, mauris quis interdum vehicula, urna sapien ultrices velit, nec venenatis dui odio in augue. Cras posuere, enim a cursus convallis, neque turpis malesuada erat, ut adipiscing neque tortor ac erat.",
ITEM_CONTENT,
group));
}
group.HeaderClickCommand = ViewModel.ViewModelLocator.Current.GroupedItems.HeaderClickCommand;
group.index = g - 1;
this.ItemGroups.Add(group);
}
*/
}
public Magazine(string spritePrefabName, MagazineType type, Properties properties)
: base(spritePrefabName, "Prefabs/Weapons/Weapon Parts/Magazines/", properties)
{
this.type = type;
}
public Magazine(MagazineType type, string issue, String name, int id, double price, String picture) : base(name, id, price, picture, issue)
{
this.Type = type;
}
public static string GetStringNameFromMagazineType(MagazineType magazineType)
{
switch (magazineType)
{
case MagazineType.NewsGoVn:
return "Go News";
case MagazineType.VnExpressNet:
return "Vnexpress";
case MagazineType.DanTriComVn:
return "Dân Trí";
case MagazineType.Hcm24hComVn:
return "24h";
case MagazineType.BaoMoiCom:
return "Báo Mới";
case MagazineType.VietnamNetVn:
return "Vietnamnet";
case MagazineType.LaoDongComVn:
return "Lao Động";
case MagazineType.TuoiTreVn:
return "Tuổi Trẻ";
case MagazineType.TienPhongVn:
return "Tiền Phong";
case MagazineType.NewsZingVn:
return "Zing News";
case MagazineType.NgoiSaoNet:
return "Ngôi Sao";
case MagazineType.Kenh14Vn:
return "Mương 14";
default:
return string.Empty;
}
}
public SampleDataSource(MagazineType magazineType)
{
switch (magazineType)
{
case MagazineType.NewsGoVn:
Init_NewsGoVn();
break;
case MagazineType.VnExpressNet:
break;
case MagazineType.DanTriComVn:
break;
case MagazineType.Hcm24hComVn:
break;
case MagazineType.BaoMoiCom:
break;
case MagazineType.VietnamNetVn:
break;
case MagazineType.LaoDongComVn:
break;
case MagazineType.TuoiTreVn:
break;
case MagazineType.TienPhongVn:
break;
case MagazineType.NewsZingVn:
break;
case MagazineType.NgoiSaoNet:
break;
case MagazineType.Kenh14Vn:
break;
default:
break;
}
/*
* String ITEM_CONTENT = String.Format("Item Content: {0}\n\n{0}\n\n{0}\n\n{0}\n\n{0}\n\n{0}\n\n{0}",
* "Curabitur class aliquam vestibulum nam curae maecenas sed integer cras phasellus suspendisse quisque donec dis praesent accumsan bibendum pellentesque condimentum adipiscing etiam consequat vivamus dictumst aliquam duis convallis scelerisque est parturient ullamcorper aliquet fusce suspendisse nunc hac eleifend amet blandit facilisi condimentum commodo scelerisque faucibus aenean ullamcorper ante mauris dignissim consectetuer nullam lorem vestibulum habitant conubia elementum pellentesque morbi facilisis arcu sollicitudin diam cubilia aptent vestibulum auctor eget dapibus pellentesque inceptos leo egestas interdum nulla consectetuer suspendisse adipiscing pellentesque proin lobortis sollicitudin augue elit mus congue fermentum parturient fringilla euismod feugiat");
* for (int g = 1; g < 8; g++)
* {
* var group = new DataGroup(string.Format("Group-{0}", g.ToString()),
* string.Format("Group Title: {0}", g.ToString()),
* string.Format("Group Subtitle: {0}", g.ToString()),
* "http://1anh.com/500/Z6RKdtZWuK5Ns7Ucjof7iqK-wvKbZvdhI-dbwzJMU_yPIxtF7ROLSCzmk84MSzhuFSBO1IN6OubwU7sI4AYW2w/",
* "Group Description: Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus tempor scelerisque lorem in vehicula. Aliquam tincidunt, lacus ut sagittis tristique, turpis massa volutpat augue, eu rutrum ligula ante a ante");
*
* for (int i = 1; i < 10; i++)
* {
* group.Items.Add(new DataItem(string.Format("Group-{0}-Item-{1}", g.ToString(), i.ToString()),
* string.Format("Item Title: {0}", i.ToString()),
* string.Format("Item Subtitle: {0}", i.ToString()),
* "http://farm10.gox.vn/tinmoi/store/images/thumb/07062013/104/1352811/iphone_gia_re_se_co_5_mau_sac_khac_nhau_cung_thiet_ke_giong_iphone_5_0.jpg",
* "Item Description: Pellentesque porta, mauris quis interdum vehicula, urna sapien ultrices velit, nec venenatis dui odio in augue. Cras posuere, enim a cursus convallis, neque turpis malesuada erat, ut adipiscing neque tortor ac erat.",
* ITEM_CONTENT,
* group));
* }
*
* group.HeaderClickCommand = ViewModel.ViewModelLocator.Current.GroupedItems.HeaderClickCommand;
* group.index = g - 1;
* this.ItemGroups.Add(group);
* }
*/
}
public static string GetStringShortNameFromMagazineType(MagazineType magazineType)
{
switch (magazineType)
{
case MagazineType.NewsGoVn:
return "NewsGoVn";
case MagazineType.VnExpressNet:
return "VnExpressNet";
case MagazineType.DanTriComVn:
return "DanTriComVn";
case MagazineType.Hcm24hComVn:
return "Hcm24hComVn";
case MagazineType.BaoMoiCom:
return "BaoMoiCom";
case MagazineType.VietnamNetVn:
return "VietnamNetVn";
case MagazineType.LaoDongComVn:
return "LaoDongComVn";
case MagazineType.TuoiTreVn:
return "TuoiTreVn";
case MagazineType.TienPhongVn:
return "TienPhongVn";
case MagazineType.NewsZingVn:
return "NewsZingVn";
case MagazineType.NgoiSaoNet:
return "NgoiSaoNet";
case MagazineType.Kenh14Vn:
return "Kenh14Vn";
default:
return string.Empty;
}
}
