private bool Add(Companie companie)
{
bool isSucces = false;
try
{
sqlConnection = new SqlConnection(connectionString);
string query = @"INSERT INTO Companies (Name) VALUES ('" + companie.Name + "')";
//5
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
//6
sqlConnection.Open();
//7
int isExecuted = sqlCommand.ExecuteNonQuery();
if (isExecuted > 0)
{
isSucces = true;
}
else
{
isSucces = false;
}
//8
sqlConnection.Close();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
return(isSucces);
}
public void CompanieArrToForm(ComboBox comboBox, bool isMustChoose, Companie curCompanie = null)
{
//ממירה את הטנ "מ אוסף ישובים לטופס
CompanieArr companieArr = new CompanieArr();
//הוספת ישוב ברירת מחדל - בחר ישוב
//יצירת מופע חדש של ישוב עם מזהה מינוס 1 ושם מתאים
Companie companieDefault = new Companie();
companieDefault.Id = -1;
if (isMustChoose)
{
companieDefault.Name = "choice a companie";
}
else
{
companieDefault.Name = "All companie";
}
//הוספת הישוב לאוסף הישובים - אותו נציב במקור הנתונים של תיבת הבחירה
companieArr.Add(companieDefault);
companieArr.Fill();
comboBox_Companie.DataSource = companieArr;
comboBox_Companie.ValueMember = "ID";
comboBox_Companie.DisplayMember = "Name";
if (curCompanie != null)
{
comboBox_Companie.SelectedValue = curCompanie.Id;
}
}
public ActionResult DeleteConfirmed(int id)
{
Companie companie = db.Companies.Find(id);
db.Companies.Remove(companie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,parent_id,name,earnings")] Companie companie)
{
if (ModelState.IsValid)
{
db.Entry(companie).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(companie));
}
public ActionResult Create([Bind(Include = "id,parent_id,name,earnings")] Companie companie)
{
if (ModelState.IsValid)
{
db.Companies.Add(companie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(companie));
}
// GET: Company/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Companie companie = db.Companies.Find(id);
if (companie == null)
{
return(HttpNotFound());
}
return(View(companie));
}
private void Companies(object sender, EventArgs e)
{
Companie companiePage = new Companie();
Application.Current.MainPage = companiePage;
}