public bool addOtherCost(OtherCost input)
{
bool insert = false;
try
{
string query = "dbo.addOtherCost";
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["CarDiaryDB"].ToString());
SqlCommand cmd = new SqlCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = query;
cmd.Connection = conn;
//set up the parameters
cmd.Parameters.Add("@car", System.Data.SqlDbType.Int);
cmd.Parameters.Add("@cat", System.Data.SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@dat", System.Data.SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@mil", System.Data.SqlDbType.Int);
cmd.Parameters.Add("@cost", System.Data.SqlDbType.Float);
cmd.Parameters.Add("@not", System.Data.SqlDbType.NVarChar, 1000);
//set parameter values
cmd.Parameters["@car"].Value = input.getCar_id();
cmd.Parameters["@cat"].Value = input.getCategory();
cmd.Parameters["@dat"].Value = input.getDate();
cmd.Parameters["@mil"].Value = input.getMileage();
cmd.Parameters["@cost"].Value = input.getTotal_cost();
cmd.Parameters["@not"].Value = input.getNotes();
cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery();
insert = true;
conn.Close();
}
catch (Exception ex)
{
insert = false;
// Log the exception.
ExceptionUtility.LogException(ex, "DB.cs");
}
return insert;
}
private void fillOtherRow(int count, OtherCost item)
{
Table tbl = new Table();
tbl.Width = new Unit("100%");
tbl.Height = new Unit("100%");
tbl.Style.Add("min-width", "330px !important");
//------------------row-----------------------
TableRow rw = new TableRow();
if (count % 2 == 0)
rw.BackColor = System.Drawing.Color.White;
else
rw.BackColor = System.Drawing.Color.LightGray;
//---------------------cell--------------
TableCell cell = new TableCell();
cell.Width = new Unit("10%");
Label date = new Label();
date.Width = new Unit("100%");
date.Style.Add("text-align", "center");
date.Font.Size = 10;
date.Text = item.getDate();
cell.Controls.Add(date);
rw.Cells.Add(cell);
//---------------------cell--------------
cell = new TableCell();
cell.Width = new Unit("15%");
Label mileage = new Label();
mileage.Width = new Unit("100%");
mileage.Style.Add("text-align", "center");
mileage.Font.Size = 10;
mileage.Text = item.getMileage().ToString("0.##");
cell.Controls.Add(mileage);
rw.Cells.Add(cell);
//---------------------cell--------------
cell = new TableCell();
cell.Width = new Unit("50%");
Label category = new Label();
category.Width = new Unit("100%");
category.Style.Add("text-align", "center");
category.Font.Size = 10;
category.Text = item.getCategory();
cell.Controls.Add(category);
rw.Cells.Add(cell);
//---------------------cell--------------
cell = new TableCell();
cell.Width = new Unit("10%");
Label price = new Label();
price.Width = new Unit("100%");
price.Style.Add("text-align", "center");
price.Font.Size = 10;
price.Text = item.getTotal_cost().ToString("0.##");
cell.Controls.Add(price);
rw.Cells.Add(cell);
//---------------------cell--------------
cell = new TableCell();
cell.Width = new Unit("8%");
ImageButton delete = new ImageButton();
//Image img = new Image();
//img.ImageUrl = "~/delete.ico";
//delete.BackgroundImage = img;
delete.ImageUrl = "~/Images/delete.png";
delete.Style.Add("height", "20px");
delete.Style.Add("width", "20px");
delete.ID = "DeleteOther" + item.getId();
delete.Click += new ImageClickEventHandler(DeleteOtherCost_Click);
delete.ToolTip = "Изтрий";
cell.Controls.Add(delete);
rw.Cells.Add(cell);
//---------------------cell--------------
cell = new TableCell();
cell.Width = new Unit("7%");
ImageButton notes = new ImageButton();
notes.ImageUrl = "~/Images/icon_note.png";
notes.Style.Add("height", "20px");
notes.Style.Add("width", "20px");
notes.ID = "Notes" + item.getId();
//notes.Click += new ImageClickEventHandler(ShowNotes_Click);
string noteText = item.getNotes();
if (!noteText.Equals(""))
notes.ToolTip = noteText;
else
notes.ToolTip = "Няма въведени записки за този разход";
notes.Enabled = false;
cell.Controls.Add(notes);
rw.Cells.Add(cell);
tbl.Controls.Add(rw);
Panel2.Controls.Add(tbl);
}