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)); }