public IList <WorkDetail> GetWorkDetailsByOrder(int id)
{
IList <WorkDetail> lista;
WorkDetail workDetail;
SqlCommand cmdWorkDetail = new SqlCommand();
cmdWorkDetail.CommandText = "getAllWorkDetailById";
cmdWorkDetail.CommandType = System.Data.CommandType.StoredProcedure;
cmdWorkDetail.Parameters.Add(new SqlParameter("@id", id));
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
cmdWorkDetail.Connection = connection;
SqlDataReader myReader;
myReader = cmdWorkDetail.ExecuteReader();
lista = new List <WorkDetail>();
while (myReader.Read())
{
workDetail = new WorkDetail();
workDetail.IdWorkDetail = myReader.GetInt32(0);
workDetail.Description = myReader.GetString(1);
lista.Add(workDetail);
}
myReader.Close();
return(lista);
}
//[ValidateAntiForgeryToken]
public ActionResult Edit([Bind(Include = "ComponentSKU,ParentSKU,Work,Id,WorkNo,WorkId,ParentSKUId,ComponentSKUId,GraphSKU,GraphVer,ConsumeQty,StockQty,RequirementQty,Brand,Process,Responsibility,AltOrderProdctionDate,AltProdctionDate1,ActualProdctionDate1,AltProdctionDate2,ActualProdctionDate2,AltProdctionDate3,ActualProdctionDate3,AltProdctionDate4,ActualProdctionDate4,AltProdctionDate5,ActualProdctionDate5,ConfirmUser,Remark1,Remark2,BomComponentId,ParentBomComponentId,OrderKey,CreatedUserId,CreatedDateTime,LastEditUserId,LastEditDateTime")] WorkDetail workDetail)
{
if (ModelState.IsValid)
{
workDetail.ObjectState = ObjectState.Modified;
_workDetailService.Update(workDetail);
_unitOfWork.SaveChanges();
if (Request.IsAjaxRequest())
{
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
DisplaySuccessMessage("Has update a WorkDetail record");
return(RedirectToAction("Index"));
}
var skuRepository = _unitOfWork.Repository <SKU>();
ViewBag.ComponentSKUId = new SelectList(skuRepository.Queryable(), "Id", "Sku", workDetail.ComponentSKUId);
//var skuRepository = _unitOfWork.Repository<SKU>();
ViewBag.ParentSKUId = new SelectList(skuRepository.Queryable(), "Id", "Sku", workDetail.ParentSKUId);
var workRepository = _unitOfWork.Repository <Work>();
ViewBag.WorkId = new SelectList(workRepository.Queryable(), "Id", "WorkNo", workDetail.WorkId);
if (Request.IsAjaxRequest())
{
var modelStateErrors = String.Join("", this.ModelState.Keys.SelectMany(key => this.ModelState[key].Errors.Select(n => n.ErrorMessage)));
return(Json(new { success = false, err = modelStateErrors }, JsonRequestBehavior.AllowGet));
}
DisplayErrorMessage();
return(View(workDetail));
}
public ActionResult RateAdditionManageDetails([Bind(Include = "WorkDetailID,WorkID,RateAdditionID,Qty,Rate,Amount")] WorkDetail workDetail, Decimal?or)
{
var getWR = db.FirstOrDefault <Work>("Select Rate From Work Where WorkID= @0", workDetail.WorkID);
//We have to find the total of this work record
var WorkTotal = db.FirstOrDefault <decimal>("Select sum(Amount) from WorkDetail where workID=@0 and ItemID IS NOT NULL and LabourID IS NOT NULL", workDetail.WorkID);
using (var transaction = db.GetTransaction())
{
try
{
var RateAdditionRate = db.FirstOrDefault <decimal>("Select Percentage From RateAdditions where RateAdditionID = @0", workDetail.RateAdditionID);
workDetail.Amount = WorkTotal * (RateAdditionRate / 100);
workDetail.Qty = RateAdditionRate;
db.Update("Work", "WorkID", new { Rate = workDetail.Amount + getWR.Rate - or }, workDetail.WorkID);
base.BaseSave <WorkDetail>(workDetail, workDetail.WorkDetailID > 0);
transaction.Complete();
}
catch (Exception ex)
{
db.AbortTransaction();
throw ex;
}
}
return(RedirectToAction("RateAdditionDetails", new { id = workDetail.WorkID }));
}
public OperationResult AddTasks(ItemsViewModel items)
{
var result = new OperationResult();
try
{
ToDoModel context = new ToDoModel();
var repository = new ToDoRepository <WorkDetail>(context);
WorkDetail entity = new WorkDetail()
{
WorkContent = items.WorkContent,
Important = items.IsImportant ? "Y" : "N",
Complete = items.Completed ? "Y" : "N",
CreationDate = DateTime.Now,
PlanDate = items.PlanedDate,
LastUpdateDate = DateTime.Now
};
repository.Create(entity);
context.SaveChanges();
result.IsSuccessful = true;
}
catch (Exception ex)
{
result.IsSuccessful = false;
result.exception = ex;
}
return(result);
}
public async Task <ActionResult> OnPostWork(string title, string location, string company, DateTime start, DateTime end, string summary)
{
this.Error = null;
if (string.IsNullOrEmpty(title))
{
this.Error = "Work Title can't be empty.";
}
if (string.IsNullOrEmpty(location))
{
this.Error = "Work Location can't be empty.";
}
if (string.IsNullOrEmpty(company))
{
this.Error = "Project Company can't be empty.";
}
if (start.Equals(DateTime.MinValue))
{
this.Error = "Start Date is invalid.";
}
if (!DateTime.MinValue.Equals(end) && end.CompareTo(start) < 0)
{
this.Error = "End Date cannot be after Start Date.";
}
if (string.IsNullOrEmpty(summary))
{
this.Error = "Work summary can't be empty.";
}
if (!string.IsNullOrEmpty(this.Error))
{
return(OnGet());
}
this.CurrentUser = this.GetUser(HttpContext.User.Identity.Name);
WorkDetail workDetail = new WorkDetail()
{
Company = company,
Location = location,
Title = title,
StartDate = start,
Summary = summary
};
if (!DateTime.MinValue.Equals(end))
{
workDetail.EndDate = end;
}
this.CurrentUser.WorkDetails.Add(workDetail);
await _context.SaveChangesAsync();
return(Redirect("~/details"));
}
/// <summary>
/// Function to save work detail.
/// </summary>
/// <param name="workDetail">work detail information</param>
/// <param name="applicationType">Application type</param>
public void InsertOrUpdate(WorkDetail workDetail, ApplicationType applicationType)
{
if (workDetail == null)
{
throw new ArgumentNullException(WorkDetailConst);
}
workDetail.Date = workDetail.Date.Date;
workDetail.ApplicationID = (byte)applicationType;
this.timesheetRepository.InsertOrUpdate(workDetail);
this.unitOfWork.Save();
}
//[ValidateAntiForgeryToken]
public ActionResult DeleteConfirmed(int id)
{
WorkDetail workDetail = _workDetailService.Find(id);
_workDetailService.Delete(workDetail);
_unitOfWork.SaveChanges();
if (Request.IsAjaxRequest())
{
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
DisplaySuccessMessage("Has delete a WorkDetail record");
return(RedirectToAction("Index"));
}
/// <summary>
/// Inserts the specified work detail.
/// </summary>
/// <param name="workDetail">The work detail.</param>
/// <param name="applicationType">Type of the application.</param>
/// <returns>The total timesheet hours</returns>
public decimal Insert(WorkDetail workDetail, ApplicationType applicationType)
{
if (workDetail == null)
{
throw new ArgumentNullException(WorkDetailConst);
}
workDetail.Date = workDetail.Date.Date;
workDetail.ApplicationID = (byte)applicationType;
var result = this.timesheetRepository.Insert(workDetail);
this.unitOfWork.Save();
return result;
}
// GET: WorkDetails/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
WorkDetail workDetail = _workDetailService.Find(id);
if (workDetail == null)
{
return(HttpNotFound());
}
return(View(workDetail));
}
// GET: WorkDetails/Create
public ActionResult Create()
{
WorkDetail workDetail = new WorkDetail();
//set default value
var skuRepository = _unitOfWork.Repository <SKU>();
ViewBag.ComponentSKUId = new SelectList(skuRepository.Queryable(), "Id", "Sku");
//var skuRepository = _unitOfWork.Repository<SKU>();
ViewBag.ParentSKUId = new SelectList(skuRepository.Queryable(), "Id", "Sku");
var workRepository = _unitOfWork.Repository <Work>();
ViewBag.WorkId = new SelectList(workRepository.Queryable(), "Id", "WorkNo");
return(View(workDetail));
}
/// <summary>
/// Function to save work details.
/// </summary>
/// <param name="workDetail">work detail information</param>
public void InsertOrUpdate(WorkDetail workDetail)
{
if (workDetail == null)
{
throw new ArgumentNullException(WorkDetailConstant);
}
if (workDetail.WorkDetailID == default(int))
{
this.unitOfWork.Context.Entry(workDetail).State = EntityState.Added;
}
else
{
this.unitOfWork.Context.Entry(workDetail).State = EntityState.Modified;
}
}
public void GenerateWorkDetail(WorkGeneratorViewModel viewmodel)
{
var orderdetail = this._orderdetailservice.Queryable().Include(x => x.Order).Where(x => x.Id == viewmodel.OrderDetailId).First();
var work = this.Queryable().Where(x => x.Id == viewmodel.WorkId).First();
var bomcomponents = this._bomservice.Queryable().Include(x => x.ParentComponent).Include(x => x.SKU).Where(x => viewmodel.WorkingBomComponents.Contains(x.Id)).ToList();
var list = new List <WorkDetail>();
foreach (var bom in bomcomponents)
{
WorkDetail item = new WorkDetail();
item.WorkId = work.Id;
item.WorkNo = work.WorkNo;
item.StockQty = 0;
item.AltOrderProdctionDate = orderdetail.Order.OrderDate;
item.AltProdctionDate1 = orderdetail.Order.OrderDate;
item.AltProdctionDate2 = orderdetail.Order.OrderDate;
item.AltProdctionDate3 = orderdetail.Order.OrderDate;
item.AltProdctionDate4 = orderdetail.Order.OrderDate;
item.AltProdctionDate5 = orderdetail.Order.OrderDate;
item.BomComponentId = bom.Id;
item.ParentBomComponentId = bom.ParentComponentId;
item.ComponentSKUId = bom.SKUId;
item.ConsumeQty = bom.ConsumeQty;
item.GraphSKU = bom.GraphSKU;
item.GraphVer = "";
item.OrderKey = orderdetail.OrderKey;
item.ParentSKUId = bom.ParentComponent.SKUId;
item.Remark1 = bom.Remark1;
item.Remark2 = bom.Remark2;
item.RequirementQty = orderdetail.Qty * bom.ConsumeQty;
item.StockQty = 0;
item.ProductionQty = orderdetail.Qty * bom.ConsumeQty;
item.DoingQty = 0;
item.FinishedQty = 0;
var exists = _workdetailservice.Queryable().Where(x => x.WorkId == work.Id && x.ComponentSKUId == bom.SKUId && x.ParentSKUId == bom.ParentComponent.SKUId).Any();
if (!exists)
{
list.Add(item);
}
}
this._workdetailservice.InsertRange(list);
}
public WorkDetail UpdateWorkDetail(int workDetailId, WorkDetail workDetail)
{
SqlCommand cmdWorkDetail = new SqlCommand();
cmdWorkDetail.CommandText = "update_work_detail";
cmdWorkDetail.CommandType = System.Data.CommandType.StoredProcedure;
cmdWorkDetail.Parameters.Add(new SqlParameter("@work_detail_id", workDetailId));
cmdWorkDetail.Parameters.Add(new SqlParameter("@products_price", workDetail.ProductsPrice));
cmdWorkDetail.Parameters.Add(new SqlParameter("@description", workDetail.Description));
cmdWorkDetail.Parameters.Add(new SqlParameter("@work_order_id", workDetail.WorkOrderId));
SqlConnection connection = new SqlConnection(connectionString);
SqlTransaction transaction = null;
try
{
connection.Open();
transaction = connection.BeginTransaction();
cmdWorkDetail.Connection = connection;
cmdWorkDetail.Transaction = transaction;
cmdWorkDetail.ExecuteNonQuery();
transaction.Commit();
}
catch (SqlException ex)
{
if (transaction != null)
{
transaction.Rollback();
}
throw ex;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
return(workDetail);
}
// GET: WorkDetails/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
WorkDetail workDetail = _workDetailService.Find(id);
if (workDetail == null)
{
return(HttpNotFound());
}
var skuRepository = _unitOfWork.Repository <SKU>();
ViewBag.ComponentSKUId = new SelectList(skuRepository.Queryable(), "Id", "Sku", workDetail.ComponentSKUId);
//var skuRepository = _unitOfWork.Repository<SKU>();
ViewBag.ParentSKUId = new SelectList(skuRepository.Queryable(), "Id", "Sku", workDetail.ParentSKUId);
var workRepository = _unitOfWork.Repository <Work>();
ViewBag.WorkId = new SelectList(workRepository.Queryable(), "Id", "WorkNo", workDetail.WorkId);
return(View(workDetail));
}
public void InsertarDetalleTrabajo(WorkDetail workDetail)
{
SqlCommand cmdProduct = new SqlCommand();
cmdProduct.CommandText = "Proyecto2Mechanical_insertWorkDetail";
cmdProduct.CommandType = System.Data.CommandType.StoredProcedure;
cmdProduct.Parameters.Add(new SqlParameter("@price", workDetail.Price));
cmdProduct.Parameters.Add(new SqlParameter("@description", workDetail.Description));
cmdProduct.Parameters.Add(new SqlParameter("@id_work_order", workDetail.WorkOrder.IdWorkOrder));
SqlConnection connection = new SqlConnection(connectionString);
SqlTransaction transaction = null;
try
{
connection.Open();
transaction = connection.BeginTransaction();
cmdProduct.Connection = connection;
cmdProduct.Transaction = transaction;
cmdProduct.ExecuteNonQuery();
transaction.Commit();
}
catch (SqlException ex)
{
if (transaction != null)
{
transaction.Rollback();
}
throw ex;
}
finally
{
if (connection != null)
{
connection.Close();
}
}//finally
}
public List <WorkDetail> GetWorkDetails(int workOrderId)
{
String sqlSelect = "select work_detail_id, products_price, description, work_order_id from work_detail where work_order_id='" + workOrderId + "';";
SqlDataAdapter daWorkDetail = new SqlDataAdapter(sqlSelect, new SqlConnection(connectionString));
//daUser.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet dsWorkDetail = new DataSet();
daWorkDetail.Fill(dsWorkDetail, "work_detail");
Dictionary <int, WorkDetail> dictionary = new Dictionary <int, WorkDetail>();
WorkDetail workDetail = null;
foreach (DataRow row in dsWorkDetail.Tables["work_detail"].Rows)
{
int workDetailId = Int32.Parse(row["work_detail_id"].ToString());
if (dictionary.ContainsKey(workDetailId) == false)
{
List <RequiredProduct> products = new List <RequiredProduct>();
String sqlProduct = "select required_product_id, material, quantity, price, work_detail_id from required_product where work_detail_id='" + workDetailId + "';";
SqlDataAdapter daRequiredProduct = new SqlDataAdapter(sqlProduct, new SqlConnection(connectionString));
DataSet dsRequiredProduct = new DataSet();
daRequiredProduct.Fill(dsRequiredProduct, "required_product");
RequiredProduct requiredProduct = null;
foreach (DataRow rowProduct in dsRequiredProduct.Tables["required_product"].Rows)
{
int requiredProductId = Int32.Parse(rowProduct["required_product_id"].ToString());
requiredProduct = new RequiredProduct(requiredProductId, rowProduct["material"].ToString(), Int32.Parse(rowProduct["quantity"].ToString()), float.Parse(rowProduct["price"].ToString()), Int32.Parse(rowProduct["work_detail_id"].ToString()));
products.Add(requiredProduct);
}
workDetail = new WorkDetail(workDetailId, float.Parse(row["products_price"].ToString()), row["description"].ToString(), Int32.Parse(row["work_order_id"].ToString()), products);
dictionary.Add(workDetailId, workDetail);
}
}
return(dictionary.Values.ToList <WorkDetail>());
}
public ActionResult LabourManageDetails([Bind(Include = "WorkDetailID,WorkID,LabourID,Qty,Rate,Amount")] WorkDetail workDetail, Decimal?or)
{
var getWR = db.FirstOrDefault <Work>("Select Rate From Work Where WorkID= @0", workDetail.WorkID);
using (var transaction = db.GetTransaction())
{
try
{
var labourRate = db.FirstOrDefault <decimal>("Select Rate From Labour where LabourID = @0", workDetail.LabourID);
workDetail.Amount = workDetail.Qty * labourRate;
db.Update("Work", "WorkID", new { Rate = workDetail.Amount + getWR.Rate - or }, workDetail.WorkID);
base.BaseSave <WorkDetail>(workDetail, workDetail.WorkDetailID > 0);
RefreshWorkAdditions(workDetail.WorkID.Value, workDetail.Amount.Value);
transaction.Complete();
}
catch (Exception ex)
{
db.AbortTransaction();
throw ex;
}
}
return(RedirectToAction("LabourDetails", new { id = workDetail.WorkID }));
}
public ActionResult Details([Bind(Include = "WorkDetailID,WorkID,UnitID,Rate,ItemID,Qty,Amount")] WorkDetail workDetail)
{
using (var transaction = db.GetTransaction())
{
try
{
var getWR = db.FirstOrDefault <decimal>("Select Rate From Work Where WorkID= @0", workDetail.WorkID);
var getItemRate = db.FirstOrDefault <decimal>("Select Rate From Item Where ItemID = @0", workDetail.ItemID);
workDetail.Amount = workDetail.Qty * getItemRate;
base.BaseSave <WorkDetail>(workDetail, workDetail.WorkDetailID > 0);
db.Update("Work", "WorkID", new { Rate = workDetail.Amount + getWR }, workDetail.WorkID);
RefreshWorkAdditions(workDetail.WorkID.Value, workDetail.Amount.Value);
transaction.Complete();
}
catch (Exception ex)
{
db.AbortTransaction();
throw ex;
}
}
return(RedirectToAction("Details", new { id = workDetail.WorkID }));
}
/// <summary>
/// Retrieves the work detail.
/// </summary>
/// <returns>returns RetrieveWorkDetail</returns>
private WorkDetail RetrieveWorkDetail()
{
var workdetail = new WorkDetail
{
Date = this.currentDate,
ProjectID = Convert.ToInt32(this.projectComboBox.SelectedValue, CultureInfo.CurrentCulture),
CategoryID = Convert.ToInt32(this.workCategoryComboBox.SelectedValue, CultureInfo.CurrentCulture),
HoursReported = Convert.ToDecimal(this.hoursTextBox.Text, CultureInfo.CurrentCulture),
Description = this.descriptionTextBox.Text,
ClientDependencyFlag = this.isClientDependencyCombBox.IsChecked != null && (bool)this.isClientDependencyCombBox.IsChecked
};
workdetail.DeveloperID = this.developer.DeveloperID;
if (this.Features.Count > 1)
{
workdetail.FeatureID = Convert.ToInt32(this.featureComboBox.SelectedValue, CultureInfo.CurrentCulture);
}
return workdetail;
}
public void Post([FromBody] WorkDetail workDetail)
{
WorkDetailData workDetailData = new WorkDetailData(configuration.GetConnectionString("MechanicalContext").ToString());
workDetailData.InsertarDetalleTrabajo(workDetail);
}
public static async Task <TemplateFile> Create(AzureFileController azureFileController, User user, string documentLink, Dictionary <string, List <object> > subsetDetails)
{
var valuesToFill = new Content(
new FieldContent("Initials", user.FirstName.ToCharArray()[0].ToString() + user.LastName.ToCharArray()[0].ToString()),
new FieldContent("FirstName", user.FirstName),
new FieldContent("LastName", user.LastName),
new FieldContent("Email", user.UserInfo?.FirstOrDefault()?.AltEmail ?? user.Email),
new TableContent("EducationTable"),
new TableContent("CertTable"),
new TableContent("WorkTable"),
new TableContent("ProjectTable"),
new TableContent("SkillTable"));
subsetDetails["Edu"].ForEach(obj =>
{
EducationDetail detail = (EducationDetail)obj;
valuesToFill
.Tables
.FirstOrDefault(table => table.Name.Equals("EducationTable"))
.AddRow(new FieldContent("SchoolName", detail.SchoolName),
new FieldContent("Achievement", detail.Achievement),
new FieldContent("Degree", detail.Degree),
new FieldContent("EndDate", detail.EndDateTentative ? "Current" : detail.EndDate?.ToShortDateString()),
new FieldContent("StartDate", detail.StartDate.ToShortDateString()),
new FieldContent("GPA", detail.GPA.ToString()));
});
subsetDetails["Cert"].ForEach(obj =>
{
CertDetail detail = (CertDetail)obj;
valuesToFill
.Tables
.FirstOrDefault(table => table.Name.Equals("CertTable"))
.AddRow(new FieldContent("Issuer", detail.Issuer),
new FieldContent("Name", detail.Name),
new FieldContent("DateAchieved", detail.DateAchieved.ToShortDateString()));
});
subsetDetails["Work"].ForEach(obj =>
{
WorkDetail detail = (WorkDetail)obj;
valuesToFill
.Tables
.FirstOrDefault(table => table.Name.Equals("WorkTable"))
.AddRow(new FieldContent("Company", detail.Company),
new FieldContent("Location", detail.Location),
new FieldContent("Summary", detail.Summary),
new FieldContent("EndDate", detail.EndDateTentative ? "Current" : detail.EndDate?.ToShortDateString()),
new FieldContent("StartDate", detail.StartDate.ToShortDateString()),
new FieldContent("Title", detail.Title.ToString()));
// TODO add bullets
});
subsetDetails["Project"].ForEach(obj =>
{
ProjectDetail detail = (ProjectDetail)obj;
valuesToFill
.Tables
.FirstOrDefault(table => table.Name.Equals("ProjectTable"))
.AddRow(new FieldContent("Company", detail.Company),
new FieldContent("Supervisor", detail.Supervisor),
new FieldContent("Summary", detail.Summary),
new FieldContent("EndDate", detail.EndDateTentative ? "Current" : detail.EndDate?.ToShortDateString()),
new FieldContent("StartDate", detail.StartDate.ToShortDateString()),
new FieldContent("Title", detail.Title.ToString()));
});
subsetDetails["Skill"].ForEach(obj =>
{
SkillDetail detail = (SkillDetail)obj;
valuesToFill
.Tables
.FirstOrDefault(table => table.Name.Equals("SkillTable"))
.AddRow(new FieldContent("Class", detail.Class),
new FieldContent("Name", detail.Name),
new FieldContent("Level", detail.Level));
});
if (user.UserInfo.Any())
{
UserInfo info = user.UserInfo.FirstOrDefault();
if (!string.IsNullOrEmpty(info.NameExt))
{
valuesToFill.Fields.Add(new FieldContent("NameExt", info.NameExt));
}
if (!string.IsNullOrEmpty(info.Summary))
{
valuesToFill.Fields.Add(new FieldContent("Summary", info.Summary));
}
if (!string.IsNullOrEmpty(info.PhoneNumber))
{
valuesToFill.Fields.Add(new FieldContent("Phone", info.PhoneNumber));
}
if (!string.IsNullOrEmpty(info.Website))
{
valuesToFill.Fields.Add(new FieldContent("Website", info.Website));
}
}
string str = await azureFileController.GetFile(FileType.Templates, documentLink);
using (var outputDocument = new TemplateProcessor(str).SetRemoveContentControls(true).SetNoticeAboutErrors(false))
{
outputDocument.FillContent(valuesToFill);
outputDocument.SaveChanges();
}
return(new TemplateFile()
{
LocalFile = str
});
}
public Report getReport(int idWorkOrder)
{
Report report = new Report();
VehicleDetail vehicleDetail;
SqlCommand cmdReport = new SqlCommand();
cmdReport.CommandText = "ReporteGeneral";
cmdReport.CommandType = System.Data.CommandType.StoredProcedure;
cmdReport.Parameters.Add(new SqlParameter("@idOrdenTrabajo", idWorkOrder));
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
cmdReport.Connection = connection;
SqlDataReader myReader;
myReader = cmdReport.ExecuteReader();
//Primer conjunto de resultados
while (myReader.Read())
{
if (report.WorkOrder.Vehicle.VehicleId == null)
{
report.WorkOrder.Vehicle.VehicleId = myReader.GetString(0);
report.WorkOrder.Vehicle.Color = myReader.GetString(1);
report.WorkOrder.Vehicle.Brand = myReader.GetString(2);
report.WorkOrder.Vehicle.Style = myReader.GetString(3);
report.WorkOrder.Vehicle.Year = myReader.GetInt32(4).ToString();
report.WorkOrder.Vehicle.Power = myReader.GetString(5);
report.WorkOrder.Vehicle.Displacement = myReader.GetString(6);
report.WorkOrder.Vehicle.Capacity = myReader.GetInt32(7);
report.WorkOrder.Vehicle.Weight = myReader.GetInt32(8);
report.WorkOrder.Vehicle.ChasisNumber = myReader.GetString(9);
report.WorkOrder.Vehicle.MotorNumber = myReader.GetString(10);
}
vehicleDetail = new VehicleDetail();
vehicleDetail.IdVehicleDetail = myReader.GetInt32(11);
vehicleDetail.Quantity = myReader.GetInt32(12);
vehicleDetail.Observations = myReader.GetString(13);
vehicleDetail.TypeDetail.Description = myReader.GetString(14);
vehicleDetail.Condition.Description = myReader.GetString(15);
report.VehicleDetailList.Add(vehicleDetail);
}
//Avanzo a segundo conjunto de resultados
myReader.NextResult();
//Segundo conjunto de resultados
WorkDetail workDetail;
Product product;
while (myReader.Read())
{
product = new Product();
workDetail = new WorkDetail();
if (report.WorkOrder.IdWorkOrder == 0)
{
report.WorkOrder.IdWorkOrder = myReader.GetInt32(0);
report.WorkOrder.Description = myReader.GetString(1);
report.WorkOrder.DeliveryDate = myReader.GetDateTime(2);
report.WorkOrder.TotalPrice = myReader.GetFloat(3);
//brinco 4 que es id client
//brinco 5 que es id vehicle, ya se insertó en reader anterior.
}
workDetail.IdWorkDetail = myReader.GetInt32(6);
workDetail.Price = myReader.GetFloat(7);
workDetail.Description = myReader.GetString(8);
report.WorkDetailList.Add(workDetail);
product.IdProduct = myReader.GetInt32(9);
product.Name = myReader.GetString(10);
product.Quantity = myReader.GetInt32(11);
product.Price = myReader.GetFloat(12);
report.ProductList.Add(product);
}
//Avanzo a tercer conjunto de resultados
myReader.NextResult();
//Tercer conjunto de resultados
while (myReader.Read())
{
report.WorkOrder.Client.IdClient = myReader.GetString(0);
report.WorkOrder.Client.ClientName = myReader.GetString(1);
report.WorkOrder.Client.LastName = myReader.GetString(2);
report.WorkOrder.Client.PhoneNumber = myReader.GetString(3);
report.WorkOrder.Client.Address = myReader.GetString(4);
report.WorkOrder.Client.Email = myReader.GetString(5);
}
return(report);
}
/// <summary>
/// Function to delete work detail information.
/// </summary>
/// <param name="id">work detail id</param>
public void Delete(int id)
{
var workDetail = new WorkDetail
{
WorkDetailID = id
};
this.unitOfWork.Context.Entry(workDetail).State = EntityState.Deleted;
}
public WorkDetail Put(int id, [FromBody] WorkDetail value)
{
return(this.workDetailData.UpdateWorkDetail(id, value));
}
public WorkDetail Post([FromBody] WorkDetail value)
{
return(this.workDetailData.InsertWorkDetail(value));
}
/// <summary>
/// Inserts the or update.
/// </summary>
/// <param name="workDetail">The work detail.</param>
/// <returns>The total timesheet hours</returns>
public decimal Insert(WorkDetail workDetail)
{
this.InsertOrUpdate(workDetail);
this.unitOfWork.Context.SaveChanges();
return this.RetrieveTimesheetHours(workDetail.DeveloperID, workDetail.Date);
}
public WorkDetail InsertWorkDetail(WorkDetail workDetail)
{
SqlCommand cmdWorkOrder = new SqlCommand();
cmdWorkOrder.CommandText = "insert_work_detail";
cmdWorkOrder.CommandType = System.Data.CommandType.StoredProcedure;
cmdWorkOrder.Parameters.Add(new SqlParameter("@description", workDetail.Description));
cmdWorkOrder.Parameters.Add(new SqlParameter("@work_order_id", workDetail.WorkOrderId));
SqlCommand cmdRequiredProduct = new SqlCommand();
cmdRequiredProduct.CommandText = "insert_required_product";
cmdRequiredProduct.CommandType = System.Data.CommandType.StoredProcedure;
SqlConnection connection = new SqlConnection(connectionString);
SqlTransaction transaction = null;
try
{
connection.Open();
transaction = connection.BeginTransaction();
cmdWorkOrder.Connection = connection;
cmdWorkOrder.Transaction = transaction;
cmdRequiredProduct.Connection = connection;
cmdRequiredProduct.Transaction = transaction;
int wordDetailId = Int32.Parse(cmdWorkOrder.ExecuteScalar().ToString());
workDetail.WorkDetailId = wordDetailId;
List <RequiredProduct> products = workDetail.Products;
foreach (RequiredProduct requiredProduct in products)
{
cmdRequiredProduct.Parameters.Add(new SqlParameter("@material", requiredProduct.Material));
cmdRequiredProduct.Parameters.Add(new SqlParameter("@quantity", requiredProduct.Quantity));
cmdRequiredProduct.Parameters.Add(new SqlParameter("@price", requiredProduct.Price));
cmdRequiredProduct.Parameters.Add(new SqlParameter("@work_detail_id", wordDetailId));
cmdRequiredProduct.ExecuteNonQuery();
cmdRequiredProduct.Parameters.Clear();
}
transaction.Commit();
}
catch (SqlException ex)
{
if (transaction != null)
{
transaction.Rollback();
}
throw ex;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
return(workDetail);
}
