public int Insert(Feedback entity)
{
string sql = "INSERT INTO Feedback(Feedback_Details,bid,event_type) VALUES('" + entity.Feedback_Details + "','" + entity.Id + "','" + entity.Event_Type + "')";
return(dataAccess.ExecuteQuery(sql));
}
public int Insert(Category obj, int uID)
{
string sql = "INSERT INTO Categories(Category_Name,Category_Color,User_ID) VALUES('" + obj.Name + "','" + obj.Color + "','" + obj.UserID + "')";
return(dataAccess.ExecuteQuery(sql));
}
public int Insert(CustHistory his)
{
string sql = "Insert into CustomerHistories (Date,Contact,SaleId,MedName,Quantity) values ('" + his.Date + "'," + his.Contact + "," + his.SaleId + ",'" + his.MedName + "'," + his.Quantity + ")";
return(dataAccess.ExecuteQuery(sql));
}
public int Insert(Profit prof)
{
string sql = "Insert into Profits (SaleId,MedId,Date,Income) values (" + prof.SaleId + "," + prof.MedId + ",'" + prof.Date.ToString() + "'," + prof.Income + ")";
return(dataAccess.ExecuteQuery(sql));
}
public void Delete(int taskID)
{
string sql = "Delete from NotifiyTime where Task_ID = " + taskID;
dataAccess.ExecuteQuery(sql);
sql = "Delete from Tasks where Task_ID = " + taskID;
dataAccess.ExecuteQuery(sql);
}
public int Delete(int viewerID)
{
string sql = "DELETE FROM SharedTasks WHERE Viewer_ID ='" + viewerID;
return(dataAccess.ExecuteQuery(sql));
}
public int Insert(Credential entity)
{
string sql = "Insert into Credentials (UserId,Password,Type) Values (" + entity.UserId + ",'" + entity.Password + "'," + entity.Type + ")";
return(dataAccess.ExecuteQuery(sql));
}
public int Insert(Purchase pur)
{
string sql = "Insert into Purchases (SaleId,MedId,MedName,UnitPrice,Quantity,Amount) values (" + pur.SaleId + "," + pur.MedId + ",'" + pur.MedName + "'," + pur.UnitPrice + "," + pur.Quantity + "," + pur.Amount + ")";
return(dataAccess.ExecuteQuery(sql));
}
