public void FillList()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString()))
{
SqlCommand query = new SqlCommand(@"exec Get_AllRecepts", conn);
conn.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(query);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
if (Recepies == null)
{
Recepies = new ObservableCollection <Recept>();
}
foreach (DataRow row in dataTable.Rows)
{
Recept r = new Recept
{
ReceptId = int.Parse(row[0].ToString()),
UserId = int.Parse(row[1].ToString()),
TypeId = int.Parse(row[2].ToString()),
ReceptName = row[3].ToString(),
PersonNumber = int.Parse(row[4].ToString()),
Author = row[5].ToString(),
ReceptText = row[6].ToString(),
CreationDate = DateTime.Parse(row[7].ToString()),
ReceptType = row[9].ToString(),
};
if (LoginWindow.CurrentUser.UserId == r.UserId)
{
r.CanEdit = true;
}
if (LoginWindow.CurrentUser.Username == "Admin")
{
r.CanEdit = true;
r.CanDelete = true;
}
using (SqlConnection conn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString()))
{
SqlCommand query1 = new SqlCommand(@"exec Get_AllReceptsComponentsNumber @ReceptID = @Id;", conn1);
query1.Parameters.AddWithValue("@Id", r.ReceptId);
conn1.Open();
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(query1);
DataTable dataTable1 = new DataTable();
sqlDataAdapter1.Fill(dataTable1);
foreach (DataRow row1 in dataTable1.Rows)
{
r.ComponentsNumber = int.Parse(row1[0].ToString());
}
}
Recepies.Add(r);
}
}
}
public RecepiesDetail(int recepieId)
{
InitializeComponent();
IngredientsColection = new ObservableCollection <Ingredient>();
PreparationStepsColection = new ObservableCollection <PreparationStep>();
Recepieses = new Recepies();
GetRecepieDetail(recepieId);
}
public EditRecepiePage(int recepieId)
{
InitializeComponent();
Iingredients = new List <Ingredient>();
PreparationSteps = new List <PreparationStep>();
Recepieses = new Recepies();
GetRecepieDetail(recepieId);
}
public PRDChemProdReq GetRequisitionDetailsAfterSearch(int _RequisitionID)
{
var model = new PRDChemProdReq();
var RequisitionInfo = (from r in _context.PRD_ChemProdReq.AsEnumerable()
where r.RequisitionID == _RequisitionID
join re in _context.PRD_Recipe on(r == null?null:r.RecipeID) equals re.RecipeID into Recepies
from re in Recepies.DefaultIfEmpty()
join c in _context.Sys_Color on(re == null? null: re.ArticleColor) equals c.ColorID into Colors
from c in Colors.DefaultIfEmpty()
join u in _context.Sys_Unit on(re == null ? 0 : re.BaseUnit) equals u.UnitID into Units
from u in Units.DefaultIfEmpty()
select new PRDChemProdReq
{
RequisitionID = r.RequisitionID,
RequisitionNo = r.RequisitionNo,
RequisitionCategory = r.RequisitionCategory,
RequisitionType = r.RequisitionType,
ReqRaisedOn = (Convert.ToDateTime(r.ReqRaisedOn)).ToString("dd'/'MM'/'yyyy"),
RequiredByTime = (r.RequiredByTime == 0? null: r.RequiredByTime),
ReqRaisedBy = (r.ReqRaisedBy),
RequisitionFrom = r.RequisitionFrom,
RequisitionTo = r.RequisitionTo,
RecipeFor = (r.RecipeFor),
RecipeID = (r.RecipeID),
ArticleNo = r.ArticleNo,
ArticleName = (re == null? null: re.ArticleName),
ArticleChallanNo = (re == null ? null : re.ArticleChallanNo),
ArticleColor = (re == null ? null : re.ArticleColor),
ArticleColorName = (c == null ? null : c.ColorName),
BaseQuantity = (re == null ? null : (re.BaseQuantity).ToString()),
//BaseUnit = (re == null ? null : re.BaseUnit),
BaseUnitName = (u == null ? null : u.UnitName),
LeatherSize = r.LeatherSize,
SizeUnit = (r.SizeUnit),
Selection = r.Selection,
Thickness = r.Thickness,
ThicknessUnit = (r.ThicknessUnit),
ProductionQty = (r.ProductionQty == 0 ? null : r.ProductionQty),
ProductionQuantityUnit = (u == null ? null : u.UnitName),
RecordStatus = r.RecordStatus
}).FirstOrDefault();
model.RequisitionInfo = RequisitionInfo;
model.RequisitionItemList = GetRequisitionItemList(_RequisitionID, RequisitionInfo.RequisitionTo);
return(model);
}
public void DeleteRecepie()
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString()))
{
var cmd = new SqlCommand(@"Delete from tblComponents where ReceptID=@RecepieID; Delete from tblRecept where ReceptID=@RecepieID;", conn);
cmd.Parameters.AddWithValue("@RecepieID", recepie.ReceptId);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Recepie successfully deleted.", "Notification");
Recepies.Remove(recepie);
}
}
public RecepiesRepo()
{
List <string> steps = new List <string> {
"step 1", "step 2", "step 3"
};
TimeSpan span1 = TimeSpan.FromMinutes(40);
TimeSpan span2 = TimeSpan.FromMinutes(30);
TimeSpan span3 = TimeSpan.FromMinutes(15);
Recepies test1 = new Recepies("Kødsovs", steps, span1);
Recepies test2 = new Recepies("test1", steps, span2);
Recepies test3 = new Recepies("test3", steps, span3);
recepies.Add(test1);
recepies.Add(test2);
recepies.Add(test3);
}
private async void BtEDITRecepie_OnClicked(object sender, EventArgs e)
{
try
{
Recepies recepies = new Recepies();
recepies.id = this.Recepieses.id;
recepies.title = this.EntryTitle.Text;
recepies.description = this.EntryDescription.Text;
recepies.preparationTime = Int32.Parse(this.EntryPreparationTime.Text);
recepies.cookingTime = Int32.Parse(this.EntryCookingTime.Text);
recepies.people = Int32.Parse(this.EntryPeople.Text);
recepies.difficulty = this.EntryDifficulty.Text;
recepies.category = this.EntryCategory.Text;
recepies.UserId = Preferences.Get("userId", 0);
recepies.ingredients = this.Iingredients;
recepies.preparationSteps = this.PreparationSteps;
var responce = await ApiService.EditRecepie(recepies.id, recepies);
if (file != null)
{
responce = await ApiService.EditRecepieIMG(recepies.id, recepies.title, this.file);
}
if (responce)
{
await DisplayAlert("Sukces!", "Pomyślnie dokonano edycji przepisu", "OK");
Navigation.PopModalAsync();
}
else
{
await DisplayAlert("Ooops", "Coś poszło nie tak", "Zamknij");
}
}
catch (Exception exception)
{
await DisplayAlert("Ooops", "Coś poszło nie tak", "Zamknij");
}
}
private async void BtAddRecepie_OnClicked(object sender, EventArgs e)
{
try
{
Recepies recepies = new Recepies();
//var ImageArray = FromFile.ToArray(file.GetStream());
recepies.title = this.EntryTitle.Text;
recepies.description = this.EntryDescription.Text;
recepies.preparationTime = Int32.Parse(this.EntryPreparationTime.Text);
recepies.cookingTime = Int32.Parse(this.EntryCookingTime.Text);
recepies.people = Int32.Parse(this.EntryPeople.Text);
recepies.difficulty = this.EntryDifficulty.Text;
recepies.category = this.EntryCategory.Text;
recepies.UserId = Preferences.Get("userId", 0);
recepies.ingredients = this.Iingredients;
recepies.preparationSteps = this.PreparationSteps;
await ApiService.AddRecepie(recepies);
var responce = await ApiService.AddRecepieIMG(recepies.title, this.file);
if (responce)
{
await DisplayAlert("Sukces!", "Pomyślnie dodano nowy przepis", "OK");
Application.Current.MainPage = new NavigationPage(new AppMainPage());
}
else
{
await DisplayAlert("Ooops", "Coś poszło nie tak", "Zamknij");
}
}
catch (Exception exception)
{
await DisplayAlert("Ooops", "Coś poszło nie tak", "Zamknij");
}
}
private async void GetRecepieDetail(int recepieId)
{
var recepie = await ApiService.GetRecepieDetail(recepieId);
Recepieses = (Recepies)recepie.First();
this.EntryTitle.Text = Recepieses.title;
this.EntryDescription.Text = Recepieses.description;
this.EntryPreparationTime.Text = Recepieses.preparationTime.ToString();
this.EntryCookingTime.Text = Recepieses.cookingTime.ToString();
this.EntryPeople.Text = Recepieses.people.ToString();
this.EntryDifficulty.Text = Recepieses.difficulty;
this.EntryCategory.Text = Recepieses.category;
this.Iingredients = Recepieses.ingredients;
this.CvIngredients.ItemsSource = Iingredients;
this.PreparationSteps = Recepieses.preparationSteps;
this.CvPreparationStep.ItemsSource = PreparationSteps;
this.ImgAddFromFile.Source = Recepieses.FullImage;
this.ImgAddFromFile.HeightRequest = 350;
}
private async void GetRecepieDetail(int movieId)
{
var recepie = await ApiService.GetRecepieDetail(movieId);
Recepieses = (Recepies)recepie.First();
this.ImgMovie.Source = Recepieses.FullImage;
this.LblCategory.Text = Recepieses.category;
this.LblPeople.Text = Recepieses.people.ToString();
this.LblTitle.Text = Recepieses.title;
this.LblDifficulty.Text = Recepieses.difficulty;
this.LblPeople.Text = $"Dla {Recepieses.people.ToString()} osób";
this.LblPreparationTime.Text = $"Czas przygotowania: {Recepieses.preparationTime.ToString()} min";
this.LblDescription.Text = Recepieses.description;
var test = recepie.SelectMany(x => x.ingredients).ToList();
foreach (var lala in test)
{
IngredientsColection.Add(lala);
}
CvIngredients.ItemsSource = IngredientsColection;
var test2 = recepie.SelectMany(x => x.preparationSteps).ToList();
foreach (var lala in test2)
{
PreparationStepsColection.Add(lala);
}
LvPreparationStep.ItemsSource = PreparationStepsColection;
}
public static async Task <bool> EditRecepie(int id, Recepies recepies)
{
await TokenValidator.Check();
var httpClient = new HttpClient();
var json = JsonConvert.SerializeObject(recepies);
var content = new StringContent(json, Encoding.UTF8, "application/json");
httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("bearer", Preferences.Get("accessToken", string.Empty));
var response = await httpClient.PutAsync(AppSettings.ApiUrl +
$"Recipes/EditRecepie/{id}", content);
if (!response.IsSuccessStatusCode)
{
return(false);
}
else
{
return(true);
}
}
public void SearchByRecepieComponent()
{
string[] words = components.Split(' ');
Recepies.Clear();
UserHaveComponents.Clear();
MissingComponents.Clear();
foreach (string s in words)
{
if (s == "")
{
continue;
}
using (SqlConnection conn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString()))
{
SqlCommand query1 = new SqlCommand(@"exec Get_AllComponentsByInput @ComponentName;", conn1);
query1.Parameters.AddWithValue("@ComponentName", s);
conn1.Open();
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(query1);
DataTable dataTable1 = new DataTable();
sqlDataAdapter1.Fill(dataTable1);
foreach (DataRow row1 in dataTable1.Rows)
{
Components c = new Components
{
ComponentId = int.Parse(row1[0].ToString()),
ReceptId = int.Parse(row1[1].ToString()),
ComponentName = row1[2].ToString(),
ComponentAmount = int.Parse(row1[3].ToString())
};
bool contains = false;
foreach (Components item in UserHaveComponents)
{
if (item.ComponentName == c.ComponentName)
{
contains = true;
break;
}
}
if (!contains)
{
UserHaveComponents.Add(c);
}
}
conn1.Close();
}
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString()))
{
SqlCommand query = new SqlCommand(@"exec Get_AllReceptsByComponents @Components", conn);
query.Parameters.AddWithValue("@Components", s);
conn.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(query);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
foreach (DataRow row in dataTable.Rows)
{
Recept r = new Recept
{
ReceptId = int.Parse(row[0].ToString()),
UserId = int.Parse(row[1].ToString()),
TypeId = int.Parse(row[2].ToString()),
ReceptName = row[3].ToString(),
PersonNumber = int.Parse(row[4].ToString()),
Author = row[5].ToString(),
ReceptText = row[6].ToString(),
CreationDate = DateTime.Parse(row[7].ToString()),
ReceptType = row[9].ToString(),
};
if (LoginWindow.CurrentUser.UserId == r.UserId)
{
r.CanEdit = true;
}
if (LoginWindow.CurrentUser.Username == "Admin")
{
r.CanEdit = true;
r.CanDelete = true;
}
using (SqlConnection conn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString()))
{
SqlCommand query1 = new SqlCommand(@"exec Get_AllReceptsComponentsNumber @ReceptID = @Id;", conn1);
query1.Parameters.AddWithValue("@Id", r.ReceptId);
conn1.Open();
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(query1);
DataTable dataTable1 = new DataTable();
sqlDataAdapter1.Fill(dataTable1);
foreach (DataRow row1 in dataTable1.Rows)
{
r.ComponentsNumber = int.Parse(row1[0].ToString());
}
}
List <int> ids = new List <int>();
foreach (Recept i in Recepies)
{
ids.Add(i.ReceptId);
}
if (!ids.Contains(r.ReceptId))
{
Recepies.Add(r);
}
}
conn.Close();
}
}
}
