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)
