public static void Add(OperationRecord model)
{
OperationRecordManager.CreateOperationRecord(model);
//using (SqlConnection connection = new SqlConnection(appString))
//{
// try
// {
// // Create the Command and Parameter objects.
// SqlCommand cmd = new SqlCommand("", connection);
// connection.Open();
// if (!model.IsCredit)
// {
// model.Payment = -model.Payment;
// }
// int i = (model.IsCredit == true) ? 1 : 0;
// cmd.CommandText = "insert into tblUnitOperation(StatusID, CategoryID, IsCredit, ContractorID, UnitID, DueDate, DueAmount, Notes,FinancialAccountID, Amount, FinishDate, InvoiceLink) values (";
// cmd.CommandText += model.StatusID + ", " + model.CategoryID + ", " + i + "," + model.ContractorID + ", " + model.UnitID + ",'" + model.DueDate + "', " + model.DueAmount + ", '" + model.Memo;
// cmd.CommandText += "'," + model.FinancialBankAccountID + ", " + model.Payment + ", '" + model.CompleteDate + "'," + model.InvoiceLink + "' )";
// cmd.ExecuteNonQuery();
// }
// catch (Exception ex)
// {
// throw new Exception(ex.Message);
// }
// finally
// {
// connection.Close();
// }
//}
}
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;
}
}
}
