//Add Target public static void Add(Quotation_Target target) { QuotationEntities entities = new QuotationEntities(); entities.Quotation_Target.AddObject(target); entities.SaveChanges(); Quotation_Controller.TargetChange((int)target.quotation_id); }
//Add Project public static void AddProject(Quotation_Version quot) { Project project = new Project(); project.Project_No = DateTime.Now.ToString("yyyyMMdd-HHmmss"); project.Quotation_Id = quot.Quotation_Version_Id; //Add by Adams 2012/4/23 for Project Requirment Change Requirment project.Quotation_No = quot.Quotation_No; project.Create_Date = DateTime.Now; project.Project_Status = "Open"; QuotationEntities entities = new QuotationEntities(); entities.Project.AddObject(project); entities.SaveChanges(); }
public static void Delete(int Quotation_Target_Id) { QuotationEntities entities = new QuotationEntities(); Quotation_Target target = entities.Quotation_Target.First (c => c.Quotation_Target_Id == Quotation_Target_Id); int quotation_id = 0; if (target != null) { quotation_id = (int)target.quotation_id; } entities.Quotation_Target.DeleteObject(target); entities.SaveChanges(); Quotation_Controller.TargetChange(quotation_id); }
//Modify Test Target public static void Modify(Quotation_Target target) { QuotationEntities entities = new QuotationEntities(); //entities.AcceptAllChanges(); var result = (from n in entities.Quotation_Target where n.Quotation_Target_Id == target.Quotation_Target_Id select n).FirstOrDefault(); result.target_id = target.target_id; result.target_description = target.target_description; result.country_id = target.country_id; result.product_type_id = target.product_type_id; result.authority_id = target.authority_id; result.technology_id = target.technology_id; result.target_rate = target.target_rate; result.unit = target.unit; result.unit_price = target.unit_price; result.discount_type = target.discount_type; result.discValue1 = target.discValue1; result.discValue2 = target.discValue2; result.discPrice = target.discPrice; result.FinalPrice = target.FinalPrice; result.PayTo = target.PayTo; result.Status = target.Status; result.Bill = target.Bill; result.option1 = target.option1; result.option2 = target.option2; result.advance1 = target.advance1; result.advance2 = target.advance2; result.balance1 = target.balance1; result.balance2 = target.balance2; result.PR_Flag = target.PR_Flag; result.Bill1 = target.Bill1; result.Bill2 = target.Bill2; result.Bill3 = target.Bill3; result.BillE = target.BillE; entities.SaveChanges(); Quotation_Controller.TargetChange((int)result.quotation_id); }