public async Task <int> AddAsync(POActivity poActivity) { var cmd = QueriesCreatingHelper.CreateQueryInsert(poActivity); cmd += ";SELECT LAST_INSERT_ID();"; return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First()); }
public static int Insert(POActivity POA) { string query = "INSERT INTO POActivity VALUES(@PurchaseOrderID,@ActivityType,@ActivityDate,@StaffID,@SupplierID,@Remarks,@FCAID,@ICAID)"; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@PurchaseOrderID", POA.PurchaseOrderID)); parameters.Add(new SqlParameter("@ActivityType", POA.ActivityType)); parameters.Add(new SqlParameter("@ActivityDate", POA.ActivityDate)); parameters.Add(new SqlParameter("@StaffID", POA.StaffID)); parameters.Add(new SqlParameter("@SupplierID", POA.SupplierID)); parameters.Add(new SqlParameter("@Remarks", POA.Remarks)); parameters.Add(new SqlParameter("@FCAID", POA.FCAID)); parameters.Add(new SqlParameter("@ICAID", POA.ICAID)); return(DBHelper.ModifyData(query, parameters)); }
public static int Update(POActivity POA) { string query = "UPDATE POActivity SET PurchaseOrderID = @PurchaseOrderID, ActivityType = @ActivityType,ActivityDate = @ActivityDate,StaffID = @StaffID,SupplierID = @SupplierID,Remarks = @Remarks,FCAID=@FCAID,ICAID=@ICAID WHERE POActivityID = @POActivityID"; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@POActivityID", POA.POActivityID)); parameters.Add(new SqlParameter("@PurchaseOrderID", POA.PurchaseOrderID)); parameters.Add(new SqlParameter("@ActivityType", POA.ActivityType)); parameters.Add(new SqlParameter("@ActivityDate", POA.ActivityDate)); parameters.Add(new SqlParameter("@StaffID", POA.StaffID)); parameters.Add(new SqlParameter("@SupplierID", POA.SupplierID)); parameters.Add(new SqlParameter("@Remarks", POA.Remarks)); parameters.Add(new SqlParameter("@FCAID", POA.FCAID)); parameters.Add(new SqlParameter("@ICAID", POA.ICAID)); return(DBHelper.ModifyData(query, parameters)); }
public static POActivity SelectByPK(int ID) { string query = "SELECT * FROM POActivity WHERE POActivityID = @ID"; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@ID", ID)); DataTable dt = DBHelper.SelectData(query, parameters); POActivity POA = new POActivity(); POA.POActivityID = ID; POA.PurchaseOrderID = Convert.ToInt32(dt.Rows[0]["PurchaseOrderID"].ToString()); POA.ActivityType = dt.Rows[0]["ActivityType"].ToString(); POA.ActivityDate = Convert.ToDateTime(dt.Rows[0]["ActivityDate"].ToString()); POA.StaffID = Convert.ToInt32(dt.Rows[0]["StaffID"].ToString()); POA.SupplierID = Convert.ToInt32(dt.Rows[0]["SupplierID"].ToString()); POA.Remarks = dt.Rows[0]["Remarks"].ToString(); POA.FCAID = Convert.ToInt32(dt.Rows[0]["FCAID"].ToString()); POA.ICAID = Convert.ToInt32(dt.Rows[0]["ICAID"].ToString()); return(POA); }