public int Update(Equipments equipment) { { int rowAffected = 0; using (IDbConnection dbConnection = Connection) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@EquipmentID", equipment.EquipmentID); parameters.Add("@EquipmentCode", equipment.EquipmentCode); parameters.Add("@CategoryID", equipment.CategoryID); parameters.Add("@SubCategoryID", equipment.SubCategoryID); parameters.Add("@MaintPerodicityID", equipment.MaintPerodicityID); parameters.Add("@UnitLookupID", equipment.UnitLookupID); parameters.Add("@Specifications", equipment.Specifications); parameters.Add("@DepartmentID", equipment.DepartmentID); parameters.Add("@DateOfPurchase", equipment.DateOfPurchase); parameters.Add("@CostOfEquipment", equipment.CostOfEquipment); parameters.Add("@SupplierID", equipment.SupplierID); parameters.Add("@StatusID", equipment.StatusID); parameters.Add("@Remarks", equipment.Remarks); parameters.Add("@IsActive", equipment.IsActive); parameters.Add("@CreatedDate", equipment.CreatedDate); parameters.Add("@UpdatedDate", equipment.UpdatedDate); parameters.Add("@CreatedBy", equipment.CreatedDate); parameters.Add("@UpdatedBy", equipment.CreatedBy); rowAffected = dbConnection.Execute("sp_Update_Equipments", parameters, commandType: CommandType.StoredProcedure); } return(rowAffected); } }
public void Add(Equipments equip) { using (IDbConnection dbConnection = Connection) { using (SqlCommand cmd = new SqlCommand("sp_Insert_Equipments")) { cmd.CommandType = CommandType.StoredProcedure; Connection.Open(); cmd.ExecuteNonQuery(); } } }