public ActionResult DocSaleEdit(int id, DocumentSale ds)
{
try
{
if (docsale.ChangeSale(id, ds))
{
return(RedirectToAction("DocSaleIndex"));
}
else
{
return(View("DocSaleEdit"));
}
}
catch
{
return(View("DocSaleEdit"));
}
}
public ActionResult DocSaleCreate(DocumentSale ds)
{
try
{
if (docsale.AddSale(ds))
{
return(RedirectToAction("DocSaleIndex"));
}
else
{
return(View("DocSaleCreate"));
}
}
catch
{
return(View("DocSaleCreate"));
}
}
public List <DocumentSale> GetAllSales()
{
Logger.InitLogger();
Logger.Log.Info("Метод вызова всех записей");
Connect();
List <DocumentSale> DList = new List <DocumentSale>();
try
{
SqlCommand command = new SqlCommand("select * from Document, DocumentSale where Document.documentID=DocumentSale.documentID;", Connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DocumentSale sale = new DocumentSale();
sale.documentID = Convert.ToInt32(reader["documentID"]);
sale.name = Convert.ToString(reader["name"]);
sale.creationdate = Convert.ToDateTime(reader["creationdate"]);
sale.authorID = Convert.ToInt32(reader["authorID"]);
sale.status = Convert.ToString(reader["status"]);
sale.comment = Convert.ToString(reader["comment"]);
sale.shelflife = Convert.ToDateTime(reader["shelflife"]);
sale.signerID = Convert.ToInt32(reader["signerID"]);
sale.type = Convert.ToString(reader["type"]);
sale.productname = Convert.ToString(reader["productname"]);
sale.productammount_num = Convert.ToInt32(reader["productammount_number"]);
sale.productprice_for_one = Convert.ToInt32(reader["productprice"]);
sale.buyerID = Convert.ToInt32(reader["buyerID"]);
DList.Add(sale);
}
reader.Close();
}
catch (Exception)
{
// Обработка исключения
}
finally
{
Disconnect();
}
return(DList);
}
public bool AddSale(DocumentSale sale)
{
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 DocumentSale (productname, productammount_number, productprice, buyerID, documentID)"
+ "values (@productname, @productammount_number, @productprice, @buyerID, @documentID);", Connection);
addparent.Parameters.AddWithValue("@name", sale.name);
addparent.Parameters.AddWithValue("@creationdate", sale.creationdate);
addparent.Parameters.AddWithValue("@authorID", sale.authorID);
addparent.Parameters.AddWithValue("@status", "Создан");
addparent.Parameters.AddWithValue("@comment", "");
addparent.Parameters.AddWithValue("@shelflife", sale.shelflife);
addparent.Parameters.AddWithValue("@signerID", sale.signerID);
addparent.Parameters.AddWithValue("@type", "Продажи");
addparent.ExecuteNonQuery();
addparent.CommandText = "Select @@Identity";
int id = Convert.ToInt32(addparent.ExecuteScalar());
Logger.Log.Info("Значение переменной id:" + id);
addheir.Parameters.AddWithValue("@productname", sale.productname);
addheir.Parameters.AddWithValue("@productammount_number", sale.productammount_num);
addheir.Parameters.AddWithValue("@productprice", sale.productprice_for_one);
addheir.Parameters.AddWithValue("@buyerID", sale.buyerID);
addheir.Parameters.AddWithValue("@documentID", id);
addheir.ExecuteNonQuery();
}
catch (Exception e)
{
Logger.Log.Error("ERROR: " + e.Message);
result = false;
}
finally { Disconnect(); }
return(result);
}
//public bool DropSale(int id)
//{
// bool result = true;
// Connect();
// try
// {
// string forheir = string.Format("Delete from DocumentSale 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 ChangeSale(int id, DocumentSale sale)
{
bool result = true;
Connect();
try
{
string forheir = string.Format("update DocumentSale set productname=@productname, productammount_number=@productammount_number, " +
"productprice=@productprice, buyerID=@buyerID where documentID='{0}'", id);
string forparent = string.Format("update Document set name=@name, creationdate=@creationdate, authorID=@authorID," +
" status=@status, comment=@comment, shelflife=@shelflife, signerID=@signerID, type=@type where documentID='{0}'", id);
SqlCommand changeheir = new SqlCommand(forheir, Connection);
SqlCommand changeparent = new SqlCommand(forparent, Connection);
changeheir.Parameters.AddWithValue("@productname", sale.productname);
changeheir.Parameters.AddWithValue("@productammount_number", sale.productammount_num);
changeheir.Parameters.AddWithValue("@productprice", sale.productprice_for_one);
changeheir.Parameters.AddWithValue("@buyerID", sale.buyerID);
changeparent.Parameters.AddWithValue("@name", sale.name);
changeparent.Parameters.AddWithValue("@creationdate", sale.creationdate);
changeparent.Parameters.AddWithValue("@authorID", sale.authorID);
changeparent.Parameters.AddWithValue("@status", "Создан");
changeparent.Parameters.AddWithValue("@comment", sale.comment);
changeparent.Parameters.AddWithValue("@shelflife", sale.shelflife);
changeparent.Parameters.AddWithValue("@signerID", sale.signerID);
changeparent.Parameters.AddWithValue("@type", sale.type);
changeheir.ExecuteNonQuery();
changeparent.ExecuteNonQuery();
}
catch (Exception)
{
result = false;
}
finally { Disconnect(); }
return(result);
}
public Document GetById(int id)
{
Connect();
Document D = new Document();
try
{
string forsearch = string.Format("select * from Document where documentID='{0}'", id);
SqlCommand command = new SqlCommand(forsearch, Connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DocumentSale doc = new DocumentSale();
doc.documentID = Convert.ToInt32(reader["documentID"]);
doc.name = Convert.ToString(reader["name"]);
doc.creationdate = Convert.ToDateTime(reader["creationdate"]);
doc.authorID = Convert.ToInt32(reader["authorID"]);
doc.status = Convert.ToString(reader["status"]);
doc.comment = Convert.ToString(reader["comment"]);
doc.shelflife = Convert.ToDateTime(reader["shelflife"]);
doc.signerID = Convert.ToInt32(reader["signerID"]);
doc.type = Convert.ToString(reader["type"]);
D = doc;
}
reader.Close();
}
catch (Exception)
{
// Обработка исключения
}
finally
{
Disconnect();
}
return(D);
}
public List <Document> GetAllWaitingForSign()
{
Connect();
List <Document> DList = new List <Document>();
try
{
SqlCommand command = new SqlCommand("select * from Document where status='Отправлен на подписание'", Connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DocumentSale doc = new DocumentSale();
doc.documentID = Convert.ToInt32(reader["documentID"]);
doc.name = Convert.ToString(reader["name"]);
doc.creationdate = Convert.ToDateTime(reader["creationdate"]);
doc.authorID = Convert.ToInt32(reader["authorID"]);
doc.status = Convert.ToString(reader["status"]);
doc.comment = Convert.ToString(reader["comment"]);
doc.shelflife = Convert.ToDateTime(reader["shelflife"]);
doc.signerID = Convert.ToInt32(reader["signerID"]);
doc.type = Convert.ToString(reader["type"]);
DList.Add(doc);
}
reader.Close();
}
catch (Exception)
{
// Обработка исключения
}
finally
{
Disconnect();
}
return(DList);
}