//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); }
public static Dictionary<int, string> GetAll_Quotation_Status() { QuotationEntities entities = new QuotationEntities(); var result = from n in entities.Quotation_Status select n; return result.ToDictionary(n => (Int32)n.Quotation_Status_Id, n => n.Quotation_Status_Name); }
//List All Countries public static Dictionary<int, string> GetAllCountry(int TechnologyID) { QuotationEntities entities = new QuotationEntities(); var result = (from n in entities.vw_Target where n.Technology_id == TechnologyID select new { n.country_id, n.country_name }).Distinct(); return result.ToDictionary(n => n.country_id, n => n.country_name); }
public static Dictionary<int, string> GetAll_Product_Type(int TechnologyID, int Country_ID) { QuotationEntities entities = new QuotationEntities(); var result = (from n in entities.vw_Target where n.Technology_id == TechnologyID && n.country_id == Country_ID select new { n.product_type_id, n.wowi_product_type_name }).Distinct(); return result.ToDictionary(n => n.product_type_id, n => n.wowi_product_type_name); }
//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(); }
//Mark by Adams 2012/4/23 for Project Requirment Change Requirment //public static Project GetProject(int QuotationID) //{ // QuotationEntities entities = new QuotationEntities(); // var result = from n in entities.Project // where n.Quotation_Id == QuotationID // select n; // return result.FirstOrDefault(); //} //Add by Adams 2012/4/23 for Project Requirment Change Requirment public static Project GetProject(string QuotationNO) { QuotationEntities entities = new QuotationEntities(); var result = from n in entities.Project where n.Quotation_No == QuotationNO select n; return result.FirstOrDefault(); }
public static String GetEmployeeAccessLevel(int employee_id) { QuotationEntities entities = new QuotationEntities(); var result = from n in entities.m_employee_accesslevel where n.employee_id == employee_id select n.accesslevel_id; return "'" + String.Join("','", result) + "'"; }
public static employee GetEmployee(int EmployeeID) { QuotationEntities entities = new QuotationEntities(); var result = from n in entities.employee where n.id == EmployeeID select n; return result.First(); }
public static employee GetEmployee(string username) { QuotationEntities entities = new QuotationEntities(); var result = from n in entities.employee where n.username == username orderby n.q_authorize_amt select n; return result.First(); }
public static string GetCountryName(int Country_ID) { QuotationEntities entities = new QuotationEntities(); var result = from n in entities.country where n.country_id == Country_ID select n; if (result.Count() > 0) return result.First().country_name; else return ""; }
public static Quotation_Target Select(int Quotation_Target_Id) { QuotationEntities entities = new QuotationEntities(); Quotation_Target target = entities.Quotation_Target.First (c => c.Quotation_Target_Id == Quotation_Target_Id); return target; }
public static Dictionary<int, string> GetAll_Target(int country_id, int product_type_id, int authority_id, int wowi_tech_id) { //Modify by Adams 2012/4/28 for New Requirment use Target Rate QuotationEntities entities = new QuotationEntities(); var result = from n in entities.Target_Rates where n.country_id == country_id && n.product_type_id == product_type_id && n.authority_id == authority_id && n.Technology_id == wowi_tech_id select n; return result.ToDictionary(n => n.Target_rate_id, n => n.authority_name); }
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); }
public static Dictionary<int, string> GetAll_wowi_tech() { QuotationEntities entities = new QuotationEntities(); var result = (from n in entities.vw_Target select new { n.Technology_id, n.wowi_tech_name }).Distinct(); return result.ToDictionary(n => n.Technology_id, n => n.wowi_tech_name); }
public static void Copy(int New_Quotation_ID, int Old_Quotation_ID) { QuotationEntities entities = new QuotationEntities(); IEnumerable<Quotation_Target> TargetList = entities.Quotation_Target.Where (c => c.quotation_id == Old_Quotation_ID); foreach (Quotation_Target item in TargetList) { entities.Detach(item); item.EntityKey = null; item.quotation_id = New_Quotation_ID; //Project Target Estimate Date 以下欄位資料不能複製至新Target item.Status = "Open"; item.test_started = null; item.test_completed = null; item.certification_completed = null; item.certification_submit_to_authority = null; item.Estimated_Lead_time = string.Empty; item.Actual_Lead_time = string.Empty; item.Agent = 0; item.Country_Manager = 0; item.PR_Flag = string.Empty; item.Bill1 = null; item.Bill2 = null; item.Bill3 = null; item.BillE = null; //adams:2014/8/25 item.document_ready_to_process = null; item.certificate_type = null; item.certificate_issue_date = null; item.certificate_expiry_date = null; item.email_renewal_notice_date = null; item.renewal_confirmation_check = "0"; item.conduct_renewal_action_date = null; item.sample_received_from_client_date = null; item.customer_request_sample_returned = "0"; item.sample_returned_to_client_date = null; item.sample_shipping_tracking_no = null; item.customer_request_original_certificate_returned = "0"; item.original_certificate_mailed_to_client_date = null; item.Certificate_shipping_tracking_no = null; item.sample_can_be_returned_from_authority = "0"; item.sample_is_kept_by_local_agent = false; item.request_local_agent_to_destroy_tested_samples = false; item.returned_of_tested_sample_date = null; item.CMB1 = false; item.CMB2 = false; item.CMB3 = false; item.CMB4 = false; item.CMB5 = false; item.CMB6 = false; item.CMB7 = false; item.CMB8 = false; item.original_certificate_received_date = null; item.Lifetime = false; Add(item); } }
//List All Versions public static Dictionary<int, string> GetAllVersions(string Quotation_No) { //modify by Adams 2012/5/6 只有confirmed的報價單才會秀版本 QuotationEntities entities = new QuotationEntities(); var result = (from n in entities.Quotation_Version where n.Quotation_No == Quotation_No select new { n.Quotation_Version_Id, n.Vername }).Distinct(); return result.ToDictionary(n => n.Quotation_Version_Id, n => "V" + n.Vername.ToString()); }
public static IEnumerable<vw_Test_Target_List> SelectView(string Quotation_No) { QuotationEntities entities = new QuotationEntities(); IEnumerable<vw_Test_Target_List> TargetList = entities.vw_Test_Target_List.Where (c => c.Quotation_No == Quotation_No); return TargetList; }
public static string GetTargetDescription(int AuthorityID) { QuotationEntities entities = new QuotationEntities(); var result = from t in entities.Authority where t.authority_id == AuthorityID select t; string description = string.Empty; if (result!=null) { description = result.FirstOrDefault().Target_Description; } return description; }
protected void dvWorkingStatus_DataBound(object sender, EventArgs e) { TextBox tmp = (TextBox)dvWorkingStatus.FindControl("txtLogDate"); tmp.Text = System.DateTime.Now.ToShortDateString(); Label lbl = (Label)dvWorkingStatus.FindControl("LabelCreateBy"); lbl.Text = User.Identity.Name; Label date = (Label)dvWorkingStatus.FindControl("LabelCertificationDate"); if (ddlWorkingStatusTarget.SelectedValue != "0") { int targetid = int.Parse(ddlWorkingStatusTarget.SelectedValue); QuotationModel.QuotationEntities dc = new QuotationModel.QuotationEntities(); var result = (from t in dc.Quotation_Target where t.Quotation_Target_Id == targetid select new { t.certification_completed }).First().certification_completed; if (string.IsNullOrEmpty(result.ToString())) { date.Text = "N/A"; } else { date.Text = result.Value.ToShortDateString(); } } }
public static clientapplicant GetClientApplicant(int ClientID) { QuotationEntities entities = new QuotationEntities(); var result = from n in entities.clientapplicant //join c in entities.country on n.country_id equals c.country_id where n.id == ClientID select n; //select new { n, c.country_name }; return result.First(); }
//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); }
public static Dictionary<int, string> GetClientApplicantList(int employee_id) { QuotationEntities entities = new QuotationEntities(); var result = from n in entities.m_employee_accesslevel join c in entities.clientapplicant on n.accesslevel_id equals c.department_id where n.employee_id == employee_id && (c.clientapplicant_type == 1 || c.clientapplicant_type== 3) orderby c.companyname select c; return result.ToDictionary(n => n.id, n => n.companyname + " " + n.c_companyname); }
public static contact_info Getcontact_info(int ContactID) { QuotationEntities entities = new QuotationEntities(); var result = from n in entities.contact_info where n.id == ContactID select n; //select new { n, c.country_name }; return result.First(); }
public static Dictionary<int, decimal> GetAll_Target_Rates( int wowi_tech_id, int Country_ID, int product_type_id, int authority_id) { //QuotationEntities entities = new QuotationEntities(); //var result = from n in entities.Target_Rates // where n.country_id == country_id && n.product_type_id == product_type_id && n.authority_name == authority_name && n.Technology_id == wowi_tech_id // select n; //if (result.Count() > 0) // return (decimal)result.First().rate; //else // return 0; QuotationEntities entities = new QuotationEntities(); var result = (from n in entities.vw_Target where n.Technology_id ==wowi_tech_id && n.country_id == Country_ID && n.product_type_id == product_type_id && n.Publish == true select new { n.Target_rate_id, n.rate }).Distinct(); return result.ToDictionary(n => (int)n.Target_rate_id, n => (decimal)n.rate); }
// Accordion 1 protected void ddlWorkingStatusProject_SelectedIndexChanged(object sender, EventArgs e) { ddlWorkingStatusCountry.DataBind(); ddlWorkingStatusTarget.DataBind(); gvWorkingStatus.EditIndex = -1; gvWorkingStatus.DataBind(); dvWorkingStatus.Visible = false; DropDownList ddl = sender as DropDownList; if (ddl.SelectedValue != "0") { int pid = int.Parse(ddl.SelectedValue); txtAction.Visible = true; SaveClientAction.Visible = true; QuotationModel.QuotationEntities dc = new QuotationModel.QuotationEntities(); var project = (from p in dc.Project where p.Project_Id == pid select p).SingleOrDefault(); if (project != null) { txtAction.Text = project.Client_Action; //PanelReport.Visible = true; } } else { txtAction.Visible = false; SaveClientAction.Visible = false; //PanelReport.Visible = false; } HFAccordionStatus.Value = "1";//控制accordion }