protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
WebApiConfig.Register(GlobalConfiguration.Configuration);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
//allow viewing json in the browser by default
GlobalConfiguration.Configuration.Formatters[0].SupportedMediaTypes.Add(new MediaTypeHeaderValue("text/html"));
var data= new programs();
var connstr = @"mongodb://*****:*****@ds035607.mongolab.com:35607/revolentdata";
var client = new MongoDB.Driver.MongoClient(connstr);
var server = client.GetServer();
var db = server.GetDatabase("revolentdata");
var coll = db.GetCollection<programsProgram>("movies");
var cursor = coll.FindAll();
data.program = cursor.ToList().ToArray();
Application["data"] = data;
//factual api info
Application["factkey"] = "UVz7N3cX8wHDYon4dHoVfmj8kzYL3sDVJ2SXn8Dl";
Application["factsec"] = "Ok2lXgEde7JazbsbZBMSJ5bYmH0wbTLycB13TUZW";
}
public void Eliminar(int id)
{
programs oProgram = new programs
{
program_id = id,
};
oRepositorio.Delete(oProgram);
oUnitOfWork.SaveChanges();
}
public void Modificar(ProgramViewModel pProgramViewModel)
{
programs oprograms = oRepositorio.FindById(pProgramViewModel.program_id);
oprograms.name = pProgramViewModel.name;
oprograms.user_id_modified = pProgramViewModel.user_id_modified;
oprograms.date_modified = DateTime.Now;
oRepositorio.Update(oprograms);
oUnitOfWork.SaveChanges();
}
public void Agregar(ProgramViewModel pProgramViewModel)
{
programs oprograms = new programs
{
program_id = 0,
name = pProgramViewModel.name,
date_created = DateTime.Now,
user_id_created = pProgramViewModel.user_id_created
};
oRepositorio.Add(oprograms);
oUnitOfWork.SaveChanges();
}
public async Task <IActionResult> Create(programs data)
{
try
{
_context.programs.Add(data);
data.isactive = true;
await _context.SaveChangesAsync(_session.Id);
return(MessageBox.Show(MessageType.Success));
}
catch (Exception e)
{
return(MessageBox.Show(MessageType.Error));
}
}
public void Add()
{
if (Name == null || Site == null || PlatformsID <= 0)
{
return;
}
mydbContext mydb = new mydbContext();
platforms platform = mydb.platforms.Single(el => el.id == PlatformsID);
programs prog = new programs
{
name = Name,
off_site = Site,
platforms = platform
};
mydb.programs.Add(prog);
mydb.SaveChanges();
}
public async Task <IActionResult> Edit(programs data)
{
try
{
if (ModelState.IsValid)
{
_context.programs.Update(data);
await _context.SaveChangesAsync(_session.Id);
return(MessageBox.Show(MessageType.Success));
}
else
{
return(MessageBox.Show(MessageType.NotValid));
}
}
catch (Exception e)
{
return(MessageBox.Show(MessageType.Error));
}
}
public void Add(DataGridViewSelectedRowCollection CategorsSelected)
{
mydbContext mydb = new mydbContext();
programs prog = mydb.programs
.OrderByDescending(el => el.id)
.First();
foreach (DataGridViewRow item in CategorsSelected)
{
int idCategory = int.Parse(item.Cells[0].Value.ToString());
categories category = mydb.categories.Single(el => el.id == idCategory);
program_categories program_Categories = new program_categories
{
programs = prog,
categories = category
};
mydb.program_categories.Add(program_Categories);
}
mydb.SaveChanges();
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
programs ds = new programs();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "commandsDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
programs ds = new programs();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
public int Delete(programs existingprograms)
{
return(AllocateRepo().Delete(existingprograms));
}
public int Update(programs existingprograms)
{
return(AllocateRepo().Update(existingprograms));
}
public long Create(programs newprograms)
{
return(AllocateRepo().Create(newprograms));
}
private void button8_Click(object sender, EventArgs e)
{
programs dialog = new programs();
dialog.Show();
}
