private void btnDeleteTask_Click(object sender)
{
if (projectproject_template_detailViewSource.View != null)
{
projectproject_template_detailViewSource.View.Filter = null;
List <project_template_detail> project_template_detailLIST = treeProject.ItemsSource.Cast <project_template_detail>().ToList();
project_template_detailLIST = project_template_detailLIST.Where(x => x.IsSelected == true).ToList();
using (db db = new db())
{
foreach (project_template_detail project_template_detail in project_template_detailLIST)
{
project_template_detail _project_template_detail = db.project_template_detail.Where(x => x.id_template_detail == project_template_detail.id_template_detail).FirstOrDefault();
db.project_template_detail.Remove(_project_template_detail);
}
db.SaveChanges();
}
ProjectTemplateDB = new ProjectTemplateDB();
project_templateViewSource = ((CollectionViewSource)(FindResource("project_templateViewSource")));
ProjectTemplateDB.project_template.Where(a => a.id_company == CurrentSession.Id_Company).Load();
project_templateViewSource.Source = ProjectTemplateDB.project_template.Local;
filter_task();
}
}
public void filter_task()
{
if (projectproject_template_detailViewSource != null)
{
if (projectproject_template_detailViewSource.View != null)
{
projectproject_template_detailViewSource.View.Filter = i =>
{
project_template_detail project_template_detail = (project_template_detail)i;
if (project_template_detail.State != EntityState.Deleted)
{
if (project_template_detail.parent == null)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
};
}
}
}
private void btnAddParentTask_Click(object sender)
{
stpcode.IsEnabled = true;
//itemSearchViewSource.View.Filter = i =>
//{
// item item = (item)i;
// if (item.is_active == true)
// return true;
// else
// return false;
//};
project_template project_template = project_templateViewSource.View.CurrentItem as project_template;
project_template_detail n_project_template = new project_template_detail();
n_project_template.id_project_template = project_template.id_project_template;
n_project_template.status = Status.Project.Pending;
ProjectTemplateDB.project_template_detail.Add(n_project_template);
projectproject_template_detailViewSource.View.Filter = null;
filter_task();
projectproject_template_detailViewSource.View.MoveCurrentToLast();
treeProject.SelectedItem_ = n_project_template;
}
private void item_Select(object sender, EventArgs e)
{
if (sbxItem.ItemID > 0)
{
item item = ProjectTemplateDB.items.Where(x => x.id_item == sbxItem.ItemID).FirstOrDefault();
project_template_detail project_template_detail = (project_template_detail)treeProject.SelectedItem_;
project_template_detail.id_item = item.id_item;
project_template_detail.item = item;
}
}
private void btnNewTask_Click(object sender)
{
stpcode.IsEnabled = true;
//itemSearchViewSource.View.Filter = i =>
//{
// item item = (item)i;
// if (item.is_active == true)
// return true;
// else
// return false;
//};
project_template project_template = project_templateViewSource.View.CurrentItem as project_template;
project_template_detail project_template_detail = treeProject.SelectedItem_ as project_template_detail;
if (project_template_detail != null && project_template_detail.item.id_item_type == entity.item.item_type.Task)
{
//Adding a Child Item.
project_template_detail n_project_template = new project_template_detail();
n_project_template.id_project_template = project_template.id_project_template;
n_project_template.status = Status.Project.Pending;
project_template_detail.child.Add(n_project_template);
ProjectTemplateDB.project_template_detail.Add(n_project_template);
projectproject_template_detailViewSource.View.Filter = null;
filter_task();
treeProject.SelectedItem_ = n_project_template;
}
else
{
toolBar.msgWarning("Please Select Task");
}
projectproject_template_detailViewSource.View.MoveCurrentToLast();
}
private void project_Changed()
{
List <project_template_detail> _projectTemplate = new List <project_template_detail>();
int selectid = Convert.ToInt32(id_project);
_projectTemplate = entity.db.project_template_detail.Where(x => x.id_project_template == selectid).ToList();
project_template_detail accesories_template = _projectTemplate.Where(x => x.logic == "Accessory").FirstOrDefault();
project_template_detail accesories_x_qty_template = _projectTemplate.Where(x => x.logic == "Accessory Per Quantity").FirstOrDefault();
project_template_detail ink_template = _projectTemplate.Where(x => x.logic == "ink").FirstOrDefault();
project_template_detail printer_template = _projectTemplate.Where(x => x.logic == "printer").FirstOrDefault();
project_template_detail toner_template = _projectTemplate.Where(x => x.logic == "Toner").FirstOrDefault();
project_template_detail paper_template = _projectTemplate.Where(x => x.logic == "paper").FirstOrDefault();
project_template_detail cut_template = _projectTemplate.Where(x => x.logic == "Cut").FirstOrDefault();
//project_template_detail accesory_abc = _projectTemplate.Where(x => x.logic == "accesory_abc").FirstOrDefault();
if (ink_template != null)
{
int _inkTag = Convert.ToInt16(ink_template.id_tag);
cmbink.SelectedValuePath = "id_item";
cmbink.DisplayMemberPath = "name";
cmbink.ItemsSource = entity.db.items
.Where(x => entity.db.item_tag_detail.Where(y => y.id_tag == _inkTag)
.Select(z => z.id_item)
.Contains(x.id_item)).ToList();
cmbvalue.ItemsSource = ink_Percentage;
}
if (printer_template != null)
{
_printerTag = Convert.ToInt16(printer_template.id_tag);
using (db db = new db())
{
List <item> printerlist = entity.db.items.Where(x => entity.db.item_tag_detail
.Where(y => y.id_tag == _printerTag)
.Select(z => z.id_item)
.Contains(x.id_item)).ToList();
foreach (item _item in printerlist)
{
PrintingPress.Printer _printer = new PrintingPress.Printer();
_printer.Id = _item.id_item;
_printer.Name = _item.name;
_printer.Min_Long = (decimal)_item.item_asset.FirstOrDefault().min_width;
_printer.Min_Short = (decimal)_item.item_asset.FirstOrDefault().min_length;
_printer.Max_Long = (decimal)_item.item_asset.FirstOrDefault().max_width;
_printer.Max_Short = (decimal)_item.item_asset.FirstOrDefault().max_length;
_printer.Speed = (int)_item.item_asset.FirstOrDefault().speed;
_printer.Color_Limit = (int)_item.item_property.FirstOrDefault().value;
_printer.Cost = (decimal)_item.unit_cost;
_printer.Cost_DieSet = (decimal)_item.item_asset.FirstOrDefault().dieset_price;
//Adding to List
_printerList.Add(_printer);
//stpprinter.ItemsSource = _printerList;
}
}
}
if (accesories_template != null)
{
int _accessoryTag = Convert.ToInt16(accesories_template.id_tag);
List <item> _itemList = entity.db.items.Where(x => entity.db.item_tag_detail
.Where(y => y.id_tag == _accessoryTag)
.Select(z => z.id_item).Contains(x.id_item)).ToList();
foreach (item item in _itemList)
{
int id_item = Convert.ToInt32(item.id_item);
if (id_item > 0)
{
PrintingPress.Accessory accessory = new PrintingPress.Accessory();
accessory.Id = (int)item.id_item;
accessory.Cost = (decimal)item.unit_cost;
accessory.Name = item.name;
accessory.Consumption = 1;
accessory.Calc_Cost = accessory.Cost * accessory.Consumption;
_accessoryList.Add(accessory);
}
}
itemaccesories.ItemsSource = _accessoryList.ToList();
}
if (toner_template != null)
{
int _tonerTag = Convert.ToInt16(toner_template.id_tag);
item _toner = entity.db.items
.Where(x => entity.db.item_tag_detail
.Where(y => y.id_tag == _tonerTag)
.Select(z => z.id_item).Contains(x.id_item)).FirstOrDefault();
}
if (cut_template != null)
{
int _cutTag = Convert.ToInt16(cut_template.id_tag);
item _cut = entity.db.items
.Where(x => entity.db.item_tag_detail
.Where(y => y.id_tag == _cutTag)
.Select(z => z.id_item).Contains(x.id_item)).FirstOrDefault();
}
if (paper_template != null)
{
int _paperTag = Convert.ToInt16(paper_template.id_tag);
using (db db = new db())
{
List <item> paperlist = entity.db.items
.Where(x => entity.db.item_tag_detail.Where(y => y.id_tag == _paperTag)
.Select(z => z.id_item)
.Contains(x.id_item)).ToList();
foreach (item _item in paperlist)
{
PrintingPress.Paper _paper = new PrintingPress.Paper();
_paper.Id = _item.id_item;
if (_item.item_dimension.Where(x => x.id_app_dimension == id_Weight).FirstOrDefault() != null)
{
_paper.Weight = (int)_item.item_dimension.Where(x => x.id_app_dimension == id_Weight).FirstOrDefault().value;
}
else
{
_paper.Weight = 0;
}
_paper.Cost = (decimal)_item.unit_cost;
if (_item.item_dimension.Where(x => x.id_app_dimension == id_Long).FirstOrDefault() != null)
{
_paper.Long = (decimal)_item.item_dimension.Where(x => x.id_app_dimension == id_Long).FirstOrDefault().value;
}
else
{
_paper.Long = 0;
}
if (_item.item_dimension.Where(x => x.id_app_dimension == id_Short).FirstOrDefault() != null)
{
_paper.Short = (decimal)_item.item_dimension.Where(x => x.id_app_dimension == id_Short).FirstOrDefault().value;
}
else
{
_paper.Short = 0;
}
_paper.Name = _paper.Long.ToString() + " x " + _paper.Short.ToString();
//Adding Paper to PaperList
_paperList.Add(_paper);
}
}
}
}
public void project()
{
MySqlConnection conn = new MySqlConnection(_connString);
MySqlCommand cmd = new MySqlCommand();
string sql_count = " select" +
" sum(a.count)" +
" from" +
" ( select count(*) as count from project union all " +
" select count(*) as count from project_category union all " +
" select count(*) as count from project_task ) a ";
conn.Open();
cmd.Connection = conn;
cmd.CommandText = sql_count;
cmd.CommandType = CommandType.Text;
int count = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
int value = 0;
Dispatcher.BeginInvoke((Action)(() => projectMaximum.Text = count.ToString()));
Dispatcher.BeginInvoke((Action)(() => projectValue.Text = value.ToString()));
Dispatcher.BeginInvoke((Action)(() => progProject.Maximum = count));
Dispatcher.BeginInvoke((Action)(() => progProject.Value = value));
string sql_proj_category = " SELECT * FROM project_category;";
conn.Open();
cmd.Connection = conn;
cmd.CommandText = sql_proj_category;
cmd.CommandType = CommandType.Text;
MySqlDataReader category_reader = cmd.ExecuteReader();
while (category_reader.Read())
{
using (db db = new db())
{
project_template project_template = new project_template();
project_template.name = category_reader.GetString("category");
project_template.is_active = true;
db.project_template.Add(project_template);
db.SaveChanges();
value += 1;
Dispatcher.BeginInvoke((Action)(() => progProject.Value = value));
Dispatcher.BeginInvoke((Action)(() => projectValue.Text = value.ToString()));
}
}
conn.Close();
string sql_template = " SELECT project_template.*, project_category.category, item_sku.product FROM project_template "
+ " INNER JOIN project_category ON project_template.id_category = project_category.id"
+ " INNER JOIN item_sku ON project_template.id_sku = item_sku.id;";
conn.Open();
cmd.Connection = conn;
cmd.CommandText = sql_template;
cmd.CommandType = CommandType.Text;
MySqlDataReader template_reader = cmd.ExecuteReader();
while (template_reader.Read())
{
using (db db = new db())
{
project_template_detail project_template_detail = new project_template_detail();
string category = template_reader.GetString("category");
project_template_detail.id_project_template = db.project_template.Where(i => i.name == category).FirstOrDefault().id_project_template;
project_template_detail.code = template_reader.GetString("task_number");
project_template_detail.item_description = template_reader.GetString("product");
if (db.items.Where(i => i.name == project_template_detail.item_description).FirstOrDefault() != null)
{
project_template_detail.id_item = db.items.Where(i => i.name == project_template_detail.item_description).FirstOrDefault().id_item;
if (template_reader.GetInt16("id_task_rel") == 0)
{
//no parent. do nothing
}
else
{
//has parent
string code = template_reader.GetString("task_number");
int pos = code.LastIndexOf('.');
if (pos >= 0)
{
code = code.Substring(0, pos);
}
project_template_detail.parent = db.project_template_detail.Where(p => p.code == code &&
p.id_project_template == project_template_detail.id_project_template)
.FirstOrDefault();
}
//Insert into Context & Save
db.project_template_detail.Add(project_template_detail);
db.SaveChanges();
}
}
}
conn.Close();
string sql_proj = " SELECT * FROM project";
conn.Open();
cmd.Connection = conn;
cmd.CommandText = sql_proj;
cmd.CommandType = CommandType.Text;
MySqlDataReader proj_reader = cmd.ExecuteReader();
while (proj_reader.Read())
{
using (db db = new db())
{
db.Configuration.AutoDetectChangesEnabled = false;
project project = new project();
project.id_project = proj_reader.GetInt32("id");
project.est_start_date = proj_reader.GetDateTime("begin_date");
if (proj_reader["id_contact"] is DBNull)
{
value += 1;
continue;
}
else
{
project.id_contact = proj_reader.GetInt32("id_contact");
}
project.name = proj_reader.GetString("project");
if (project.Error == null)
{
db.projects.Add(project);
db.SaveChanges();
value += 1;
Dispatcher.BeginInvoke((Action)(() => progProject.Value = value));
Dispatcher.BeginInvoke((Action)(() => projectValue.Text = value.ToString()));
}
}
}
conn.Close();
string sql_proj_task = " SELECT project_task.*, project.project, item_sku.product,app_status.status FROM project_task "
+ " INNER JOIN project ON project_task.id_project = project.id"
+ " INNER JOIN item_sku ON project_task.id_sku = item_sku.id"
+ " INNER JOIN app_status ON project_task.id_status = app_status.id";
conn.Open();
cmd.Connection = conn;
cmd.CommandText = sql_proj_task;
cmd.CommandType = CommandType.Text;
MySqlDataReader proj_task_reader = cmd.ExecuteReader();
while (proj_task_reader.Read())
{
using (db db = new db())
{
project_task project_task = new project_task();
string project = proj_task_reader.GetString("project");
project_task.id_project = db.projects.Where(i => i.name == project).FirstOrDefault().id_project;
project_task.code = proj_task_reader.GetString("task_number");
string product = proj_task_reader.GetString("product");
if (db.items.Where(i => i.name == product).FirstOrDefault() != null)
{
project_task.item_description = db.items.Where(i => i.name == product).FirstOrDefault().name;
project_task.id_item = db.items.Where(i => i.name == product).FirstOrDefault().id_item;
if (proj_task_reader.GetString("status") == "Aprobado")
{
project_task.status = Status.Project.Approved;
}
else if (proj_task_reader.GetString("status") == "Pendiente")
{
project_task.status = Status.Project.Pending;
}
if (!(proj_task_reader["qty"] is DBNull))
{
project_task.quantity_est = proj_task_reader.GetInt16("qty");
}
if (proj_task_reader.GetInt16("id_task_rel") == 0)
{
//no parent. do nothing
}
else
{
//has parent
string code = proj_task_reader.GetString("task_number");
//logic to have children
if (project_task.quantity_est == null)
{
var pos = code.LastIndexOf('.');
if (pos >= 0)
{
code = code.Substring(0, pos);
project_task.parent = db.project_task.Where(p => p.code == code &&
p.id_project == project_task.id_project
).FirstOrDefault();
}
}
else
{
project_task.parent = db.project_task.Where(p => p.code == code &&
p.id_project == project_task.id_project
).FirstOrDefault();
}
}
//if (project_task.Error == null)
//{
db.project_task.Add(project_task);
//}
}
else
{
}
string sql_task = "SELECT * FROM project_task_dimension inner join app_dimension on app_dimension.id=project_task_dimension.id_dimension inner join project_task on project_task.id=project_task_dimension.id_task where id_task=" + proj_task_reader.GetInt32("id");
try
{
MySqlConnection conntask = new MySqlConnection(_connString);
MySqlCommand cmdtask = new MySqlCommand();
conntask.Open();
cmdtask.Connection = conntask;
cmdtask.CommandText = sql_task;
cmdtask.CommandType = CommandType.Text;
MySqlDataReader task_reader = cmdtask.ExecuteReader();
while (task_reader.Read())
{
project_task_dimension project_task_dimension = new project_task_dimension();
string name = task_reader.GetString("dimension");
if (db.app_dimension.Where(x => x.name == name).FirstOrDefault() != null)
{
project_task_dimension.id_dimension = db.app_dimension.Where(x => x.name == name).FirstOrDefault().id_dimension;
project_task_dimension.project_task = project_task;
project_task_dimension.value = task_reader.GetInt32("value");
project_task_dimension.id_measurement = db.app_measurement.FirstOrDefault().id_measurement;
if (project_task_dimension.Error == null)
{
db.project_task_dimension.Add(project_task_dimension);
}
}
}
task_reader.Close();
cmdtask.Dispose();
conntask.Close();
}
catch (Exception ex)
{ throw ex; }
IEnumerable <DbEntityValidationResult> validationresult = db.GetValidationErrors();
if (validationresult.Count() == 0)
{
try
{
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
value += 1;
Dispatcher.BeginInvoke((Action)(() => progProject.Value = value));
Dispatcher.BeginInvoke((Action)(() => projectValue.Text = value.ToString()));
}
}
}
cmd.Dispose();
conn.Close();
}
