public int UpdateSchemeProduct(SchemeProduct schemeProduct)
{
string sql = @"UPDATE [SchemeProduct] SET [SchemeId] = @SchemeId, [ProductId] = @ProductId, [IsActive] = @IsActive, [LastUpdatedById] = @LastUpdatedById, [LastUpdatedDate] = @LastUpdatedDate WHERE [Id] = @Id";
var id = db.Connection.Query <int>(sql, schemeProduct).FirstOrDefault();
return(id);
}
public int InsertSchemeProduct(SchemeProduct schemeProduct)
{
string sql = @"INSERT INTO [SchemeProduct] ([SchemeId],[ProductId],[IsActive], [CreatedById], [CreatedDate], [LastUpdatedById], [LastUpdatedDate])
VALUES (@SchemeId, @ProductId, @IsActive, @CreatedById, @CreatedDate, @LastUpdatedById, @LastUpdatedDate); SELECT CAST(SCOPE_IDENTITY() as int)";
var id = db.Connection.Query <int>(sql, schemeProduct).FirstOrDefault();
return(id);
}
