private void UpdateCaseStatus() { try { co = CaseOrderControllerSingleton.Instance().GetCaseOrder(Convert.ToInt32(txt_CaseOrderId.Text)); if (co != null) { lbl_CaseOrderId.Text = co.CaseOrderId.ToString(); Cbo_CaseStatus.SelectedValue = co.CaseStatusId; lbl_SellerId.Text = co.SellerId.ToString(); lbl_BrokerId.Text = co.BrokerId.ToString(); lbl_EstateId.Text = co.EstateId.ToString(); lbl_BuyerId.Text = co.BuyerId.ToString(); } else { MessageBox.Show("Der findes ingen gyldige sager med det søgte id"); } } catch (Exception) { MessageBox.Show("Fejl: Indtast et sagsnummer"); } }
public void CreateCaseOrder(CaseOrder caseOrder, int priceTypeID, decimal price) { IDatabase db = new DatabaseProxy(); db.CreateCaseOrder(caseOrder); db.InsertPrice(new PriceHistory(price, caseOrder.EstateId, priceTypeID)); }
public void UpdateCaseOrderStatus(CaseOrder co) { context = new EstateBrokersContext(); context.Update(co); //context.Add(co); context.SaveChanges(); }
public void CreateCaseOrder(CaseOrder caseOrder) { EstateBrokersContext dbcontext = new EstateBrokersContext(); dbcontext.CaseOrders.Add(caseOrder); dbcontext.SaveChanges(); }
public void CreateCaseOrder(CaseOrder caseOrder) { try { EFDatabase ef = new EFDatabase(); ef.CreateCaseOrder(caseOrder); } catch (Exception) { SqlDatabase sql = new SqlDatabase(); sql.CreateCaseOrder(caseOrder); } }
public void UpdateCaseOrderStatus(CaseOrder co) { try { db = new EFDatabase(); db.UpdateCaseOrderStatus(co); } catch (Exception e) { Console.WriteLine(e); throw; } }
public void CreateCaseOrder(CaseOrder caseOrder) { var conn = GetConnection(); conn.Open(); SqlCommand com = new SqlCommand( $"Insert into caseorder (CaseStatus, EstateID, SellerID, BrokerID) values ('{caseOrder.CaseStatus}',{caseOrder.EstateId},{caseOrder.SellerId},{caseOrder.BrokerId})", conn); com.ExecuteNonQuery(); conn.Close(); }
public void UpdateCaseOrderStatus(CaseOrder co) { IDatabase db = new DatabaseProxy(); db.UpdateCaseOrderStatus(co); }
public CaseOrder GetCaseOrder(string id) { try { CaseOrder cases_orders = new CaseOrder(); using (OracleConnection con = new OracleConnection(CRMDB)) { DataSet ds = new DataSet(); // Initialize Command and DataAdapter. OracleCommand cmd; OracleDataAdapter da; // Open Connection and call stored procedure. con.Open(); cmd = new OracleCommand("SYSADM.GET_CASE_ORDER", con); cmd.CommandType = CommandType.StoredProcedure; // Stored procedure parameters. cmd.Parameters.Add("Acct_No", OracleType.VarChar, 256).Value = id; cmd.Parameters.Add("OrderoResults", OracleType.Cursor).Direction = ParameterDirection.Output; cmd.Parameters.Add("CaseoResults", OracleType.Cursor).Direction = ParameterDirection.Output; cmd.Parameters.Add("AllCasesoResults", OracleType.Cursor).Direction = ParameterDirection.Output; cmd.Parameters.Add("RegOrdersResults", OracleType.Cursor).Direction = ParameterDirection.Output; cmd.Parameters.Add("RegOrdTechNotesResults", OracleType.Cursor).Direction = ParameterDirection.Output; cmd.Parameters.Add("RegOrdDueDatesResults", OracleType.Cursor).Direction = ParameterDirection.Output; cmd.Parameters.Add("ePaperOrderResults", OracleType.Cursor).Direction = ParameterDirection.Output; cmd.Parameters.Add("ePaperOrdTechNotesResults", OracleType.Cursor).Direction = ParameterDirection.Output; // Fill Dataset using DataAdapter da = new OracleDataAdapter(cmd); da.Fill(ds); // Order Results foreach (DataRow row in ds.Tables[0].Rows) { Order o = new Order(); o.Order_Count = row["ORDER_COUNT"].ToString(); o.Date_Added = row["DATE_ADDED"].ToString(); o.Order_ID = row["ORDER_ID"].ToString(); o.Description = row["DESCRIPTION"].ToString(); o.Due_Date = row["DUE_DATE"].ToString(); o.Modified_By = row["MODIFIED_BY"].ToString(); o.Added_By = row["ADDED_BY"].ToString(); o.Date_Modified = row["DATE_MODIFIED"].ToString(); cases_orders.orders.Add(o); } // Case Results foreach (DataRow row in ds.Tables[1].Rows) { Case c = new Case(); c.Case_Count = row["CASE_COUNT"].ToString(); c.Case_ID = row["CASE_ID"].ToString(); c.Ticket_Summary = row["TICKET_SUMMARY"].ToString(); c.Commitment_Date = row["COMMITMENT_DATE"].ToString(); c.Provider_Grp_ID = row["PROVIDER_GRP_ID"].ToString(); c.Description = row["DESCRIPTION"].ToString(); c.Tech_Assigned = row["TECH_ASSIGNED"].ToString(); c.RC_Status = row["RC_STATUS"].ToString(); c.Last_Modified = row["USER_LAST_MODIFIED"].ToString(); cases_orders.cases.Add(c); } // All Cases Results foreach (DataRow row in ds.Tables[2].Rows) { AllCases ac = new AllCases(); ac.Case_ID = row["CASE_ID"].ToString(); ac.Case_Type = row["CASE_TYPE"].ToString(); ac.Case_Summary = row["CASE_SUMMARY"].ToString(); ac.Commit_Date = row["COMMIT_DATE"].ToString(); ac.Commit_Time = row["COMMIT_TIME"].ToString(); ac.Commit_Date_Time = row["COMMIT_DATE_TIME"].ToString(); ac.Rev_Commit_Date = row["REV_COMMIT_DATE"].ToString(); ac.Rev_Commit_Time = row["REV_COMMIT_TIME"].ToString(); ac.Rev_Commit_Date_Time = row["REV_COMMIT_DATE_TIME"].ToString(); ac.Provider_Grp_ID = row["PROVIDER_GRP_ID"].ToString(); ac.Provider_Grp_Name = row["PROVIDER_GRP_NAME"].ToString(); ac.Case_OOS = row["CASE_OOS"].ToString(); ac.Updated_By = row["UPDATED_BY"].ToString(); ac.Updated_On = row["UPDATED_ON"].ToString(); ac.Added_By = row["ADDED_BY"].ToString(); ac.Added_On = row["ADDED_ON"].ToString(); ac.Case_Category_ID = row["CASE_CATEGORY_ID"].ToString(); ac.Case_Category_Desc = row["CASE_CATEGORY_DESC"].ToString(); ac.Case_Status_ID = row["CASE_STATUS_ID"].ToString(); ac.Case_Status_Desc = row["CASE_SATTUS_DEC"].ToString(); ac.Related_Order_Case = row["RELATED_ORDER_CASE"].ToString(); ac.CCT_Commit_Date = row["CCT_COMMIT_DATE"].ToString(); ac.Case_Contact_Info = row["CASE_CONTACT_INFO"].ToString(); ac.Case_Creation_Date = row["CASE_CREATION_DATE"].ToString(); ac.Case_Description = row["CASE_DESCRIPTION"].ToString(); ac.RBT_Acct_ID = row["RBTACCTID"].ToString(); ac.Case_Close_Date = row["CASE_CLOSE_DATE"].ToString(); ac.Case_Close_Time = row["CASE_CLOSE_TIME"].ToString(); ac.Closed_Date_Time = row["CLOSED_DATE_TIME"].ToString(); ac.Case_Closed_By = row["CASE_CLOSED_BY"].ToString(); ac.Case_TN_CKT_ID = row["CASE_TN_CKT_ID"].ToString(); ac.Case_DAC = row["CASE_DAC"].ToString(); ac.Case_CO = row["CASE_CO"].ToString(); ac.Case_COS = row["CASE_COS"].ToString(); ac.Case_Contact_Name = row["CASE_CNTCT_NAME"].ToString(); ac.Case_Cntct_Info = row["CASE_CNTCT_INFO"].ToString(); ac.Case_All_Calls = row["CASE_ALL_CALLS"].ToString(); ac.Case_All_Phones = row["CASE_ALL_PHONES"].ToString(); ac.Case_Checked_CPE = row["CASE_CHECKED_CPE"].ToString(); ac.Case_Job_ID = row["CASE_JOB_ID"].ToString(); ac.HTRC_Dispatch_Date = row["HTRC_DISPATCH_DATE"].ToString(); ac.HTRC_Dispatch_Time = row["HTRC_DISPATCH_TIME"].ToString(); ac.Dispatch_Date_Time = row["DISPATCH_DATE_TIME"].ToString(); ac.HTRC_Dispatch_Stat = row["HTRC_DISPATCH_STAT"].ToString(); ac.Dispatch_Status = row["DISPATCH_STATUS"].ToString(); ac.HTRC_Dispatch_Asgn = row["HTRC_DISPATCH_ASGN"].ToString(); cases_orders.allcases.Add(ac); } // Reg Order Results foreach (DataRow row in ds.Tables[3].Rows) { RegOrders ro = new RegOrders(); ro.Order_ID = row["ORDER_ID"].ToString(); ro.Added_By = row["ADDED_BY"].ToString(); ro.Added_On = row["ADDED_ON"].ToString(); ro.Updated_On = row["UPDATED_ON"].ToString(); ro.Updated_By = row["UPDATED_BY"].ToString(); ro.Order_Status_ID = row["ORDER_STATUS_ID"].ToString(); ro.Order_Status_Desc = row["ORDER_STATUS_DESC"].ToString(); ro.Order_Descr = row["ORDER_DESCR"].ToString(); ro.Header_Due_Date = row["HEADER_DUE_DATE"].ToString(); ro.Related_Orders = row["RELATED_ORDERS"].ToString(); ro.Tech_Assigned = ""; ro.Tech_Notes = ""; cases_orders.regorders.Add(ro); } // Reg Order Tech Notes Results foreach (DataRow row in ds.Tables[4].Rows) { RegOrderTechNotes rt = new RegOrderTechNotes(); rt.Capture_ID = row["CAPTURE_ID"].ToString(); rt.Tech_Assigned = row["TECH_ASSIGNED"].ToString(); rt.Tech_Notes = row["TECH_NOTES"].ToString(); cases_orders.regordernotes.Add(rt); } // Reg Order Due Date Results foreach (DataRow row in ds.Tables[5].Rows) { RegOrderDueDate rd = new RegOrderDueDate(); rd.Capture_ID = row["CAPTURE_ID"].ToString(); rd.Due_Date = row["DUE_DATE"].ToString(); rd.Start_Work_By_Date = row["START_WRK_BY_DATE"].ToString(); rd.Create_Date = row["CREATE_DATE"].ToString(); rd.Is_Hot_Cut = row["IS_HOT_CUT"].ToString(); cases_orders.regorderduedates.Add(rd); } // ePaper Order Results foreach (DataRow row in ds.Tables[6].Rows) { EPaperOrder eo = new EPaperOrder(); eo.EPaper_ID = row["EPAPER_ID"].ToString(); eo.EPaper_Due_Date = row["EPAPER_DUE_DATE"].ToString(); eo.EPaper_Bill_Date = row["EPAPER_BILL_DATE"].ToString(); eo.Added_On = row["ADDED_ON"].ToString(); eo.Added_By = row["ADDED_BY"].ToString(); eo.Updated_On = row["UPDATED_ON"].ToString(); eo.Updated_By = row["UPDATED_BY"].ToString(); eo.EPaper_Status_ID = row["EPAPER_STATUS_ID"].ToString(); eo.EPaper_Status_Desc = row["EPAPER_STATUS_DESC"].ToString(); eo.EPaper_Description = row["EPAPER_DESCR"].ToString(); eo.EPaper_Related_Order = row["EPAPER_RELATED_ORDER"].ToString(); eo.Strt_Work_Date = row["STRT_WRK_DATE"].ToString(); eo.Tech_Assigned = ""; eo.Tech_Notes = ""; cases_orders.epapers.Add(eo); } // ePaper Order Tech Notes Results foreach (DataRow row in ds.Tables[7].Rows) { EPaperOrderTechNotes eot = new EPaperOrderTechNotes(); eot.Capture_ID = row["CAPTURE_ID"].ToString(); eot.Tech_Assigned = row["TECH_ASSIGNED"].ToString(); eot.Tech_Notes = row["TECH_NOTES"].ToString(); cases_orders.epapernotes.Add(eot); } // Join Reg Order and Tech Notes tables (Left Outer Join) cases_orders.regorders = (from order in cases_orders.regorders join note in cases_orders.regordernotes on order.Order_ID equals note.Capture_ID into orders_notes from item in orders_notes.DefaultIfEmpty() select new RegOrders() { Order_ID = order.Order_ID, Added_By = order.Added_By, Added_On = order.Added_On, Updated_On = order.Updated_On, Updated_By = order.Updated_By, Order_Status_ID = order.Order_Status_ID, Order_Status_Desc = order.Order_Status_Desc, Order_Descr = order.Order_Descr, Header_Due_Date = order.Header_Due_Date, Related_Orders = order.Related_Orders, Tech_Assigned = item == null ? "" : item.Tech_Assigned, Tech_Notes = item == null ? "" : item.Tech_Notes }).ToList<RegOrders>(); // Join ePaper and Tech Notes tables (Left Outer Join) cases_orders.epapers = (from epaper in cases_orders.epapers join note in cases_orders.epapernotes on epaper.EPaper_ID equals note.Capture_ID into epapers_notes from item in epapers_notes.DefaultIfEmpty() select new EPaperOrder() { EPaper_ID = epaper.EPaper_ID, EPaper_Due_Date = epaper.EPaper_Due_Date, EPaper_Bill_Date = epaper.EPaper_Bill_Date, Added_On = epaper.Added_On, Added_By = epaper.Added_By, Updated_On = epaper.Updated_On, Updated_By = epaper.Updated_By, EPaper_Status_ID = epaper.EPaper_Status_ID, EPaper_Status_Desc = epaper.EPaper_Status_Desc, EPaper_Description = epaper.EPaper_Description, EPaper_Related_Order = epaper.EPaper_Related_Order, Strt_Work_Date = epaper.Strt_Work_Date, Tech_Assigned = item == null ? "" : item.Tech_Assigned, Tech_Notes = item == null ? "" : item.Tech_Notes }).ToList<EPaperOrder>(); // Explicitly close connection con.Close(); } return cases_orders; } catch (Exception) { throw; } }
private void UpdateAdminCase() { co = CaseOrderControllerSingleton.Instance().GetCaseOrder(Convert.ToInt32(txt_caseOrderID.Text)); if (co == null) { throw new Exception(); } Customer seller = CustomerControllerSingleton.Instance().GetCustomer(co.SellerId); if (co.CaseStatusId == 3) { Customer buyer = CustomerControllerSingleton.Instance().GetCustomer(co.BuyerId); tableLayoutPanel_buyerInfo.Visible = true; lbl_KoeberNavn.Text = buyer.Name; lbl_KoeberKundenummer.Text = buyer.CustomerId.ToString(); lbl_KoeberAdresse.Text = buyer.Address; lbl_KoeberTlfNr.Text = buyer.PhoneNr.ToString(); lbl_KoeberPostnummer.Text = buyer.ZipCode.ToString(); lbl_KoeberBy.Text = CustomerControllerSingleton.Instance().GetCityFromZipCode(buyer.ZipCode).ToString(); } else { tableLayoutPanel_buyerInfo.Visible = false; } lbl_SælgerKundenummer.Text = seller.CustomerId.ToString(); lbl_SælgerNavn.Text = seller.Name; lbl_SælgerAdresse.Text = seller.Address; lbl_SælgerPostnummer.Text = seller.ZipCode.ToString(); lbl_SælgerTlfNr.Text = seller.PhoneNr.ToString(); lbl_SælgerBy.Text = CustomerControllerSingleton.Instance().GetCityFromZipCode(seller.ZipCode).ToString(); dataGridView_HouseInformation.DataSource = EstateControllerSingleton.Instance().GetEstate(co.EstateId); dataGridView_PriceHistory.DataSource = CaseOrderControllerSingleton.Instance().GetPriceHistory(co.EstateId); dataGridView_HouseInformation.Columns["EstateId"].HeaderText = "EjendomsId"; dataGridView_HouseInformation.Columns["Address"].HeaderText = "Adresse"; dataGridView_HouseInformation.Columns["BuildYear"].HeaderText = "HusetsByggelsesår"; dataGridView_HouseInformation.Columns["RemodelYear"].HeaderText = "RenoveringsÅr"; dataGridView_HouseInformation.Columns["Condition"].HeaderText = "Stand"; dataGridView_HouseInformation.Columns["Areal"].HeaderText = "Areal"; dataGridView_HouseInformation.Columns["Rooms"].HeaderText = "Rum"; dataGridView_HouseInformation.Columns["Floors"].HeaderText = "Etager"; dataGridView_HouseInformation.Columns["Garden"].HeaderText = "Have"; dataGridView_HouseInformation.Columns["ZipCode"].HeaderText = "Postnummer"; dataGridView_HouseInformation.Columns["TypeId"].HeaderText = "TypeId"; dataGridView_HouseInformation.Columns["Type"].HeaderText = "Type"; dataGridView_HouseInformation.Columns["ZipCodeNavigation"].HeaderText = "PostnummerNavigation"; dataGridView_HouseInformation.Columns["CaseOrders"].HeaderText = "SagsOrdre"; dataGridView_HouseInformation.Columns["PriceHistories"].HeaderText = "PrisHistorik"; this.dataGridView_HouseInformation.Columns["ZipCodeNavigation"].Visible = false; this.dataGridView_HouseInformation.Columns["Type"].Visible = false; this.dataGridView_HouseInformation.Columns["CaseOrders"].Visible = false; this.dataGridView_HouseInformation.Columns["PriceHistories"].Visible = false; dataGridView_PriceHistory.Columns["PriceHistoryId"].HeaderText = "PrisHistorik"; dataGridView_PriceHistory.Columns["Price"].HeaderText = "Pris"; dataGridView_PriceHistory.Columns["Date"].HeaderText = "Dato"; dataGridView_PriceHistory.Columns["PriceType"].HeaderText = "PrisType"; dataGridView_PriceHistory.Columns["EstateId"].HeaderText = "EjendomsId"; dataGridView_PriceHistory.Columns["Estate"].HeaderText = "Ejendom"; this.dataGridView_PriceHistory.Columns["Estate"].Visible = false; }
public void UpdateCaseOrderStatus(CaseOrder co) { throw new NotImplementedException(); }
static IEnumerable <DerivedType> ToOrderedCases(CaseOrder caseOrder, IEnumerable <(INamedTypeSymbol symbol, BaseTypeDeclarationSyntax node, int?caseIndex, int numberOfConctreteBaseTypes)> derivedTypes, Action <Diagnostic> reportDiagnostic)