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 ctrlToolBar_btnNew_Click(object sender)
{
stackMain.IsEnabled = true;
project_type_templateDataGrid.IsReadOnly = false;
project_template objProjectTemp = new project_template();
entity.project_template.Add(objProjectTemp);
project_templateViewSource.View.MoveCurrentToLast();
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
MessageBoxResult res = MessageBox.Show("Are you sure want to Delete?", "Cognitivo", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (res == MessageBoxResult.Yes)
{
project_template _project = _projecttemplateViewSource.View.CurrentItem as project_template;
//_project.is_active = false;
btnSave_Click(sender, e);
}
}
private void toolBar_btnNew_Click(object sender)
{
crud_modal.Visibility = Visibility.Visible;
cntrl.Curd.projecttemplate projecttemplate = new cntrl.Curd.projecttemplate();
project_template projecttemplateobject = new project_template();
ProjectTemplateDB.project_template.Add(projecttemplateobject);
project_templateViewSource.View.Refresh();
projecttemplate.projecttemplateobject = projecttemplateobject;
projecttemplate.projecttemplateViewSource = project_templateViewSource;
projecttemplate.projecttemplatedetailViewSource = projectproject_template_detailViewSource;
projecttemplate._entity = ProjectTemplateDB;
crud_modal.Children.Add(projecttemplate);
}
private void toolBar_btnSearch_Click(object sender, string query)
{
try
{
if (!string.IsNullOrEmpty(query))
{
project_templateViewSource.View.Filter = i =>
{
project_template project_template = i as project_template;
if (project_template.name != null)
{
if (project_template.name.ToLower().Contains(query.ToLower()))
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
};
}
else
{
project_templateViewSource.View.Filter = null;
}
}
catch (Exception ex)
{
toolBar.msgError(ex);
}
filter_task();
}
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();
}
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();
}
