private void CaseUpdateForm_Load(object sender, EventArgs e) { lblDate.Text = orderDate.Date.ToShortDateString(); CaseReport[] getMyInfo = CaseReport.CaseReport_GetByDates(orderDate.Date, orderDate.Date); theReport = getMyInfo[0]; txtResmi.Text = theReport.ResmiAll.ToString(); txtCompany.Text = theReport.GayriResmiAll.ToString(); txtEarn.Text = theReport.Earn.ToString(); txtNeccessary.Text = theReport.TotalMoney.ToString(); lblTotalMoney.Text = (theReport.ResmiAll + theReport.GayriResmiAll + theReport.Earn).ToString(); }
public static CaseReport[] CaseReport_GetAll() { string query = "CaseReport_GetAll"; DataTable dt = Connection.runQuery(query, new SqlParameter[0]); List<CaseReport> res = new List<CaseReport>(); for (int i = 0; i < dt.Rows.Count; i++) { CaseReport tmp = new CaseReport(); tmp.CreditCard = Convert.ToDecimal(dt.Rows[i]["CreditCard"].ToString()); tmp.Description = dt.Rows[i]["Description"].ToString(); tmp.Earn = Convert.ToDecimal(dt.Rows[i]["Earn"].ToString()); tmp.GayriResmiAll = Convert.ToDecimal(dt.Rows[i]["GayriResmiAll"].ToString()); tmp.Havale = Convert.ToDecimal(dt.Rows[i]["Havale"].ToString()); tmp.OrderDoneDate = Convert.ToDateTime(dt.Rows[i]["OrderDoneDate"].ToString()); tmp.ResmiAll = Convert.ToDecimal(dt.Rows[i]["ResmiAll"].ToString()); tmp.Status = Convert.ToInt16(dt.Rows[i]["Status"].ToString()); tmp.TotalCash = Convert.ToDecimal(dt.Rows[i]["TotalCash"].ToString()); tmp.TotalMoney = Convert.ToDecimal(dt.Rows[i]["TotalMoney"].ToString()); res.Add(tmp); } return res.ToArray(); }