public static void AddTask(AddTaskVM model)
{
using (SqlConnection connection = new SqlConnection(Helpers.Helpers.GetAppConnectionString()))
{
try
{
// Create the Command and Parameter objects.
SqlCommand cmd = new SqlCommand("", connection);
connection.Open();
//calculate the total payment
if (model.TotalPayment == 0)
{
model.TotalPayment = model.Hours * 15 + model.Milage * 0.53 + model.Material;
}
cmd.CommandText = "insert into tblTasks(TaskDetail, StatusID, ContractorID, CreateDate, UpdateDate, WorkHours, Milage, MaterialCost, TotalCost, PaymentBankAccountID, UNITID ) values ('";
cmd.CommandText += model.TaskDetail.Replace("'", "") + "', 1, " + model.ContractorID + ", '" + DateTime.Now + "', '" + DateTime.Now + "'," + model.Hours
+ "," + model.Milage + "," + model.Material + "," + model.TotalPayment + "," + model.BankAccountID + "," + model.UnitID + ")";
cmd.ExecuteNonQuery();
//send text message to the contractor and admin
Email.EmailTask(model.ContractorID, model.AdminID, model.TaskDetail, "High");
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
connection.Close();
}
}
}
public ActionResult Add(AddTaskVM model)
{
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
if (model.TaskNumber == 0)
{
ModelState.AddModelError("", "Redni broj zadatka ne može biti 0!");
}
if (_db.zadaci.AsNoTracking().Where(x => x.naziv == model.Name && x.nalog_id == null && x.broj_zadatka == model.TaskNumber).FirstOrDefault() != null)
{
ModelState.AddModelError("", "Nedodijeljen zadatak sa unesenim nazivom ili rednim brojem već postoji!");
}
if (ModelState.IsValid)
{
zadaci taskDB = new zadaci();
taskDB.broj_zadatka = model.TaskNumber;
taskDB.naziv = model.Name;
taskDB.opis = model.Description;
taskDB.checkin = null;
taskDB.checkout = null;
taskDB.poznatalokacija_id = model.KnownLocationID;
taskDB.nalog_id = null;
_db.zadaci.Add(taskDB);
_db.SaveChanges();
return(RedirectToAction(actionName: "Index"));
}
}
model.KnownLocations = _dropdownMaker.GetKnownLocations();
return(View(viewName: "Add", model: model));
}
private void AddTaskCommandExecute()
{
CanAddTask = false;
AddTaskVM dataContext = new AddTaskVM(changeCanAddTaskToTrue, logedUser);
AddTask dialog = new AddTask();
dialog.DataContext = dataContext;
dialog.Show();
}
public Adddd(int op, Task t1)
{
op2 = op;
t = t1;
InitializeComponent();
Vm = new AddTaskVM();
this.DataContext = Vm;
//Vm.ListOfTasksId = Manage.ListOfTasksIdUser;
for (int i = 0; i < 24; i++)
{
if (i < 10)
{
hour.Items.Add("0" + i);
hour1.Items.Add("0" + i);
}
else
{
hour.Items.Add("" + i);
hour1.Items.Add("" + i);
}
}
for (int i = 0; i < 60; i++)
{
if (i < 10)
{
minutes.Items.Add("0" + i);
minutes1.Items.Add("0" + i);
}
else
{
minutes.Items.Add("" + i);
minutes1.Items.Add("" + i);
}
//cmb_city.Items.Add("Tel Aviv");
//cmb_city.Items.Add("Natania");
//cmb_city.Items.Add("Yavne");
//cmb_city.Items.Add("Rehovot");
//cmb_city.Items.Add("Jerusalem");
//cmb_city.Items.Add("Haifa");
//cmb_city.Items.Add("Tiberia");
//cmb_city.Items.Add("Rishon Leztiyon");
//cmb_city.Items.Add("Ashdod");
//cmb_city.Items.Add("Elat");
}
if (op == 2)
{
OkayButton.Visibility = Visibility.Hidden;
initilizeDelete();
Vm.TaskId = t.TaskId;
}
}
public ActionResult Add(AddTaskVM model)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Task"));
}
ViewBag.ReportTitle = "Add Task";
model.AdminID = Int32.Parse(Session["UserID"].ToString());
TaskManager.AddTask(model);
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id)
{
ViewBag.ReportTitle = reporttitle;
AddTaskVM model = new AddTaskVM();
model = TaskManager.GetTaskByID(id);
model.AllTenant = GetSelectListItems((short)Helpers.Helpers.ListType.allUser);
model.AllStatus = GetSelectListItems((short)Helpers.Helpers.ListType.allStatus);
model.AllBankAccount = GetSelectListItems((short)Helpers.Helpers.ListType.bankaccount);
model.AllUnit = GetSelectListItems((short)Helpers.Helpers.ListType.unit);
return(View(model));
}
public ActionResult Add()
{
// add new user
if (Session["UserName"] == null)
{
return(RedirectToAction("Index", "Task"));
}
ViewBag.ReportTitle = "Add Task";
AddTaskVM model = new AddTaskVM();
model.StatusID = (int)Helpers.Helpers.StatusType.Open;
model.ContractorID = (Int32)Session["UserID"];
model.AllTenant = GetSelectListItems((short)Helpers.Helpers.ListType.allUser);
model.AllStatus = GetSelectListItems((short)Helpers.Helpers.ListType.allStatus);
model.AllBankAccount = GetSelectListItems((short)Helpers.Helpers.ListType.bankaccount);
model.AllUnit = GetSelectListItems((short)Helpers.Helpers.ListType.unit);
model.ContractorID = (Int32)Session["UserID"];
return(View(model));
}
public ActionResult Add()
{
AddTaskVM model = new AddTaskVM();
model.KnownLocations = _dropdownMaker.GetKnownLocations();
using (TruckTransportDbContext _db = new TruckTransportDbContext())
{
var knownLocationID = Convert.ToInt32(model.KnownLocations.First().Value);
var selectedKnownLocation = _db.poznatelokacije.Where(x => x.poznatalokacija_id == knownLocationID).FirstOrDefault();
if (selectedKnownLocation != null)
{
model.Latitude = selectedKnownLocation.sirina;
model.Longitude = selectedKnownLocation.duzina;
}
}
return(View(viewName: "Add", model: model));
}
public saveTheTask(AddTaskVM CurrentMV)
{
this.CurrentMV = CurrentMV;
}
public AddTaskW(AddTaskVM addTaskVM)
{
DataContext = addTaskVM;
InitializeComponent();
}
public static void EditTask(AddTaskVM model)
{
using (SqlConnection connection = new SqlConnection(Helpers.Helpers.GetAppConnectionString()))
{
try
{
int linkedExpenseID = GetTaskByID(model.TaskID).LinkedExpenseID;
//for closed task, system will auto generated expense
if (model.StatusID == (int)Helpers.Helpers.StatusType.Close)
{
if (model.LinkedExpenseID == 0)
{
//add expense
OperationRecord op = new OperationRecord();
op.ContractorID = model.ContractorID;
op.CategoryID = (int)Helpers.Helpers.ExpenseCategory.Repair;
op.DueAmount = model.TotalPayment;
op.DueDate = DateTime.Now;
op.CompleteDate = DateTime.Now;
op.UnitID = model.UnitID;
//op.UploadBy = Int32.Parse(Session["UserID"].ToString());
op.FinancialBankAccountID = model.BankAccountID.ToString();
op.Payment = model.TotalPayment;
op.Memo = "Labor: " + model.Hours + " Milage: " + model.Milage + " Material: " + model.Material;
op.StatusID = (short)Helpers.Helpers.StatusType.Close;
model.LinkedExpenseID = OperationRecordManager.CreateOperationRecord(op);
}
else
{
//update expense
OperationRecord op = OperationRecordManager.GetExpenseByID(model.LinkedExpenseID);
op.ContractorID = model.ContractorID;
op.CategoryID = (int)Helpers.Helpers.ExpenseCategory.Repair;
op.DueAmount = model.TotalPayment;
op.DueDate = DateTime.Now;
op.CompleteDate = DateTime.Now;
op.UnitID = model.UnitID;
//op.UploadBy = Int32.Parse(Session["UserID"].ToString());
op.FinancialBankAccountID = model.BankAccountID.ToString();
op.Payment = model.TotalPayment;
op.Memo = "Labor: " + model.Hours + " Milage: " + model.Milage + " Material: " + model.Material;
OperationRecordManager.UpdateOperationRecord(op);
}
}
// Create the Command and Parameter objects.
SqlCommand cmd = new SqlCommand("", connection);
connection.Open();
model.TotalPayment = model.Hours * 15 + model.Milage * 0.53 + model.Material;
cmd.CommandText = "Update tblTasks set TaskDetail = '" + model.TaskDetail.Replace("'", "") + "', UpdateDate='" + DateTime.Now
+ "', ContractorID=" + model.ContractorID
+ ", StatusID=" + model.StatusID
+ ", WorkHours =" + model.Hours
+ ", Milage =" + model.Milage
+ ", Labor =" + model.Labor
+ ", MaterialCost =" + model.Material
+ ", TotalCost =" + model.TotalPayment
+ ", PaymentBankAccountID =" + model.BankAccountID
+ ", LinkedExpenseID =" + model.LinkedExpenseID
+ ", UnitID =" + model.UnitID
+ " where TaskID=" + model.TaskID;
cmd.ExecuteNonQuery();
connection.Close();
}
catch (Exception ex)
{
string exms = ex.Message;
}
}
}
public static AddTaskVM GetTaskByID(int taskID)
{
StringBuilder sbOperation = new StringBuilder();
sbOperation.Append("Select distinct TaskID, TaskDetail , cUser.UserID, (cUser.FirstName + ' ' + cUser.LastName) as FullName, tblTasks.StatusID, UpdateDate, WorkHours, Milage, MaterialCost, " +
" TotalCost, PaymentBankAccountID, LinkedExpenseID, UnitID, Labor ");
sbOperation.Append(" from tblTasks ");
sbOperation.Append(" INNER JOIN tblCompanyUser on tblCompanyUser.UserID = tblTasks.contractorid ");
sbOperation.Append(" INNER JOIN cUser on cUser.UserID = tblCompanyUser.UserID ");
sbOperation.Append(" where TaskID=" + taskID);
using (SqlDataAdapter adapter = new SqlDataAdapter(sbOperation.ToString(), Helpers.Helpers.GetAppConnectionString()))
{
DataSet ds = new DataSet();
adapter.Fill(ds);
DataTable tb = (DataTable)ds.Tables[0];
if (tb != null && tb.Rows.Count > 0)
{
DataRow dr = tb.Rows[0];
AddTaskVM task = new AddTaskVM();
task.TaskID = Int32.Parse(dr[0].ToString());
task.TaskDetail = dr[1].ToString();
task.ContractorID = Int32.Parse(dr[2].ToString());
if (dr[2] != DBNull.Value)
{
task.ContractorID = Int32.Parse(dr[2].ToString());
}
if (dr[4] != DBNull.Value)
{
task.StatusID = Int32.Parse(dr[4].ToString());
}
if (dr[5] != DBNull.Value)
{
task.UpdateDate = DateTime.Parse(dr[5].ToString());
}
if (dr[6] != DBNull.Value)
{
task.Hours = double.Parse(dr[6].ToString());
}
if (dr[7] != DBNull.Value)
{
task.Milage = double.Parse(dr[7].ToString());
}
if (dr[8] != DBNull.Value)
{
task.Material = double.Parse(dr[8].ToString());
}
if (dr[9] != DBNull.Value)
{
task.TotalPayment = double.Parse(dr[9].ToString());
}
if (dr[10] != DBNull.Value)
{
task.BankAccountID = int.Parse(dr[10].ToString());
}
if (dr[11] != DBNull.Value)
{
task.LinkedExpenseID = int.Parse(dr[11].ToString());
}
if (dr[12] != DBNull.Value)
{
task.UnitID = int.Parse(dr[12].ToString());
}
if (dr[13] != DBNull.Value)
{
task.Labor = double.Parse(dr[13].ToString());
}
return(task);
}
return(null);
}
}
public static List <AddTaskVM> GetAllActiveTaskForUser(string[] statusIDs, string[] contractorIDs)
{
StringBuilder sbOperation = new StringBuilder();
sbOperation.Append("Select distinct TaskID, TaskDetail , cUser.UserID, (cUser.FirstName + ' ' + cUser.LastName) as FullName, tblTasks.StatusID, UpdateDate, WorkHours , "
+ " Milage, MaterialCost, TotalCost, PaymentBankAccountID , tblTasks.UnitID, cStatusType.name, Labor, tblProperty.Address + '-' + tblPropertyUnit.UnitName");
sbOperation.Append(" from tblTasks ");
sbOperation.Append(" INNER JOIN cUser on cUser.UserID = tblTasks.contractorid ");
sbOperation.Append(" INNER JOIN cStatusType on cStatusType.StatusTypeID = tblTasks.StatusID ");
sbOperation.Append(" left outer join tblPropertyUnit on tblPropertyUnit.UnitID = tblTasks.UnitID ");
sbOperation.Append(" left outer join tblProperty ON tblProperty.PropertyID = tblPropertyUnit.PropertyID ");
if (statusIDs != null && statusIDs.Count() > 0 && !string.IsNullOrEmpty(statusIDs[0]))
{
sbOperation.Append(" where tblTasks.StatusID IN (" + String.Join(",", statusIDs) + ")");
}
if (contractorIDs != null && contractorIDs.Count() > 0 && !string.IsNullOrEmpty(contractorIDs[0]))
{
sbOperation.Append(" AND tblTasks.ContractorID IN (" + String.Join(",", contractorIDs) + ")");
}
sbOperation.Append(" order by tblTaskS.StatusID asc, UpdateDate desc");
using (SqlDataAdapter adapter = new SqlDataAdapter(sbOperation.ToString(), Helpers.Helpers.GetAppConnectionString()))
{
DataSet ds = new DataSet();
adapter.Fill(ds);
List <AddTaskVM> allActiveTask = new List <AddTaskVM>();
DataTable tb = (DataTable)ds.Tables[0];
if (tb != null && tb.Rows.Count > 0)
{
for (int i = 0; i < tb.Rows.Count; i++)
{
DataRow dr = tb.Rows[i];
AddTaskVM task = new AddTaskVM();
task.TaskID = Int32.Parse(dr[0].ToString());
task.TaskDetail = dr[1].ToString();
task.TaskDetailHtml = GenerateMailtoLink(dr[1].ToString());
task.UserName = dr[3].ToString();
if (dr[2] != DBNull.Value)
{
task.ContractorID = Int32.Parse(dr[2].ToString());
}
if (dr[4] != DBNull.Value)
{
task.StatusID = Int32.Parse(dr[4].ToString());
}
if (dr[5] != DBNull.Value)
{
task.UpdateDate = DateTime.Parse(dr[5].ToString());
}
if (dr[6] != DBNull.Value)
{
task.Hours = double.Parse(dr[6].ToString());
}
if (dr[7] != DBNull.Value)
{
task.Milage = double.Parse(dr[7].ToString());
}
if (dr[8] != DBNull.Value)
{
task.Material = double.Parse(dr[8].ToString());
}
if (dr[9] != DBNull.Value)
{
task.TotalPayment = double.Parse(dr[9].ToString());
}
else
{
task.TotalPayment = task.Hours * 15 + task.Milage * 0.535 + task.Material;
}
if (dr[10] != DBNull.Value)
{
task.BankAccountID = int.Parse(dr[10].ToString());
}
if (dr[11] != DBNull.Value)
{
task.UnitID = int.Parse(dr[11].ToString());
}
task.StatusName = dr[12].ToString();
if (dr[13] != DBNull.Value)
{
task.Labor = int.Parse(dr[13].ToString());
}
else
{
task.Labor = task.Hours * 15;
}
task.Address = dr[14].ToString();
allActiveTask.Add(task);
}
return(allActiveTask);
}
return(null);
}
}
