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