public void TestDocInsideDAO()
{
DocumentInside docInside = new DocumentInside();
DocInsideDAO dao = new DocInsideDAO();
AdministrationDAO admindao = new AdministrationDAO();
docInside.name = "Штраф за опоздание";
docInside.creationdate = Convert.ToDateTime("2019-12-12");
docInside.authorID = 1;
docInside.shelflife = Convert.ToDateTime("2022-12-12");
docInside.signerID = 1;
docInside.moneydifference = -1000;
docInside.targetID = 2;
dao.AddInside(docInside);
List <DocumentInside> diList = dao.GetAllInsides();
int pos = diList.Count() - 1;
Assert.AreEqual(docInside.toString(), diList[pos].toString());
admindao.SendForDrop(diList[pos].documentID);
admindao.DropDoc(diList[pos].documentID);
diList = dao.GetAllInsides();
pos = diList.Count() - 1;
Assert.AreNotEqual(docInside.toString(), diList[pos].toString());
}
public ActionResult DocInsideEdit(int id, DocumentInside di)
{
try
{
if (docinside.ChangeInside(id, di))
{
return(RedirectToAction("DocInsideIndex"));
}
else
{
return(View("DocInsideEdit"));
}
}
catch
{
return(View("DocInsideEdit"));
}
}
public ActionResult DocInsideCreate(DocumentInside di)
{
try
{
if (docinside.AddInside(di))
{
return(RedirectToAction("DocInsideIndex"));
}
else
{
return(View("DocInsideCreate"));
}
}
catch
{
return(View("DocInsideCreate"));
}
}
public List <DocumentInside> GetAllInsides()
{
Logger.InitLogger();
Logger.Log.Info("Метод вызова всех записей");
Connect();
List <DocumentInside> DList = new List <DocumentInside>();
try
{
SqlCommand command = new SqlCommand("select * from Document, DocumentInside where Document.documentID=DocumentInside.documentID", Connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DocumentInside inside = new DocumentInside();
inside.documentID = Convert.ToInt32(reader["documentID"]);
inside.name = Convert.ToString(reader["name"]);
inside.creationdate = Convert.ToDateTime(reader["creationdate"]);
inside.authorID = Convert.ToInt32(reader["authorID"]);
inside.status = Convert.ToString(reader["status"]);
inside.comment = Convert.ToString(reader["comment"]);
inside.shelflife = Convert.ToDateTime(reader["shelflife"]);
inside.signerID = Convert.ToInt32(reader["signerID"]);
inside.type = Convert.ToString(reader["type"]);
inside.moneydifference = Convert.ToInt32(reader["moneydifference"]);
inside.targetID = Convert.ToInt32(reader["targetID"]);
inside.documentID = Convert.ToInt32(reader["documentID"]);
DList.Add(inside);
}
reader.Close();
}
catch (Exception)
{
// Обработка исключения
}
finally
{
Disconnect();
}
return(DList);
}
public bool AddInside(DocumentInside inside)
{
bool result = true;
Connect();
try
{
SqlCommand addparent = new SqlCommand("insert into Document (name, creationdate, authorID, status, comment, shelflife, signerID, type) "
+ "VALUES (@name, @creationdate, @authorID, @status, @comment, @shelflife, @signerID, @type)", Connection);
SqlCommand addheir = new SqlCommand("insert into DocumentInside (moneydifference, targetID, documentID)"
+ "values (@moneydifference, @targetID, @documentID)", Connection);
addparent.Parameters.Add(new SqlParameter("@name", inside.name));
addparent.Parameters.Add(new SqlParameter("@creationdate", inside.creationdate));
addparent.Parameters.Add(new SqlParameter("@authorID", inside.authorID));
addparent.Parameters.Add(new SqlParameter("@status", "Создан"));
addparent.Parameters.Add(new SqlParameter("@comment", ""));
addparent.Parameters.Add(new SqlParameter("@shelflife", inside.shelflife));
addparent.Parameters.Add(new SqlParameter("@signerID", inside.signerID));
addparent.Parameters.Add(new SqlParameter("@type", "Внутренний"));
addparent.ExecuteNonQuery();
addparent.CommandText = "Select @@Identity";
int id = Convert.ToInt32(addparent.ExecuteScalar());
addheir.Parameters.Add(new SqlParameter("@moneydifference", inside.moneydifference));
addheir.Parameters.Add(new SqlParameter("@targetID", inside.targetID));
addheir.Parameters.Add(new SqlParameter("@documentID", id));
addheir.ExecuteNonQuery();
}
catch (Exception e)
{
Logger.Log.Error("ERROR: " + e.Message);
result = false;
}
finally { Disconnect(); }
return(result);
}
//public bool DropInside(int id)
//{
// bool result = true;
// Connect();
// try
// {
// string forheir = string.Format("Delete from DocumentInside where documentID='{0}'", id);
// string forparent = string.Format("Delete from Document where documentID='{0}'", id);
// SqlCommand dropheir = new SqlCommand(forheir, Connection);
// SqlCommand dropparent = new SqlCommand(forparent, Connection);
// dropheir.ExecuteNonQuery();
// dropparent.ExecuteNonQuery();
// }
// catch (Exception)
// {
// result = false;
// }
// finally { Disconnect(); }
// return result;
//}
public bool ChangeInside(int id, DocumentInside inside)
{
bool result = true;
Connect();
try
{
string forheir = string.Format("update DocumentInside set moneydifference=@moneydifference, targetID=@targetID " +
"where documentID='{0}'", id);
string forparent = string.Format("update Document set name=@name, creationdate=@creationdate, authorID=@authorID," +
" status=@status, shelflife=@shelflife, signerID=@signerID where documentID='{0}'", id);
SqlCommand changeheir = new SqlCommand(forheir, Connection);
SqlCommand changeparent = new SqlCommand(forparent, Connection);
changeheir.Parameters.AddWithValue("@moneydifference", inside.moneydifference);
changeheir.Parameters.AddWithValue("@targetID", inside.targetID);
changeparent.Parameters.AddWithValue("@name", inside.name);
changeparent.Parameters.AddWithValue("@creationdate", inside.creationdate);
changeparent.Parameters.AddWithValue("@authorID", inside.authorID);
changeparent.Parameters.AddWithValue("@status", "Создан");
changeparent.Parameters.AddWithValue("@shelflife", inside.shelflife);
changeparent.Parameters.AddWithValue("@signerID", inside.signerID);
changeparent.Parameters.AddWithValue("@type", inside.type);
changeheir.ExecuteNonQuery();
changeparent.ExecuteNonQuery();
}
catch (Exception e)
{
Logger.Log.Error("ERROR: " + e.Message);
result = false;
}
finally { Disconnect(); }
return(result);
}