public async Task <POJO> DeleteAsync(int?Id)
{
POJO model = new POJO();
Student _Student = await GetStudent(Id);
if (_Student != null)
{
try
{
_db.Students.Remove(_Student);
await _db.SaveChangesAsync();
//Msg
model.Flag = true;
model.Message = "Has been Deleted.";
}
catch (Exception ex)
{
model.Flag = false;
model.Message = ex.ToString();
}
}
else
{
model.Flag = false;
model.Message = "Student does not exist.";
}
return(model);
}
public async Task AddPet(POJO pOJO)
{
try
{
var breed = await _context.BreedTypes.FirstOrDefaultAsync(x => x.Name.ToLower() == pOJO.BreedName.ToLower());
if (breed != null)
{
await InsertPet(pOJO, breed.IdBreedType);
}
else
{
breed = await InsertBreed(pOJO);
if (breed != null)
{
await InsertPet(pOJO, breed.IdBreedType);
}
}
}
catch (Exception ex)
{
throw new RecordCanNotBeInserted("There is some issues while inserting the database");
}
}
private async Task <BreedType> InsertBreed(POJO pOJO)
{
var breed = await _context.BreedTypes.AddAsync(new BreedType { Name = pOJO.Name, Description = "" });
await _context.SaveChangesAsync();
return(breed.Entity);
}
private async void MainPage_OnLoaded(object sender, RoutedEventArgs e)
{
List <POJO.RootObject> dateYoutube = await POJO.GetYoutube();
for (int i = 0; i < dateYoutube.Count; i++)
{
list.Add(dateYoutube[i]);
}
GridViewShow.ItemsSource = list;
}
public async Task <POJO> Save(Film film)
{
POJO model = new POJO();
if (film.FilmId == 0)
{
try
{
film.CreateDate = DateTime.Now;
await _db.AddAsync(film);
await _db.SaveChangesAsync();
model.Id = film.FilmId;
model.Flag = true;
model.Message = "Has Been Added.";
}
catch (Exception ex)
{
model.Flag = false;
model.Message = ex.ToString();
}
}
else if (film.FilmId != 0)
{
Film _Entity = await GetFilm(film.FilmId);
_Entity.FilmId = film.FilmId;
_Entity.FilmName = film.FilmName;
_Entity.FilmImage = film.FilmImage;
_Entity.FilmTypeId = film.FilmTypeId;
_Entity.Episode = film.Episode;
_Entity.ReleaseDate = film.ReleaseDate;
_Entity.Story = film.Story;
_Entity.FilmStatus = film.FilmStatus;
_Entity.ModifiedDate = DateTime.Now;
try
{
await _db.SaveChangesAsync();
model.Id = film.FilmId;
model.Flag = true;
model.Message = "Has Been Updated.";
}
catch (Exception ex)
{
model.Flag = false;
model.Message = ex.ToString();
}
}
return(model);
}
public async Task <IActionResult> DeleteFilm(int?Id)
{
if (Id == null)
{
return(BadRequest());
}
POJO model = await _Film.DeleteAsync(Id);
if (model == null)
{
return(NotFound());
}
return(Ok());
}
public async Task <IActionResult> Save([FromBody] Film _film)
{
if (_film == null)
{
return(BadRequest());
}
POJO model = await _Film.Save(_film);
if (model == null)
{
return(NotFound());
}
return(Ok(_film));
}
public async Task <POJO> Save(Student _Student)
{
POJO model = new POJO();
//Add if StudentId=0
if (_Student.Id == 0)
{
try
{
await _db.AddAsync(_Student);
await _db.SaveChangesAsync();
model.Id = _Student.Id;
model.Flag = true;
model.Message = "Has Been Added.";
}
catch (Exception ex)
{
model.Flag = false;
model.Message = ex.ToString();
}
}
//else if Student Id is not 0
else if (_Student.Id != 0)
{
Student _Entity = await GetStudent(_Student.Id);
_Entity.Id = _Student.Id;
_Entity.FirstName = _Student.FirstName;
_Entity.LastName = _Student.LastName;
_Entity.Gender = _Student.Gender;
try
{
await _db.SaveChangesAsync();
model.Id = _Student.Id;
model.Flag = true;
model.Message = "Has Been Updated.";
}
catch (Exception ex)
{
model.Flag = false;
model.Message = ex.ToString();
}
}
return(model);
}
public async Task <IActionResult> Delete(int?id)
{
if (id == null)
{
return(BadRequest());
}
POJO model = await _Student.DeleteAsync(id);
if (model == null)
{
return(NotFound());
}
return(Ok(model));
}
public async Task <IActionResult> Save([FromBody] Student _student)
{
if (_student == null)
{
return(BadRequest());
}
POJO model = await _Student.Save(_student);
if (model == null)
{
return(NotFound());
}
return(Ok(model));
}
private async Task <Pet> InsertPet(POJO pOJO, int breedType)
{
var pet = await _context.Pets.AddAsync(new Pet
{
Name = pOJO.Name,
IdBreedType = breedType,
ApprocimateDateOfBirth = pOJO.ApprocimatedDateOfBirth,
DateRegistered = pOJO.DateRegistered,
IsMale = pOJO.IsMale
});
var volunterrPet = await _context.VolunteerPets.AddAsync(new VolunteerPet { IdPet = pet.Entity.IdPet, DateAccepted = DateTime.Now, IdVolunteer = 1 });
await _context.SaveChangesAsync();
return(pet.Entity);
}
public async Task <IActionResult> AddPet([FromBody] POJO data)
{
try
{
await _dbService.AddPet(data);
return(Ok());
}
catch (RecordCanNotBeInserted ex)
{
return(BadRequest(ex.Message));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
void TransformCode(TreeNode Node, ToolStripMenuItem menu)
{
if (Node.ToolTipText != ENodeType.DbTable.ToString())
{
return;
}
var columns = DB.GetDbColumns(Node.Parent.Tag.ToString(), ((DbTable)Node.Tag).TableName);
var tableName = ((DbTable)Node.Tag).TableName;
var package = "com.cnblogs.lzrabbit";
var ns = "com.cnblogs.lzrabbit";
T4Base t4;
string str = this.menuCode.DropDownItems.Cast <ToolStripMenuItem>().Single(item => item.Checked).Text;
switch (menu.Text)
{
case "POCO":
t4 = new POCO
{
Package = package,
Namespace = ns,
DbColumns = columns,
TableName = tableName,
};
break;
case "POJO":
t4 = new POJO
{
Package = package,
Namespace = ns,
DbColumns = columns,
TableName = tableName,
};
break;
case "MyBatis":
if (DB.DbType == EDbType.MySql)
{
t4 = new MyBatis_MySQL
{
Package = package,
Namespace = ns,
DbColumns = columns,
TableName = tableName,
}
}
;
else
{
t4 = new MyBatis_SQLServer
{
Package = package,
Namespace = ns,
DbColumns = columns,
TableName = tableName,
}
};
break;
default:
t4 = new POCO
{
Package = package,
Namespace = ns,
DbColumns = columns,
TableName = tableName,
};
break;
}
this.txtCode.Text = t4.TransformText();
}
